运行 SQL 语句
参数 1:SQL 参数 2:参数 参数 3:数据库枚举字符串
ORM.RunSql<T>(
"select * from tblTest where username = @username",
new { username = "fanrong" },
EDataBase.数据库名称.ToString());
3.2.0.0 链式语法
ORM.Build<T>()
.RunSql(
"select * from tblTest where username = @username",
new { username = "fanrong" })
.ToList();
分页写法
参数 3:页码 参数 4:每页行数
ORM.RunSql<T>(
"select * from tblTest where username = @username",
new { username = "fanrong" },
1, 10,
EDataBase.数据库名称.ToString());
3.2.0.0 链式语法(分页)
ORM.Build<T>()
.RunSql(
"select * from tblTest where username = @username",
new { username = "fanrong" })
.ToPageList(1, 10);
参数的两种写法
写法 1:匿名对象
new { username = "fanrong" }
写法 2:List<MDynamicParameter>
var list = new List<MDynamicParameter>();
list.Add("@username", "fanrong");