The real [artifact] for executing SQL statements & stored procedures. If you don’t need an ORM, choose it. It’s better than dapper.

The real [artifact] for executing SQL statements & stored procedures. If you don’t need an ORM, choose it. It’s better than dapper.

The real [artifact] for executing SQL statements & stored procedures. If you don’t need an ORM, choose it. It’s better than dapper Supports .Net Core (2.0 and above) and .Net Framework (4.0 and above) (Note: After upgrade, it can cover the early .Net Framework 4.0, and the problem of error reporting when the database field is Null has been fixed, invincible!!) This tool is provided in the IDataAccess interface. Has been adopted by many major manufacturers in the .Net circle! The namespace where IDataAccess is located is: DeveloperSharp.Framework.QueryEngine (need to reference the latest DeveloperSharp package from NuGet) It mainly provides the following four major functions: (1) Execute Sql statement (2) Execute Sp stored procedure (3) Create parameters (input/output/return) (4) Business The code for its initialization is as follows: If you are in a .Net Core environment, the code is as follows: using DeveloperSharp.Framework. QueryEngine; ————————– //In Startup.cs or Program .cs file Services.AddTransient((t) => { DatabaseInfo DIF; DIF.DatabaseType = DatabaseType.SQLServer; //Set database type DIF.ConnectionString = “Server=localhost ;Database=YZZ;Uid=sa;Pwd=123”; return DataAccessFactory.Create (DIF); }); If you are in a .Net Framework environment, the code is as follows: using DeveloperSharp.Framework. QueryEngine; ————————– DatabaseInfo DIF; DIF.DatabaseType = DatabaseType.SQLServer; //Set database type DIF.ConnectionString = “Server=localhost ;Database=YZZ;Uid=sa;Pwd=123”; IDataAccess…

Contact Us

Contact us

181-3619-1160

Online consultation: QQ交谈

E-mail: [email protected]

Working hours: Monday to Friday, 9:00-17:30, holidays off

Follow wechat
Scan wechat and follow us

Scan wechat and follow us

Follow Weibo
Back to top
首页
微信
电话
搜索