Dynamic stored procedure name linq to sql

Question

Is there a way to to pass a stored procedure name as a string to a function then use reflection to actually get the sp to use in an linq to sql query?

Answer 1

Try this

var sp = typeof(DataContext).GetMethod("GetUsersByID"); //Get the SP
var result = sp.Invoke(DbContext, new object[]{100}); //Execute the SP with 100 as the parameter