How to change this query to LinqToSql
Hi all!
I am building dynamic queries with Dynamic Linq API. I have a query -which works- like below, and i have to change it to LinqToSql statement. This is about selecting items from checkboxes by users and provdes all the conditions that user selected.
ei.EstateID in(select EstateID from EstateProperty where
EstateID in(select EstateID from EstateProperty where PropertyID=3) and PropertyID= 4)
Any ideas?