title: How to create stored procedure in C#, then *save* it to SQL Server?
body: <p>I've been banging my head against a wall for a little while on this one. I know you can create a stored procedure in C# code, that bit's OK. But what I can't figure out is can I then <em>save</em> that stored procedure, <em>onto the SQL Server</em> - but done via C# code?</p>
  
  <p>Scenario is: I want to create a test database via code, then I want to add a stored procedure to the newly created test database (server side) - again, all done via the same C# code project.</p>