How to build dynamic Linq query ?

Question

What can I do to dynamically create queries when I do have this type of string ?

I want to transform this :

SELECT [Extent1].[TASK_ORDER] AS [TASK_ORDER] FROM [dbo].[CR_TASK] AS [Extent1]

to this :

context.CR_TASK.Where(a => a.TASK_NO == id).Select(a => a.TASK_NO);

Ali Dehghan · Accepted Answer · 2014-04-07 09:29:13Z

1

You could use dynamic linq (http://dynamiclinq.codeplex.com/) easily which is capable of doing all dynamic operations on linq and strings

answered Apr 7, 2014 at 9:29

Ali Dehghan

4623 silver badges6 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

how can we use this reference ?

Download from the site, extract it, add the library (dll) into your project, see the sample (on the site), write your queries.

Or you can get it using NuGet nuget.org/packages/System.Linq.Dynamic.Library. This is more current and if you use .NET 4.0+, it adds support for the dynamic keyword.