DapperDBHelper 1.6.0

Use full for web API’s
              Excludes the installation of extra packages just installs DapperDBHelper and create object of DapperDBHelper and pass your connection string through contractor DBHelper class.
              How we can use DapperDBHelper, Find the piece of code below Example              
              public class  SetupsController
              {      
              private readonly DBHelpers _dBHelpers;
                      public SetupsController()
                      {
                          _dBHelpers = new DBHelpers(ConectionString.connectionString);
                      }
              Public async void getSingleList()
              {
               var Result = await _dBHelpers.QueryAsyncList<YourViewModelClass>("Select * from table");
              }
                public void getSingleRecord()
              {
               var Result = _dBHelpers.Query<YourViewModelClass>("Select Top 1* from table");
              }

              public void getMultipleTable()
              {
              Make list same as it is like table  returns from  your store procedure
                List<string> tableName = new List<string>();
                              tableName.Add("Table1");
                              tableName.Add("Table2");
                              tableName.Add("Table3");
                     
                              var Result = await  _dBHelpers.QueryMultipleAsync("EXEC Store_Procedure @ID", param: new { ID = ID }, tableName);
              }
              Execute Method is used for CRUD Operations
              After Execution of your store procedure returning single row of current execution is best practice
              ExecuteAsync call depends upon your application nature
              public void InserData(Employees model)
              {
                  var Result = await  _dBHelpers.Execute("EXEC Store_Procedure @FirstName,@LastName,@Address", param: new { FirstName = model.FirstName, LastName =model.LastName, Address = model.Address});
              }





-- For .NET 8  following Code do the help--

// Register your service here
   builder.Services.AddTransient<DBHelpersForAllDatabases>();

   // Register your database connection
   Builder.Services.AddTransient<IDbConnection>( => new SqlConnection(Configuration.GetConnectionString("DefaultConnection")));

public class MyController : ControllerBase
{
   private readonly DBHelpersForAllDatabases _dbHelpers;

   public MyController(DBHelpersForAllDatabases dbHelpers)
   {
       _dbHelpers = dbHelpers;
   }

   [HttpGet]
   public async Task<IActionResult> Get()
   {
       // Use DBHelpers to execute queries
       var result = await _dbHelpers.QueryAsyncList<MyModel>("SELECT * FROM MyTable");
       return Ok(result);
   }
}