How do I create a database programatically in SQL Server?

I would like to create a new database from my C# application.
How can I do that?

I'm assuming once I create it, I can simply generate a connection string on the fly and connect to it, and the issue all the CREATE TABLE statements.

From stackoverflow Daniel Magliola

• There's probably an uber-leet way of doing this, but why not just connect to the master database and feed in some sql?

  From IainMH

• Look into the CREATE DATABASE statement.

  From Ryan Duffield

• KB307283 explains how to create a database using ADO.NET.

  From the article:

  String str;
  SqlConnection myConn = new SqlConnection ("Server=localhost;Integrated security=SSPI;database=master");
  
  str = "CREATE DATABASE MyDatabase ON PRIMARY " +
      "(NAME = MyDatabase_Data, " +
      "FILENAME = 'C:\\MyDatabaseData.mdf', " +
      "SIZE = 2MB, MAXSIZE = 10MB, FILEGROWTH = 10%) " +
      "LOG ON (NAME = MyDatabase_Log, " +
      "FILENAME = 'C:\\MyDatabaseLog.ldf', " +
      "SIZE = 1MB, " +
      "MAXSIZE = 5MB, " +
      "FILEGROWTH = 10%)";
  
  SqlCommand myCommand = new SqlCommand(str, myConn);
  try 
  {
      myConn.Open();
      myCommand.ExecuteNonQuery();
      MessageBox.Show("DataBase is Created Successfully", "MyProgram", MessageBoxButtons.OK, MessageBoxIcon.Information);
  }
  catch (System.Exception ex)
  {
      MessageBox.Show(ex.ToString(), "MyProgram", MessageBoxButtons.OK, MessageBoxIcon.Information);
  }
  finally
  {
      if (myConn.State == ConnectionState.Open)
      {
          myConn.Close();
      }
  }
  

  From Espo

• CREATE DATABASE works

  From Lulu