Linq to SQL

[sankarmj@live.com]

hi,
i need to build a Linq to Sql connection but it should call a Stored procedure which is at the SQL server. How?

presently i'm using Datacontext is it feasible way to execute a sql command and could you pls provide some samples.

Thanks.

[nisar87]

hi, here is the solution for calling store procedure in Linq
http://weblogs.asp.net/scottgu/archive/2...dures.aspx

[sankarmj@live.com]

nisar,
thanks for your reply...
actually my question is i need to access data by executing storedprocedure as i questioned earlier in tha chat.
here is my part of my snippet.... but i didn't understand DataContext so i'm just referring now...

private const string SP_GET_ALL_CATEGORY = "SP_GET_ALL_CATEGORY"; // my stored procedure which is in SQL server. not in DBML/ edmx....


public static void GetCategory()
{
using (DataContext dc = new DataContext(connectionString))
{
// here i need to pass parameter and execute the SP.... how?
}
}
could you please give me reply....

thanks