var connstr = configurationmanager.connectionstrings["dbconnstr"].connectionstring;SQLContext db = new SQLContext(connStr);//list查询var list1 = db.GetList(s => s.ID > 5);var list2 = db.GetList("select * from Config where id > @id", null, new SqlParameter("@id", 5));var list3 = db.Query().Where(s => s.ID > 5).ToList();//多条件查询var query = db.Query();query.Where(s => s.Name == "b");query.Where(s => s.ID > 5);var result = query.ToList();//分页查询var pageResult1 = db.GetPageResult(new SQL.PageHelper.PageBase { PageIndex = 0, PageSize = 10 }, s => s.ID, true);var pageResult2 = db.GetPageResult(new SQL.PageHelper.PageBase { PageIndex = 0, PageSize = 10 }, "select * from Config", "Id asc");var pageResult3 = db.Query().ToPageResult(new SQL.PageHelper.PageBase { PageIndex = 0, PageSize = 10 }, s => s.ID, true);//插入int row1 = db.Insert(new Config { Name = "a" });int row2 = db.InsertBatch(new List {new Config { Name = "b" },new Config { Name = "c" }});//更新int update1 = db.Update(new Config { ID = 10033, Name= "aa" });int update2 = db.Query().Set(s => s.Name, "aaa").Where(s => s.ID == 10033).Update();//删除int delete1 = db.Delete(s => s.ID == 10033);int delete2 = db.Query().Where(s => s.ID == 10033).Delete();int delete3 = db.Delete(new Config { ID = 10035 });//如发现不支持上述语句，请下载最新版本
