Introduction:
In this article i am going to explain about how to access a stored procedure using linq.

Main:
In data driven business applications,instead of queries of we need to use either stored
procedure or functions.Linq provide a object oriented,structured approach for accessing
stored procedures.

Just follow the below steps,

1.Open a new silverlight application and named it LinqSpDemo,

2.Right Click the project and add Linq to Sql Classes and named it Callingsplinq.dbml,

3.click view and open server explorer

4.Right click stored procedure tab and select Add New Stored Procedure,In this examble
i am going to creating a stored procedure for inserting empid and empname in emp table,

ALTER PROCEDURE dbo.AddEmployee ( @name nvarchar(50), @id int ) AS BEGIN INSERT INTO Emp (Empid,FirstName) VALUES (@id,@name)   END

5.Open Tables tab and drag and drop Emp table,

6.In the same way drag and drop AddEmployee Procedure,

7.Create link between Table and stored procedure,(Right Click and Emp and select Configure
Behaviour (see the below screenshot)),

8.Map the table columns into stored procedure parameters,

9.Click Save,

10.Right click the select and add a wcf service,

public void InsertEmployee(int Employeeid,string EmployeeName) { //string Empname = "Rouville Fisher";   Emp objEmp = new Emp() { Empid = Employeeid, FirstName = EmployeeName };   var spcon = new CallingSpLinqDataContext(); spcon.Emps.InsertOnSubmit(objEmp); spcon.SubmitChanges();   }

11.Add the service Reference to client,and just call it,

void objclent_InsertEmployeeCompleted(object sender, EmpServiceReference.InsertEmployeeCompletedEventArgs e) { MessageBox.Show("Employee Details Inserted"); }   private void Click_Click(object sender, RoutedEventArgs e) { EmpServiceReference.EmpProcServiceClient objclent = new EmpServiceReference.EmpProcServiceClient(); objclent.InsertEmployeeCompleted +=new EventHandler<EmpServiceReference.InsertEmployeeCompletedEventArgs>(objclent_InsertEmployeeCompleted); EmpServiceReference.InsertEmployeeRequest objEmpRequest = new EmpServiceReference.InsertEmployeeRequest(); objEmpRequest.Employeeid = Convert.ToInt32(Empid1.Text); objEmpRequest.EmployeeName = EmpName1.Text.Trim(); objclent.InsertEmployeeAsync(objEmpRequest);   }

thatsit,

Conclusion:
Hope this helps,
Happy coding.