c#：mysql高效查询_C# LLSQL快速查询框架

1 ///

2 ///单表查询3 ///

4 public static voidsingle_able()5 {6 using (var sql = new SqlModel())7 {8 //!+常用方法

9 /*

10 *使用说明11 *数据查询方法,只有调用后才会有数据返回12 *ToDataTable(),ToList(),ToPageList(),First(),FirstOrDefault()13 */

14 //?查默认一条数据

15 var data1 =sql16 .SqlSelect(a => new{ a.AreaName, a.AreaCode })17 .FirstOrDefault();18 //?所有字段查询

19 var data1_1 =sql20 .SqlSelect()21 .FirstOrDefault();22 //查询top 10

23 var data1_2 =sql24 .SqlSelect()25 .SqlTop(10)26 .ToList();27 //?DataTable

28 var data2 =sql29 .SqlSelect(a => new{ a.AreaName, a.AreaCode })30 .ToDataTable();31 //?List

32 var data3 =sql33 .SqlSelect(a => new{ a.AreaName, a.AreaCode })34 .ToList();35 //?分页

36 var data4 =sql37 .SqlPage(a => new{ a.AreaName, a.AreaCode })38 .ToPageList();39 var data4_1 =sql40 .SqlPage(a => new { a.AreaName, a.AreaCode }, 1, 20)41 .ToPageList();42 //?count

43 var data5 =sql44 .SqlCount(a => a.AreaCode == "");45 //?sum

46 var data6 =sql47 .SqlSum(a => new{ a.AreaCode })48 .First();49

50 //?无锁查询

51 var data7 =sql52 .SqlSelect(a => new{ a.AreaName, a.AreaCode }, LockType.NOLOCK)53 .FirstOrDefault();54 //?指定索引查询

55 var data8 =sql56 .SqlSelect(a => new{ a.AreaName, a.AreaCode }57 , "PK_T_BAS_AREAS")58 .FirstOrDefault();59

60 //?条件查询

61 var data9 =sql62 .SqlSelect(a => new{ a.AreaName, a.AreaCode })63 .SqlWhere(a => a.ParentAreaCode == "1251" && a.AreaName.SqlLike("九江"))64 .FirstOrDefault();65 //? 查前10条并排序

66 var data10 =sql67 .SqlSelect(a => new{ a.AreaName, a.ParentAreaCode, a.AreaCode })68 .SqlTop(10)69 .SqlOrderBy(b => new{ b.ParentAreaCode, b.AreaCode })70 .ToList();71 var data11 =sql72 .SqlSelect(a => new{ a.AreaName, a.ParentAreaCode, a.AreaCode })73 .SqlTop(10)74 .SqlOrderDescBy(b => new{ b.ParentAreaCode, b.AreaCode })75 .ToList();76 //? 查前10%条并排序

77 var data12 =sql78 .SqlSelect(a => new{ a.AreaName, a.ParentAreaCode, a.AreaCode })79 .SqlPercent(10).SqlOrderBy(b => new{ b.ParentAreaCode }).ToList();80 data12 = sql.SqlSelect(a => new{ a.AreaName, a.ParentAreaCode, a.AreaCode })81 .SqlPercent(10)82 .SqlOrderDescBy(b => new{ b.ParentAreaCode })83 .SqlOrderBy(c => new{ c.AreaCode })84 .ToList();85

86 //?查前10条不重复的项

87 var data13 =sql88 .SqlSelect(a => new{ a.ParentAreaCode, a.AreaCode })89 .SqlDistinct()90 .SqlTop(10)91 .ToList();92

93 //!更新

94 sql.SqlUpdate(a => new object[] { a.AreaName == "溪湖区" },//a.SqlFunc("AreaCode='2'")

95 b => b.AreaGuidGuid == Guid.Parse("949B2F9D-F730-48ED-8B58-000144166BE9"));96

97

98 //!添加

99 T_BAS_Areas area = newT_BAS_Areas()100 {101 AreaGuidGuid =Guid.NewGuid(),102 AreaCode = "1",103 AreaName = "测试",104 ParentAreaCode = "-1",105 };106 sql.SqlAdd(area);107 //!删除

108 sql.SqlDelete(a => a.AreaGuidGuid ==area.AreaGuidGuid);109

110 //where 查询

111 var data14 =sql112 .SqlSelect(a => new{ a.AreaName, a.AreaCode })113 .SqlWhere(a => a.AreaName.SqlLike("六一") && a.AreaCode.SqlFunc("AreaCode=1"))114 .ToList();115 var data141 =sql116 .SqlSelect(a => new{ a.AreaName, a.AreaCode })117 .SqlWhere(a => a.AreaName.SqlLike("%{0}?", "六一")118 && a.AreaCode.SqlFunc("AreaCode='1'")//a.SqlFunc("AreaCode='1'")

119 || a.AreaCode.SqlFunc("AreaCode=Parent"))120 .ToList();121 }122 }