SqlProvider

• 授权协议: 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') "

本文地址：https://codercto.com/soft/d/12355.html