using System;
using System.Data.SqlClient;
class Program
{
static void Main()
{
string databaseName = "Students";
string connectionString = "Data Source=.;Integrated Security=True;";
if (DatabaseExists(connectionString, databaseName))
{
Console.WriteLine($"Database '{databaseName}' already exists.");
}
else
{
CreateDatabase(connectionString, databaseName);
Console.WriteLine($"Database '{databaseName}' created successfully.");
}
Console.WriteLine("Press any key to exit...");
Console.ReadKey();
}
// 检查数据库是否存在
static bool DatabaseExists(string connectionString, string databaseName)
{
string query = $"SELECT COUNT(*) FROM sys.databases WHERE name = '{databaseName}'";
using (SqlConnection connection = new SqlConnection(connectionString))
{
connection.Open();
using (SqlCommand command = new SqlCommand(query, connection))
{
int count = (int)command.ExecuteScalar();
return count > 0;
}
}
}
// 创建数据库
static void CreateDatabase(string connectionString, string databaseName)
{
using (SqlConnection connection = new SqlConnection(connectionString))
{
connection.Open();
string createDatabaseQuery = $"CREATE DATABASE {databaseName}";
using (SqlCommand command = new SqlCommand(createDatabaseQuery, connection))
{
command.ExecuteNonQuery();
}
}
}
}
C#创建数据库::: 它会首先检查数据库是否存在,如果存在则建立连接,如果不存在则创建数据库:
于 2023-07-04 11:41:46 首次发布