Here Mudassar Ahmed Khan has explained a simple tutorial with an example, how to use Entity Framework Core with Database First Approach in ASP.Net Core MVC.

Database First Approach means first the Database is configured and then it is connected to Application using Entity Framework Core.

This article will explain how to configure Entity Framework Core and connect to SQL Server database and finally the fetched data is displayed in ASP.Net Core MVC.

Here Mudassar Ahmed Khan has explained with an example, what is the difference between FromSql and ExecuteSqlCommand functions in Entity Framework Core 2.1 framework.

Here Mudassar Ahmed Khan has explained with an example, how to execute RAW SQL using Entity Framework Core 2.1 framework in ASP.Net Core MVC.

The RAW SQL Query will be executed using the FromSql function of the Entity Framework Core 2.1 framework in ASP.Net Core MVC.

Here Mudassar Ahmed Khan has explained with an example, how to pass parameters to the FromSql function of Entity Framework in ASP.Net Core.

The FromSql function of Entity Framework accepts the parameters as SqlParameter class objects.