Click here to Skip to main content
15,881,836 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I have inline and dynamic SQL query like

VB
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
End if

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
http://stackoverflow.com/questions/13995212/technique-for-dynamically-adding-a-join-to-a-linq-query[^]
But i couldnt succeed.Please tell me anybody Its very urgent
Posted
Updated 3-Mar-15 19:29pm
v2

1 solution

Have a look at similar question: Hotw to create Dynamic Linque To set[^]
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900