title: Is there a way to pass C# objects to SQL stored procedure
body: <p>Some background to the problem:</p>
  
  <p>I have a hierarchy of objects that looks like this: <img src="https://i.stack.imgur.com/iT2Mt.jpg" alt="ER diagram of the database"></p>
  
  <p>Each 'CallAction' will have Queue OR a Question based on the 'ActionType'.<br/>
  When a workflow is created through the website it is limited to 2 levels of questions. All of this has been implemented in C# and the tables created in the SQL Server. I now need to find a way to add this all to the database.</p>
  
  <p>As I am extending Website Panel (an open source project) I'm trying to follow the same standards they have been using this means every call to the database is done using stored procedures.</p>
  
  <p>My question is: is there any way I can just pass a 'workflow' to the SQL stored procedure and handle the multiple different levels in SQL, or am I going to have to create multiple stored procedures and handle the different levels in my C# code calling different stored procedures based on the hierarchy?</p>
  
  <p>I also understand that I could access the database directly using <code>SQLCommand</code> or <code>LinQ</code> but I would rather use stored procedures if that is possible.</p>