Category - Stored Procedures
Results 1 - 5 of 64
02 Jun 2021 02 Jun 2021 0 Comments  802 Views
Here Mudassar Ahmed Khan has explained with an example, how to use Stored Procedure with parameters with Entity Framework Core 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.

The Stored Procedures are called with parameters using the FromSql function of Entity Framework Core Framework in ASP.Net Core MVC.
19 May 2021 19 May 2021 0 Comments  666 Views
Here Mudassar Ahmed Khan has explained with an example, how to call Stored Procedure with parameters using Entity Framework in .Net Core 2.1.

The Stored Procedures are called with parameters using the FromSql function of Entity Framework in .Net Core 2.1.
18 May 2021 18 May 2021 0 Comments  535 Views
Here Mudassar Ahmed Khan has explained with an example, how to implement Search functionality using Entity Framework in ASP.Net Core MVC.

The Search functionality will be implemented using a Stored Procedure which will be called by passing the parameter value using Entity Framework in ASP.Net Core MVC.
07 Dec 2020 07 Dec 2020 0 Comments  3573 Views
Here Mudassar Ahmed Khan has explained with an example, how to split a String into Rows in SQL Server.

This article will illustrate how to create a function that will split a string separated (delimited) by comma, space or some other special characters into Table Rows in SQL Server.
15 Oct 2020 15 Oct 2020 0 Comments  8392 Views
Here Mudassar Ahmed Khan has explained with an example, how to execute Stored Procedure with Table Valued Parameters in SQL Server.

First a Table Variable of User Defined Table Type has to be created of the same schema as that of the Table Valued parameter.

Then it is passed as Parameter to the Stored Procedure and the Stored Procedure is executed using the EXEC command in SQL Server.
Results 1 - 5 of 64