运行 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");