Linq to sql 中解析成in查询写法
实例:
public IList<Print_ExpressSetout> Test(int fastId, IList<string> expressNo)
{
var q = (from p in db.Print_ExpressSetout where p.expressType == fastId && expressNo.ToArray<string>().Contains(p.expressNo) select p);
return q.ToList<Print_ExpressSetout>();
}
解析出的sql语句为:
SELECT [t0].[expressId], [t0].[expressType], [t0].[expressNo], [t0].[createManageId], [t0].[createTime], [t0].[useManageId], [t0].[useTime],
[t0].[currentState], [t0].[myorderId], [t0].[exception], [t0].[jobId], [t0].[printerId]
FROM [dbo].[Print_ExpressSetout] AS [t0]
WHERE ([t0].[expressType] = @p0)
AND ([t0].[expressNo] IN (@p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10, @p11, @p12, @p13, @p14, @p15, @p16, @p17, @p18, @p19, @p20, @p21))

浙公网安备 33010602011771号