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 implement HttpHandler (ASHX) in ASP.Net MVC Razor.

The HttpHandler (ASHX) will fetch data from SQL Server database using Entity Framework and return data in JSON format.

The HttpHandler (ASHX) will be called using a jQuery Client which will read the JSON values and populate it into an HTML Table in ASP.Net MVC Razor.

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.