Does anyone know how to transform the following "select" into a lambda expression?
有谁知道如何将以下“选择”转换为lambda表达式?
SELECT * FROM table1 WHERE OID IN (SELECT OIDPhone FROM table2 WHERE city = 'New York')
SELECT * FROM table1 WHERE OID IN(SELECT OIDPhone FROM table2 WHERE city ='New York')
1 个解决方案
#1
2
You can do:
你可以做:
var subQuery = db.OIDPhone.Where(r=> r.City == "New York").Select(r=> r.OIDPhone);
var finalQuery = db.Table1.Where(r=> subQuery.Contains(r.OID));
#1
2
You can do:
你可以做:
var subQuery = db.OIDPhone.Where(r=> r.City == "New York").Select(r=> r.OIDPhone);
var finalQuery = db.Table1.Where(r=> subQuery.Contains(r.OID));