/// <summary>
/// 创建数据库
/// <param name="useDb">使用这个数据库创建本数据库</param>
/// <param name="filePath">将本数据库创建到磁盘的路径</param>
/// </summary>
public void Create(RdbDescriptor useDb, string filePath = null)
{
using (var conn = useDb.GetConnection())
{
var cmd = conn.CreateCommand();
var config = string.Empty;
if (!string.IsNullOrEmpty(filePath))
{
if (!Directory.Exists(filePath))
{
Directory.CreateDirectory(filePath);
}
var fileName = Path.Combine(filePath, Database.CatalogName + ".mdf");
config =
@" ON PRIMARY ( NAME = N'" + Database.CatalogName + @"', FILENAME = N'" + fileName + "')";
}
cmd.CommandText =
@"if DB_ID('" + Database.CatalogName + "') IS NULL CREATE DATABASE " + Database.CatalogName + config;
cmd.CommandType = CommandType.Text;
if (conn.State != ConnectionState.Open)
{
conn.Open();
}
cmd.ExecuteNonQuery();
}
}
/// <summary>
/// 创建数据库
/// <param name="useDb">使用这个数据库创建本数据库</param>
/// <param name="filePath">将本数据库创建到磁盘的路径</param>
/// </summary>
public void Create(RdbDescriptor useDb, string filePath = null)
{
using (var conn = useDb.GetConnection())
{
var cmd = conn.CreateCommand();
var config = string.Empty;
if (!string.IsNullOrEmpty(filePath))
{
if (!Directory.Exists(filePath))
{
Directory.CreateDirectory(filePath);
}
var fileName = Path.Combine(filePath, Database.CatalogName + ".mdf");
config =
@" ON PRIMARY ( NAME = N'" + Database.CatalogName + @"', FILENAME = N'" + fileName + "')";
}
cmd.CommandText =
@"if DB_ID('" + Database.CatalogName + "') IS NULL CREATE DATABASE " + Database.CatalogName + config;
cmd.CommandType = CommandType.Text;
if (conn.State != ConnectionState.Open)
{
conn.Open();
}
cmd.ExecuteNonQuery();
}
}
