title: How can I determine whether Stored Procedure Parameter is optional from C# code (I am using Sql Server)
body: <p>I am using C# to connect to Sql Server. I am trying to get Parameter Details of stored procedure before calling the stored procedure. Can you please help me regarding how I can get to know whether any SP parameter is optional or not form C# code itself.</p>
  
  <p>I am using loaclDb in VS 2013. I have Data Source and Db File Name available.</p>
  
  <p>TIA.</p>