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))

posted @ 2011-10-08 11:39  Lyle Blog  阅读(755)  评论(0)    收藏  举报