Please converty SQL Query to LINQ

Question

User559635304 posted

select * from CTDFields where CategoryTypeDetailId

in (select CategoryTypeDetailID from CategoryTypeDetail

where DetailID=4)

Answer 1

User-661350001 posted

var dids = CategoryTypeDetail.Where(ctd => ctd.DetailID=4).Select(ctd=>ctd.CategoryTypeDetailID)

CTDFields.Where(ctd=> dids.Contains(ctd.CategoryTypeDetailId))

Answer 2

User559635304 posted

Hi,

Thanks for your response.

But this code is getting error at where condition of first line and CTDFields at second line.

Can you please fix this.

Regards,

Kishore.Jetty

Answer 3

User3866881 posted

Hello kishorejetty：）

in C#，when we want to compare things with each other，we should use "==" instead of "="，So plz have a try like this：

var dids = CategoryTypeDetail.Where(ctd => ctd.DetailID==4).Select(ctd=>ctd.CategoryTypeDetailID)

CTDFields.Where(ctd=> dids.Contains(ctd.CategoryTypeDetailId))