在ASP.NET MVC中转换查询SQL Server

Question

我想在.NET MVC中使用以下SQL Server查询，

select *
from table1
where a = 1
and b not in (select fk_b from table2 where c = 1)

但我不知道如何？

entity.table1.Where(record => record.a== 1 && record ....???

Answer 1

在LINQ查询语法中，查询应为：

var result = (
    from a in entity.table1
    where a.a == 1
    and  
    !(
        from b in entity.table2
        where b.c == 1
        select b.fk_b
    ).Contains(a.b)
    select a
).ToList();

在方法表达式中，

var result = entity.table1.Where(record => record.a == 1
    && !entity.table2.Select(y => y.fk_b).Contains(record.b))
    .ToList();