- 授权协议: GPL
- 开发语言: C#
- 操作系统: Windows
- 软件首页: http://www.openthinking.cn
- 软件文档: https://git.oschina.net/bouyeijiang/SqlProvider
软件介绍
对象映射生成sql语句，将sql的拼接转换为对象拼接输出sql语句，减少拼接sql的麻烦和容易出错，例子:
string select = Provider.Singleton.Select<Info>()
.From<Info>()
.Where(new Info() { name="bouyei",age=12 })
.SqlString;
select结果:"Select name,age From Info Where name='bouyei' And age=12 "
string insert = Provider.Singleton.InsertInto<Info>("tablename",
new Info() { name = "newbie", age = 13 })
.SqlString;
insert结果:"Insert Into Info (name,age) Values('newbie',13)"
string update = Provider.Singleton.Update<Info>()
.Set<Info>(new Info() { name = "openthinking.cn", age = 11 })
.Where<Info>(new Info() {name="bouyei",age=2 })
.SqlString;
update结果:"Update Info Set name='openthinking.cn',age=11 Where name='bouyei' And age=2 "
string delete = Provider.Singleton.Delete<Info>()
.From<Info>()
.Where<Info>(x => x.name == "bouyei")
.SqlString;
delete 结果:"Delete From Info Where (name='bouyei') "
