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