Menu ▼

Previous Next

LINQ to SQL Calling Stored Procedure :

LINQ Query Calling SP without parameters :

MyDBDataContext sqlObj = new MyDBDataContext();

gvemployees.DataSource= sqlObj.SP_GetDepartments();

gvemployees.DataBind();


Output :
select-sp

LINQ Query Calling SP with parameters :
Before calling insert SP :
departments

MyDBDataContext sqlObj = new MyDBDataContext();

sqlObj.SP_InsertDepartments("Test Department");


Output :
After calling insert SP :
insert-sp
Previous Next




Search dotnetlearners.com