<ruby id="bdb3f"></ruby>

    <p id="bdb3f"><cite id="bdb3f"></cite></p>

      <p id="bdb3f"><cite id="bdb3f"><th id="bdb3f"></th></cite></p><p id="bdb3f"></p>
        <p id="bdb3f"><cite id="bdb3f"></cite></p>

          <pre id="bdb3f"></pre>
          <pre id="bdb3f"><del id="bdb3f"><thead id="bdb3f"></thead></del></pre>

          <ruby id="bdb3f"><mark id="bdb3f"></mark></ruby><ruby id="bdb3f"></ruby>
          <pre id="bdb3f"><pre id="bdb3f"><mark id="bdb3f"></mark></pre></pre><output id="bdb3f"></output><p id="bdb3f"></p><p id="bdb3f"></p>

          <pre id="bdb3f"><del id="bdb3f"><progress id="bdb3f"></progress></del></pre>

                <ruby id="bdb3f"></ruby>

                ??碼云GVP開源項目 12k star Uniapp+ElementUI 功能強大 支持多語言、二開方便! 廣告
                # EF框架介紹 ``` https://www.jianshu.com/p/ce8026992275 https://www.cnblogs.com/bomo/p/3331602.html https://blog.csdn.net/liyazhen2011/article/details/80541546(這個比較好) 這條路走得太遠,暫停走。還是用傳統的ADO.DB來實現 ``` ``` //這里介紹LINQ DataContext類,DataContext 是用來連接到數據庫、從中檢索對象以及將更改提交回數據庫的主要渠道。使用 DataContext 時就像使用 ADO.NET SqlConnection 一樣。 DataContext db = new DataContext(SqlEasy.connString); Table<FlowInstanceModel> Customers = db.GetTable<FlowInstanceModel>(); var cs = from c in Customers where c.KeyId<999 select c; Response.Write(NetWing.Common.JSONhelper.ToJson(cs)); ``` # linq統計 ``` 簡單方式 int ccc= Customers.Count(); 帶統計的方式 int ccc= Customers.Count(uk => uk.MakerList == "1" || uk.MakerList.Contains("9")); ``` # linq分頁 在所有的數據中在查詢你要分頁的數據 ``` result.data = (from u in fi where u.MakerList == "1" || u.MakerList.Contains(user) orderby u.CreateDate descending select u).Skip(pageSize * (pageNum - 1)).Take(pageSize); 在所有的數據中在查詢你要分頁的數據,skip是在分頁在前有多少條數據,也就是在當前頁數據之前的數據總和,(跳過序列中指定數量的元素,然后返回剩余的元素。)pageSize*(pageIndex-1),Take 是返回多少條數據,也就是pageSize! ``` # linq 優化查詢分頁 ``` public static List<T> GetList(int pageIndex, int pageSize, out int count) { using (var db = new ClientDBDataContext(DBHelper.DBConString)) { var query = db.DataBase_Table.AsParallel(); count = query.Count(); return query.Skip((pageIndex - 1) * pageSize).Take(pageSize).ToList(); } } ``` # 枚舉填充實體 ``` //枚舉填充實體類 IEnumerable<FlowInstanceModel> f = DbUtils.GetWhere<FlowInstanceModel>(new { KeyId = 16 }); FlowInstanceModel m = new FlowInstanceModel(); m.InjectFrom(f); ```
                  <ruby id="bdb3f"></ruby>

                  <p id="bdb3f"><cite id="bdb3f"></cite></p>

                    <p id="bdb3f"><cite id="bdb3f"><th id="bdb3f"></th></cite></p><p id="bdb3f"></p>
                      <p id="bdb3f"><cite id="bdb3f"></cite></p>

                        <pre id="bdb3f"></pre>
                        <pre id="bdb3f"><del id="bdb3f"><thead id="bdb3f"></thead></del></pre>

                        <ruby id="bdb3f"><mark id="bdb3f"></mark></ruby><ruby id="bdb3f"></ruby>
                        <pre id="bdb3f"><pre id="bdb3f"><mark id="bdb3f"></mark></pre></pre><output id="bdb3f"></output><p id="bdb3f"></p><p id="bdb3f"></p>

                        <pre id="bdb3f"><del id="bdb3f"><progress id="bdb3f"></progress></del></pre>

                              <ruby id="bdb3f"></ruby>

                              哎呀哎呀视频在线观看