How to create a database with SQL Server using code

In SQL Server, you can create a database through code. The specific steps are as follows: import the System.Data.SqlClient namespace to create a connection string, specify the server address and database name to create a SqlConnection object, establish a connection with the database to create a SqlCommand object, specify the creation database command to be executed to open the connection and execute the command, and create a new database named "myDatabase".

Create a database using code in SQL Server

In SQL Server, you can create a database by writing code. The following steps describe how to implement it:

1. Import the System.Data.SqlClient namespace

 <code class="csharp">using System.Data.SqlClient;</code>

2. Create a connection string

 <code class="csharp">string connectionString = @"Server=myServerAddress;Database=master;Integrated Security=True;";</code>

• "myServerAddress" is replaced by the address or name of the SQL Server server.
• "Integrated Security=True;" specifies using Windows authentication.

3. Create a SqlConnection object

 <code class="csharp">using (SqlConnection connection = new SqlConnection(connectionString)) { // 代码在using 语句块内执行，确保连接在语句块结束时释放。 }</code>

4. Create a SqlCommand object

 <code class="csharp">SqlCommand command = new SqlCommand("CREATE DATABASE myDatabase", connection);</code>

• "myDatabase" is replaced by the name of the database to be created.

5. Open the connection and execute the command

 <code class="csharp">connection.Open(); command.ExecuteNonQuery();</code>

• Open the connection to allow the database to be used.
• The ExecuteNonQuery() method executes the command without returning any results.

Sample code:

 <code class="csharp">using System.Data.SqlClient; public static void CreateDatabase() { string connectionString = @"Server=myServerAddress;Database=master;Integrated Security=True;"; using (SqlConnection connection = new SqlConnection(connectionString)) { SqlCommand command = new SqlCommand("CREATE DATABASE myDatabase", connection); connection.Open(); command.ExecuteNonQuery(); } }</code>

Calling the CreateDatabase() method will create a new database in SQL Server named "myDatabase".

The above is the detailed content of How to create a database with SQL Server using code. For more information, please follow other related articles on the PHP Chinese website!