一个通过链式方法编写Sql语句的类库,本项目的目标是:一次编写生成各种数据库方言。
代码:
SqlBuilder.Database(Dialect.SqlServer2005).Select.All.Form("table1").As("t1");
SQL:
select * form table1 as t1
代码:
SqlBuilder.Database(Dialect.SqlServer2005).
Select.All.Form("table1").As("t1").Where("t1.id>10").And("t1.id<100").Or("1=2");
SQL:
select * form table1 as t1 where t1.id>10 and t1.id<100 or 1=2
SqlBuilder.Database(Dialect.SqlServer2005).
Select.All.Form("table1").As("t1").Form("table2 as t2")
select * form table1 as t1,table2 as t2
SqlBuilder.Database(Dialect.SqlServer2005).
Select.All.Form("table1").As("t1").InnerJoin("table2").As("t2").On("t1.id=t2.tId");
select * form table1 as t1 inner join table2 as t2 on t1.id=t2.tId
SqlBuilder.Database(Dialect.SqlServer2005).
Select.All.Form("table1").As("t1").LeftJoin("table2").As("t2").On("t1.id=t2.tId");
select * form table1 as t1 left join table2 as t2 on t1.id=t2.tId
SqlBuilder.Database(Dialect.SqlServer2005).
Select.All.Form("table1").As("t1").RightJoin("table2").As("t2").On("t1.id=t2.tId");
select * form table1 as t1 right join table2 as t2 on t1.id=t2.tId