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.


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


Your C# project must reference:
  1. System
  2. System.Data
  3. Micrososft.SqlServer.ConnectionInfo
  4. Micrososft.SqlServer.Management.Sdk.Sfc
  5. Micrososft.SqlServer.Smo
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”);
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).


Popular posts from this blog

Enable JSON serialization in your Visual Studio 2010 project