execute stored procedure using a string variable RRS feed

  • Question

  • Is it possible to save execute stored proc command in a string variable and then execute string variable???

    Does this logic fits into LINQ2SQL? 

    Why I want to do this - INstead of passing user control references to server, I want to save user control values to string in client side java script and then pass string to server to do actual stored proc execution. Hopefully this will improve performance. DOES IT MAKE ANY SENSE?

    Tuesday, June 22, 2010 2:16 PM


  • I'm not sure if this answers what you are asking, but the data context has ExecuteCommand() and ExecuteQuery() methods in which you can execute raw SQL, including stored procedure calls.
    Tuesday, June 22, 2010 2:40 PM