DapperDBHelper 1.2.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 void getSingleTable()
{
var Result = await _dBHelpers.QueryAsyncList("Select * 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});
}