Creating a database programmatically in SQL Server

by

You can either use the SQL Server Management Object API (see task “creating, altering and removing databases“):

 var srv = new Server();
 var db = new Database(srv, "mydb");
 db.Create();

Information on how to get started is here. During SQL server installation you need to install the client SDK, the SMO assemblies are in C:\Program Files\Microsoft SQL Server\100\SDK\Assemblies

Or if you don’t want the dependency on these assemblies, you can also simply run DDL statements using ADO.Net (e.g. see this question):

using (var connection = new SqlConnection(myConnectionString))
{
    connection.Open();
    var command = connection.CreateCommand();
    command.CommandText = "CREATE DATABASE mydb";
    command.ExecuteNonQuery();
}

Obviously you need a correct connection string: known sql server instance and a user with CREATE DATABASE permission.

More Related Contents:

  1. Insert 2 million rows into SQL Server quickly
  2. SQL WHERE clause matching values with trailing spaces
  3. SqlConnection.Close() inside using statement
  4. Received an invalid column length from the bcp client for colid 6
  5. Invalid column name sql error
  6. Accessing directly a Sql Server Database in Xamarin.Forms
  7. When executing a stored procedure, what is the benefit of using CommandType.StoredProcedure versus using CommandType.Text?
  8. Is SqlConnection.Close() need inside a Using statement?
  9. How To Access Two Databases in a Single connection String in C#?
  10. C#: SQL Server Connection String
  11. SQL Query slow in .NET application but instantaneous in SQL Server Management Studio
  12. SqlParameter does not allows Table name – other options without sql injection attack?
  13. EF 6 – How to correctly perform parallel queries
  14. What’s the fastest way to bulk insert a lot of data in SQL Server (C# client)
  15. How to keep single SQL Server connection instance open for multiple request in C#?
  16. Delete a single record from Entity Framework?
  17. How to use SqlCommand to CREATE DATABASE with parameterized db name?
  18. ExecuteNonQuery returning -1 when using sql COUNT despite the query string
  19. GO statements blowing up sql execution in .NET
  20. How to Identify the primary key duplication from a SQL Server 2008 error code?
  21. Provider named pipes provider error 40 could not open a connection to SQL Server error 2 [duplicate]
  22. Is it possible to use SqlGeography with Linq to Sql?
  23. Will a using block close a database connection?
  24. How to use String property as primary key in Entity Framework
  25. How to get efficient Sql Server deadlock handling in C# with ADO?
  26. What is the fastest way to read data from a DbDataReader?
  27. Is it possible to perform joins across different databases using LINQ?
  28. Cyrillic encoding in C#
  29. Generating sql code programmatically
  30. Accessing System Databases/Tables using LINQ to SQL?

Leave a Comment