ORM应用

--根据主键Id查询数据
T model = ORM.Get<T>(tblDemo.Id);
--
--根据兰姆达表达式查询数据
List<T> list = ORM.Get<T>((it => it.Where(o => o.Mark > 0).OrderBy(o => o.CreateDate)));
--
--根据兰姆达表达式查询数据(In): where id in(3, 5, 10)
string[] ids = new string[]{"3", "5", "10"};
List<int> listIds = ids.ToList();
用法1：List<T> list = ORM.Get<T>((it => it.Where(o => o.Id.In(ids))));
用法2：List<T> list = ORM.Get<T>((it => it.Where(o => o.Id.In(listIds))));
用法3：List<T> list = ORM.Get<T>((it => it.Where(o => o.Id.In(1, 2, 3, 5, 6))));
--
--根据兰姆达表达式查询数据(Like)
List<T> list = ORM.Get<T>((it => it.Where(o => o.Id.Like("abc%"))));
--
--根据Sql条件查询数据(传入值参数化)
--写法1
List<T> list = ORM.GetWhere<T>("where ClassID = @ClassID and Mark > 0", "order by CreateDate"
            , new { ClassID = "1" });
--写法2
var paramList = new List<MKeyValue>();
paramList.Add("@ClassID", "1");
List<T> list = ORM.GetWhere<T>("where ClassID = @ClassID and Mark > 0", "order by CreateDate"
            , paramList);