Donate

How To Call SQL Server Stored Procedure Using LINQ And C#.NET

Good evening.

Here's a basic example of how to call a SQL Server Stored Procedure Using LINQ And C#.NET
1. Make sure you have Northwind database in your Sql server.
2. Create a simple stored procedure to retrieve customers based on a specific country.
The parameter of the stored procedure is of type varchar.
3. Create a simple asp.net website or winforms or console project.
4. Add a Linq to SQL class to your project.
5. Make sure to add the stored procedure in your linq to sql class.
6. In your asp.net website, add a button,textbox and a gridview.
7. In your button event click, add the following snippet:

1
2
3
4
5
6
7
8
protected void Bind()  
{  
    string country = this.txtCity.Text.Trim();  
    var cr = new NorthWindDataContext();  
    var north = cr.CustomerByCountry(country);  
    this.gridCustomers.DataSource = north;  
    this.gridCustomers.DataBind();  
}  

That's it...

Comments

Donate

Popular Posts From This Blog

WPF CRUD Application Using DataGrid, MVVM Pattern, Entity Framework, And C#.NET

How To Insert Or Add Emojis In Microsoft Teams Status Message

Bootstrap Modal In ASP.NET MVC With CRUD Operations