SQL Data access object to execute SQL Stored Procedures.
$ dotnet add package SQLProcedureDAOCoreSQL Data access object to execute SQL Stored Procedures.
Use the NuGet Package Manager to install SQLProcedureDAO.
PM> Install-Package SQLProcedureDAOCore
1 - Create a class extends DAOContext
public class ProductDAODbContext: DAOContext
{
public ProductDAODbContext() : base("ConnectionString")
{
}
}
2 - Create an object for ProductDAODbContext
ProductDAODbContext daoContext = new ProductDAODbContext();
// product model
public class ProductModel {
public int Id {get; set;}
public string ProductName {get; set;}
public decimal Price{get; set;}
}
3 - Execute Insert/Update procedure
Argument array and values array order should match
int res = daoContext.ExecuteStoredProcedure("InsertProduct",
new string[]{"ProductName", "Price"},
new object[]{"Rice", 54.2});
4- Execute Select procedure by retrieving only first value of first row
int res = daoContext.ExecuteStoredProcedure<int>("GetSumOfProduct",
new string[]{"ProductId"},
new object[]{1});
//without parameters
bool isNewOrderArrived = daoContext.ExecuteStoredProcedure<bool>("IsNewOrderArrived");
//type parameter as ProductModel, (Get first row only)
ProductModel productModel = daoContext.ExecuteStoredProcedure<ProductModel>("GetAllProducts");
//type parameter as List<ProductModel>
List<ProductModel> productModel = daoContext.ExecuteStoredProcedureAsList<ProductModel>("GetAllProducts");