Convert SQL Query to LINQ

select * from CTDFields where CategoryTypeDetailId

in (select CategoryTypeDetailID from CategoryTypeDetail

where DetailID=4)

</div>

Re: Convert SQL Query to LINQ

Try following:

var t = from item in Context.CTDFields.ToList()

Where (from cat in Context.CategoryTypeDetail.ToList()

Where cat.DetailID = 4

Select cat.CategoryTypeDetailID ).Contains(item.CategoryTypeDetailId)

Select item;

Re: Convert SQL Query to LINQ

I think inner join solved your issue

var Data1=( from CTD in db.CTDFields
            join CategoryType in db.CategoryTypeDetailID
            on  CTD.CategoryTypeDetailId equals CategoryType.CategoryTypeDetailID
             where CategoryType.DetailID==4).ToList();

Re: Convert SQL Query to LINQ

kishorejetty
kishorejetty

A duplicated issue was found athttp://forums.asp.net/t/1807402.aspx