How to create dynamic Linq to SQL in Vb.net
Are you looking for a way to create dynamic Linq to SQL in Vb.net ? then read this thread to know more about it
I have inline and dynamic SQL query like
Dim SQL as string ="sSelect" & Top & "i1.f1,i2.f2" & sselect &
"from table1 i1 inner join table i2 on i1.eventseriesID=i2.eventseriesID " & Sjoin &
& " where i1.binheritseries=1 "
if where <>"" then
SQL &="order By" & OrderBy
In this Top,sselect,Sjoin are extra selected fields ,fields and additional Join sequentially.
Now i want this query as LINQ using dbml file with correct table association and string expression linq.I tried to get help from above link
But i couldnt succeed.tell me proper solution to build linq with expression