SQL LINQ比對

  • 82
  • 0

筆記

COUNT()

var o = (from a in TABLEs
         where 欄位條件
         select 欄位).Count();

 TOP 100

var o = (from a in TABLEs
         where 欄位條件
         select 欄位).Take(100);