SQLProcedureDAOCore 2.3.1

SQLProcedureDAO

SQL Data access object to execute SQL Stored Procedures.

Installation

Use the NuGet Package Manager to install SQLProcedureDAO.

PM> Install-Package SQLProcedureDAOCore

Usage

1 - Create a class extends DAOContext

public class ProductDAODbContext: DAOContext
{
    public ProductDAODbContext() : base("ConnectionString")
    {
    }
}

2 - Create an object for ProductDAODbContext

ProductDAODbContext daoContext = new ProductDAODbContext();

• Create a ProductModel

// 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

• First parameter ⇒ Procedure name
• Second parameter ⇒ Argument names as string array
• Third parameter ⇒ Values as object array

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

• Return value as type parameter

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");

License

MIT