Using MS SQL with ASP.Net core project

Do not forget the fact that ASP.NET Core is still the .NET based framework of web application development and it provides the same objects and methods to connect your ASP.NET Core application to database. Simplest of the methods would be,

using (var conn = new SqlConnection("connection_string")) {
conn.Open();
// Create queries and execute them
}

I would be more than happy, to just use this. However, there would be an easy way of doing that, if you create another class that helps you to keep the data layer abstracted. Also, note that you can always use Entity Framework Core with ASP.NET Core and make things even more simpler. There is a complete guide that gives a good explanation of setting up Entity Framework Core with ASP.NET Core applications, you should get started with that one as well, https://docs.microsoft.com/en-us/aspnet/core/data/ef-mvc/intro.

I also wrote an article covering this topic, you should read that here; http://www.c-sharpcorner.com/UploadFile/201fc1/introduction-to-sql/

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Afzaal Ahmad Zeeshan9y ago
Do not forget the fact that ASP.NET Core is still the .NET based framework of web application development and it provides the same objects and methods to connect your ASP.NET Core application to database. Simplest of the methods would be,
using (var conn = new SqlConnection("connection_string")) {
    conn.Open();

     // Create queries and execute them
}
I would be more than happy, to just use this. However, there would be an easy way of doing that, if you create another class that helps you to keep the data layer abstracted. Also, note that you can always use Entity Framework Core with ASP.NET Core and make things even more simpler. There is a complete guide that gives a good explanation of setting up Entity Framework Core with ASP.NET Core applications, you should get started with that one as well, https://docs.microsoft.com/en-us/aspnet/core/data/ef-mvc/intro.
I also wrote an article covering this topic, you should read that here; http://www.c-sharpcorner.com/UploadFile/201fc1/introduction-to-sql/