Msb.DatabaseContext 1.0.7

Configuration in ASP.NET

Add the connection string in Web.Config file

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

Code Example

    public class HomeController : Controller
    {

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

            ResultData data1 = database.ExuceuteDataWithParameters<object, ResultData>("SPName", new { BookingNo = "45,56" });
            List<ResultData> list1 = database.ExuceuteListWithParameters<object, ResultData>("SPName", new { BookingNo = "45,56" });

            ResultData data2 = database.ExuceuteDataWithOutParameters<ResultData>("SPName");
            List<ResultData> list2 = database.ExuceuteListWithOutParameters<ResultData>("SPName");

            object scalar = database.ExecuteScalar<object>("SPName", new { Id = 1 }, CommandType.StoredProcedure);
            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");
        }
    }

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.ExuceuteWithParameters<object, ResultData>("SPName", new { BookingNo = "45,56" });
            List<ResultData> list1 = DataLayer.ExuceuteListWithParameters<object, ResultData>("SPName", new { BookingNo = "45,56" });

            ResultData data2 = DataLayer.ExuceuteDataWithOutParameters<ResultData>("SPName");
            List<ResultData> list2 = DataLayer.ExuceuteListWithOutParameters<ResultData>("SPName");

            object scalar = DataLayer.ExecuteScalar<object>("SPName", new { Id = 1 },CommandType.StoredProcedure);

            return View();
        }
}

Note :

ResultData is class