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…