DataTable to IQueryable

.NET   LINQ  

▌背景

---

將DataTable裡面的資料轉換成IQueryable<T>。

▌實作

---

DataTable dt = this._dbModule.ParaGetDataTable(mySql.SqlCommand, mySql.SqlParams); if (dt != null && dt.Rows.Count > 0) { IQueryable<CsvDaReport> query = from r in dt.AsEnumerable().AsQueryable() select new CsvDaReport()                 {                    DaGenDate = r["DaGenDate"].ToString(),                    CsvName = r["CsvName"].ToString(),                    //... };    return query; }

public partial class CsvDaReport {    public string DaGenDate { get; set; }    public string CsvName { get; set; }    //... }