How to build a linq query from string?

Question

Possible Duplicate:
Parse string into a LINQ query

Iam trying to build a linq query, from string but confused.

From the below query string MyRptStrng is having the conditions...

string MyLnqBuildStr="(from DataRow DR1 in MyEmpTbl.AsEnumerable() orderby Convert.ToInt32(DR1['emp_no']) where " + ???????MyRptStrng + " select DR1).ToList()";


var GRNMultiRslt = MyLnqBuildStr;

DataTable GRNPrtDTB = GRNMultiRslt.CopyToDataTable();

And Iam getting the error - char cannot be used as type parameter 'T' in generic type...

Thanks

What makes you think [query expressions](http://msdn.microsoft.com/en-us/library/bb397676.aspx) are strings? — Frédéric Hamidi, Jan 06 '12 at 20:31
@FrédéricHamidi: presumably LOGAN is loading the query from some other resource (like a database table). — NotMe, Jan 06 '12 at 20:34

score 2 · Answer 1 · answered Jan 06 '12 at 20:35

2

This won't work. At all. You can't (in any easy way) execute a string that contains a query expression. Perhaps you want to use SQL instead?

answered Jan 06 '12 at 20:35

Jason Malinowski

18,148
1
38
55

SQL Ican do..Thanks for all replies.. – LOGAN Jan 06 '12 at 20:40
he can actually. I know this question is old but I suggest trying the `Gridify` library. https://github.com/alirezanet/Gridify – AliReza Sabouri Sep 18 '21 at 13:12

How to build a linq query from string?

1 Answers1