szq.orm.sql详细使用实例代码
SQLContext db = new SQLContext(connStr);
//list查询
var list1 = db.GetListConfig>
(s =>
s.ID >
5);
var list2 = db.GetListConfig>
("select * From Config where id >
@id", null, new SqlParameter("@id", 5));
var list3 = db.QueryConfig>
().Where(s =>
s.ID >
5).ToList();
//多条件查询
var query = db.QueryConfig>
();
query.Where(s =>
s.Name == "b");
query.Where(s =>
s.ID >
5);
var result = query.ToList();
//分页查询
var pageResult1 = db.GetPageResultConfig>
(new SQL.PageHelPEr.PageBase {
Pageindex = 0, PageSize = 10 }
, s =>
s.ID, true);
var pageResult2 = db.GetPageResultConfig>
(new SQL.PageHelper.PageBase {
PageIndex = 0, PageSize = 10 }
, "select * from Config", "Id asc");
var pageResult3 = db.QueryConfig>
().ToPageResult(new SQL.PageHelper.PageBase {
PageIndex = 0, PageSize = 10 }
, s =>
s.ID, true);
//插入
int row1 = db.InsertConfig>
(new Config {
Name = "a" }
);
int row2 = db.InsertBatchConfig>
(new ListConfig>
{
new Config {
Name = "b" }
,
new Config {
Name = "c" }
}
);
//更新
int update1 = db.UpdateConfig>
(new Config {
ID = 10033, Name= "aa" }
);
int update2 = db.QueryConfig>
().Set(s =>
s.Name, "aaa").Where(s =>
s.ID == 10033).Update();
//删除
int delete1 = db.DeleteConfig>
(s =>
s.ID == 10033);
int delete2 = db.QueryConfig>
().Where(s =>
s.ID == 10033).Delete();
int delete3 = db.DeleteConfig> (new Config { ID = 10035 } );
//如发现不支持上述语句,请下载最新版本
以上就是szq.orm.sql详细使用实例代码的详细内容,更多请关注其它相关文章!
声明:本文内容由网友自发贡献,本站不承担相应法律责任。对本内容有异议或投诉,请联系2913721942#qq.com核实处理,我们将尽快回复您,谢谢合作!
若转载请注明出处: szq.orm.sql详细使用实例代码
本文地址: https://pptw.com/jishu/592199.html