CREATE DATABASE (SMO)

Create a SQL Server Database by using SMO

In this small tutorial I will show you how to create a database with SMO and C# in Visual Studio 2008. I will use a Console application.

Prerequisites:

1. SQL Server 2005 is installed
2. Visual Studio 2008 is installed

Code

Assemblies

Your C# project must reference:

1. System
2. System.Data
3. Micrososft.SqlServer.ConnectionInfo
4. Micrososft.SqlServer.Management.Sdk.Sfc
5. Micrososft.SqlServer.Smo

Namespaces

The source class file must use:

1. System
2. System.Data.SqlClient
3. Micrososft.SqlServer.Management.Common
4. Micrososft.SqlServer.Management.Smo

class ConsoleSmo
{
  public static Main()
  {
    string connLocal = "Data Source=(local); Integrated Security=SSPI;"
    SqlConnection connection = new SqlConnection(connLocal);
    Server server = new Server(new ServerConnection(connection));
    Database db = new Database(server, “TestDb”);
    db.Create();
    connection.Close();
  }
}

Explanations

This code opens the connection to the server and produces the Server object. Next, it creates the database. Finally, it closes the connection. The last step is very important, because otherwise the connection object will not be returned to the connection pool (read about the connection pooling at MSDN).