如何在C#中以编程方式创建SQL Server数据库-为每个项目创建新SQL Server数据库的项目管理应用程序

using System;
using System.Data.SqlClient;

string connectionString = "Data Source=(local);Initial Catalog=master;Integrated Security=True";

string databaseName = "NewDatabase";
string createDatabaseQuery = $"CREATE DATABASE {databaseName}";
using (SqlConnection connection = new SqlConnection(connectionString))
{
    connection.Open();
    using (SqlCommand command = new SqlCommand(createDatabaseQuery, connection))
    {
        command.ExecuteNonQuery();
    }
}

string checkDatabaseQuery = $"SELECT COUNT(*) FROM sys.databases WHERE name = '{databaseName}'";
using (SqlConnection connection = new SqlConnection(connectionString))
{
    connection.Open();
    using (SqlCommand command = new SqlCommand(checkDatabaseQuery, connection))
    {
        int count = (int)command.ExecuteScalar();
        if (count > 0)
        {
            Console.WriteLine($"数据库 '{databaseName}' 创建成功！");
        }
        else
        {
            Console.WriteLine($"数据库 '{databaseName}' 创建失败！");
        }
    }
}