How to use variable inside Select() in linq

Question

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'?

Gajendra Jangid · Answer

hello dear, use this code: var lst= from tb in dt.Asenumerable() where tb.field string >( "SSN" )==203456876" select tb;

Vivek Kumar · Answer

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

Jignesh Kumar · Answer

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

Rajanikant Hawaldar · Answer

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