Monday, 18 November 2013

how to write 'where in' style queries using linq to entities

string SerialNoCollection ="SR-1,SR-2,SR-3,SR-4,SR-5,SR-6";
 var serialNo = SerialNoCollection.Split(',').Select(x => x);

var myFilterData =  from asset in tblAssets where
                        (!serialNo.Any() || serialNo.Contains(asset.Serial_No))
                        select asset ;       

No comments:

Post a Comment