How to use variable inside Select() in linq

Ajeet Singh

Finding the person whose SSN = 203456876 in the list"

foreach (DataRow o in dt.Select("SSN = '203456876'"))

{

}

string str = "asfdsfds";

How to use str instead ''203456876'?

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Gajendra Jangid7y ago
Accepted answer
hello dear,

use this code:
var lst= from tb in dt.Asenumerable() where tb.field<string>("SSN")==203456876"
select tb;
Jignesh Kumar7y ago
Hey Ajit,

If you are trying to query datatable then you can use like below,
var query = from r in dt1.AsEnumerable()
                        where r.Field<string>("SSN") == YourStringName
                        select new
                        {
                            ssn= r["SSN"].ToString(),
                            fireld1= r["field1"].ToString()

                       };
For your reference you can use this link,
https://www.c-sharpcorner.com/blogs/select-query-on-datatable-for-filtering-data-using-linq1
Vivek Kumar7y ago
Hi Ajeet,
You can use a variable inside Select() in linq. Have a look to below link for your reference.

https://stackoverflow.com/questions/29251075/declare-variable-within-linq-selectx-new
Rajanikant Hawaldar7y ago
Hi Ajeet Singh,

refer this link

https://stackoverflow.com/questions/31308573/filtering-a-nested-collection-using-linq

You can declare a variable inside a Select like this:-
noneRequiredUserDocuments = docs.Select(x =>
{
var src= _storageService.GetFileUrl(x.FileName);
return new NoneRequiredUserDocument
{
StudentDocument = x,
Src = src,
ThumbnailImageUrl = ImageHelper.ThumbnailImageUrl(src, 75);
};
}).ToList();
In query syntax doing this is equivalent to:-
from x in docs
let src= _storageService.GetFileUrl(x.FileName)
select and so on