Odbc中一个通用数据库访问框架,只要支持ODBC连接的都能用ODBC去操作数据库
新功能 5.0.2.4-preview04
SqlSugar.OdbcCore ( .Net Framework SqlSugar.Odbc )
SqlSugarCore ( .Net Framework SqlSugar )
.net framework
DbType = DbType.Odbc,
格式不确性太多
Driver={驱动名};....
1、不支持CodeFirst
2、兼容性未知 DbFirst
3、兼容性未知 普通用的CRUD
4、原生脚本兼容完美
//sql var dt=db.Ado.GetDataTable("select*from order where @id>0 or name=@name", new List<SugarParameter>(){ new SugarParameter("@id",1), new SugarParameter("@name","2") }); //sql var dt2 = db.Ado.GetDataTable("select * from order where @id>0 or name=@name", new { id = 1, name = "2" }); //Stored Procedure //var dt3 = db.Ado.UseStoredProcedure().GetDataTable("sp_school", new { name = "张三", age = 0 }); //var nameP = new SugarParameter("@name", "张三"); //var ageP = new SugarParameter("@age", null, true);//isOutput=true //var dt4 = db.Ado.UseStoredProcedure().GetDataTable("sp_school", nameP, ageP); //There are many methods to under db.ado var list= db.Ado.SqlQuery<Order>("select * from order "); var intValue=db.Ado.SqlQuerySingle<int>("select 1 from dual"); db.Ado.ExecuteCommand("delete from order where id>1000"); db.Ado.ExecuteCommand($"delete from order where id>1000");
更多ADO用法:
https://www.donet5.com/Home/Doc?typeId=1198
.net framework 下如果无论怎么安装都报 Not Found SqlSugar.Odbc.dll
InstanceFactory.IsWebFrom = true;//程序启动时设置一下这个
.net core不需要
2016 © donet5.comApache Licence 2.0