Msb.DatabaseContext 2.0.6

Configuration in ASP.NET

Add the connection string in Web.Config file

  <appSettings>
   
   <add key="ConnectionString" value="Your database connection string"/>
  </appSettings>

Next Create a Class like DataLayer.cs For MSSQL

public class DataLayer : DatabaseContext
    {
        public DataLayer() : base()
        {
            ConnectionString = ConfigurationManager.AppSettings["ConnectionString"];
        }
    }

DataLayer.cs For PostgreSQL

public class DataLayer : DatabaseContextNpgsql
    {
        public DataLayer() : base()
        {
            ConnectionString = ConfigurationManager.AppSettings["ConnectionString"];
        }
    }

Code Example

    public class HomeController : Controller
    {

       private readonly DatabaseContext database = new DatabaseContext();
        public ActionResult Index()
        {

            ResultData data1 = database.Execute("SPName", new { BookingNo = "45,56" }).FirstOrDefault<ResultData>();
            List<ResultData> list1 = database.Execute("SPName", new { BookingNo = "45,56" }).ToList<ResultData>();

            ResultData data2 = database.Execute("SPName").FirstOrDefault<ResultData>();
            List<ResultData> list2 = database.Execute("SPName").ToList<ResultData>();

            string scaler = database.Execute<object,string>("SP_MSB",new { V=450 });


            var data1 = database.Execute("SPName", new { BookingNo = "45,56" }).FirstOrDefault();
            var list1 = database.Execute("SPName", new { BookingNo = "45,56" }).ToList();

            var data2 = database.Execute("SPName").FirstOrDefault();
            var list2 = database.Execute("SPName").ToList();
            
            
            //New feature
            SQLParameter parameter = new SQLParameter();
            parameter.Add("@BookingNo", "or125");
            var list1 = database.Execute("SPName", parameter).ToList();


            //Convert class object to DataTable

            DataTable dataTable= Utility.ConvertObjectToDataTable(list1);


            return View();
        }
}

##Note :

ResultData is class

Configuration in ASP.NET CORE

add the line in appsettings.json file

 "ConnectionStrings": {
    "ConnectionString": "Data Source=Your connenction string"
  }

Next Create a Class like DataLayer.cs

public class DataLayer : DatabaseContext
    {
        public DataLayer(IConfiguration iConfiguration)
        {
            ConnectionString = iConfiguration.GetConnectionString("ConnectionString");
        }
    }

For PostgreSQL

public class DataLayer : DatabaseContextNpgsql
    {
        public DataLayer(IConfiguration iConfiguration)
        {
            ConnectionString = iConfiguration.GetConnectionString("ConnectionString");
        }
    }

if you used another application(Desktop,Console)

public class DataLayer : DatabaseContext
    {
        public DataLayer()
        {
            ConnectionString = "Your connenction string";
        }
    }

Add new line on ConfigureServices methon in Startup.cs/Program.cs file

services.AddSingleton<DataLayer>();
//if used DOT NET  6 version
builder.Services.AddSingleton<DataLayer>();

Example Code

 public class HomeController : Controller
    {

          private readonly DataLayer _dataLayer;

        public HomeController(DataLayer dataLayer)
        {
            _dataLayer = dataLayer;
        }

        public IActionResult Index()
        {
            ResultData data1 = _dataLayer.Execute("SPName", new { BookingNo = "45,56" }).FirstOrDefault<ResultData>();
            List<ResultData> list1 = _dataLayer.Execute("SPName", new { BookingNo = "45,56" }).ToList<ResultData>();

            ResultData data2 = _dataLayer.Execute("SPName").FirstOrDefault<ResultData>();
            List<ResultData> list2 = _dataLayer.Execute("SPName").ToList<ResultData>();

            string scaler = _dataLayer.Execute<object,string>("SP_MSB",new { V=450 });


            var data1 = _dataLayer.Execute("SPName", new { BookingNo = "45,56" }).FirstOrDefault();
            var list1 = _dataLayer.Execute("SPName", new { BookingNo = "45,56" }).ToList();

            var data2 = _dataLayer.Execute("SPName").FirstOrDefault();
            var list2 = _dataLayer.Execute("SPName").ToList();
            
            //New feature
            SQLParameter parameter = new SQLParameter();
            parameter.Add("@BookingNo", "or125");
            var list1 = _dataLayer.Execute("SPName", parameter).ToList();


            //Convert class object to DataTable

            DataTable dataTable= Utility.ConvertObjectToDataTable(list1);
        }
}

Note :

ResultData is class