Dynamic LINQ (Part 1: Using the LINQ Dynamic Query Library)

Why not join our community?, there are 15 users online

home
linq
view story

DotNetKick.com is an open-source project. Please report any bugs and let us know your great suggestions. Currently running svn revision 620 (rss)

Kick Spy!, Kick Zeitgeist and Kick Widgets

36
kicks

kick it

Dynamic LINQ (Part 1: Using the LINQ Dynamic Query Library)

published 9 months, 2 days ago, submitted by

Jemm 9 months, 2 days ago

weblogs.asp.net — While writing type-safe queries is great for most scenarios, there are cases where you want the flexibility to dynamically construct queries on the fly. For example: you might want to provide business intelligence UI within your application that allows an end-user business analyst to use drop-downs to build and express their own custom queries/views on top of data.

1 comment | category: Linq | Views: 21 | Get KickIt image code

tags: Database, C#, LINQ, ScottGu | tag it

Everyones tags:

Your tags:

Please login or signup.

Add a live kick counter to your blog >> liveImage

You can even customize the image by choosing your own colors, and then clicking the button below to update the preview and the html code:

"Kick It" text
"Kick It" background
kick count text
kick count background
border

Simply copy and paste this HTML into your blog post.

Users who kicked this story:

Jemm - scott -

alley - turtlespin -

catto - CompiledMonkey -

JudahGabriel - Ambrose - csharpnjava - mcp111 -

powerrush -

TroyMG - zionicion - hackman -

gavinjoyce - zvikara -

korayem - mghaoui - aabs -

DuncanChud -

samAdams - smallfox - Reman - khushal999p - Aaronontheweb - BabyCoder - rodiniz - Tigraine - CodeFuzion - Michelle10 -

simoneb - adron - Golo - skpananghat - dstar01 -

tendrel

Comments:

How do I make this dynamic only one Query

WaDBLinQ db = new WaDBLinQ();

var res = from allPer in db.a_allPerson_CL
from premList in allPer.a_crmListsPermission_List
where allPer.allPerID == userAllPerID
orderby premList.a_crmListsName_Obj.crmLNaName + " "
select new { premList.crmLPeCanDelete, premList.a_crmListsName_Obj.crmLNaID, crmLNaName = premList.a_crmListsName_Obj.crmLNaName + " (" + premList.a_crmListsName_Obj.a_crmLists_List.Count().ToString() + ")" };
if (crmCTyID > 0)
res = from allPer in db.a_allPerson_CL
from premList in allPer.a_crmListsPermission_List
where allPer.allPerID == userAllPerID && (int)premList.a_crmListsName_Obj.crmCTyID == crmCTyID
orderby premList.a_crmListsName_Obj.crmLNaName
select new { premList.crmLPeCanDelete, premList.a_crmListsName_Obj.crmLNaID, crmLNaName = premList.a_crmListsName_Obj.crmLNaName + " (" + premList.a_crmListsName_Obj.a_crmLists_List.Count().ToString() + ")" };

posted by Walla 9 months ago