linq大家肯定用过,对于其中的模糊查询肯定也有所了解
提起linq的模糊查询首先大家想到的肯定是 Contains
不错这也是linq模糊查询的精髓,一般的模糊查询用 Contains都是可以解决的,特殊的精确到字符串某一位的迷糊查询就得另想办法了,
话不多说,下面一一说下模糊查询:
先贴出整个查询,在一一说明,并且把对应的sql语句也会写出来:
using (SrsContext db = new SrsContext()) { var dt1 = (from des in db.ModelsVehicleRecognition where (!string.IsNullOrEmpty(des.PlateNum)) select new { plateMun = des.PlateNum }); var var1 = dt1.ToList(); var dt2 = (from des in db.ModelsVehicleRecognition where (des.PlateNum.StartsWith("皖A8")) select new { plateMun = des.PlateNum }); var var2 = dt2.ToList(); var dt3 = (from des in db.ModelsVehicleRecognition