title: How to install and setup a database with .NET?
body: <p>I am currently working on a project that include the use of SQLServer. I would like to know what strategy I should use when I install the software to build the database? I need to set up the tables, the stored procedures and the users. </p>
  
  <p>Does my software need to make a check on start up to see if the database exist and then if it doesn't, create it up?
  Is there any way that I could automate this when I install SQLServer?</p>
  
  <p>Thank you.</p>
  
  <p><strong>EDIT</strong>
  Ok right now I have plenty of nice solution, but I am really looking for a solution (free or open source would be awesome) that would allow me to deploy a new application that needs SQLServer to be freshly installed and setuped to the needs of the software. </p>