Linq to SQL, optional parameters in stored procedures RRS feed

  • Question

  • I am using Linq to SQL with stored procedures. Currently I have to pass parameters to stored procedures even if they are optional (where I have set the default value for parameters.). Is it possible that I may skip passing default parameters. Thanks
    Tuesday, April 12, 2011 3:54 PM


  • I think you can if you map the sp to a method with optional parameters and the language you are using support that feature. For example, this can be done in c#


    • Marked as answer by Haansi Tuesday, April 12, 2011 7:00 PM
    Tuesday, April 12, 2011 5:22 PM

All replies