Lamada转化字符类型

 

//SN为字符串类型，将其转换成Int等数字类型

---第一种

List<Testing_Report_Enclosureslist> enclosuresList = _db.Testing_Report_Enclosureslist.Where(c => c.ProjectVGUID == projectId && c.MileStone == milestone).OrderBy(c => c.SN).ToList();

 enclosuresList =enclosuresList .OrderBy(c => Convert.ToInt32(c.SN)).ToList();

---第二种

List<Testing_Report_Enclosureslist> enclosuresList = _db.ExecuteStoreQuery<Testing_Report_Enclosureslist>(@"SELECT SN,
* FROM Testing_Report_Enclosureslist ORDER BY SN+1").Where(c => c.ProjectVGUID == projectId && c.MileStone == milestone).ToList();