/// <summary>
/// Creata data base
/// </summary>
/// <returns><see cref="DataBase"/></returns>
public DataBase Create()
{
var connectionBuilder = new ConnectionBuilder(Dialect, Connection);
if (Dialect is MySQLDialect)
{
Connection.ConnectionString = connectionBuilder
.With("Server", connectionBuilder.GetValueOfPart("Server"))
.With("User Id", connectionBuilder.GetValueOfPart("User Id"))
.With("Password", connectionBuilder.GetValueOfPart("Password"))
.Builder()
.ConnectionString;
ExecuteCommand(string.Format("CREATE DATABASE IF NOT EXISTS {0};", Connection.Database), Connection);
}
else if (Dialect is MsSql2000Dialect)
{
Connection.ConnectionString = connectionBuilder
.With("Server", connectionBuilder.GetValueOfPart("Server"))
.With("User Id", connectionBuilder.GetValueOfPart("User Id"))
.With("Password", connectionBuilder.GetValueOfPart("Password"))
.Builder()
.ConnectionString;
ExecuteCommand(string.Format("IF NOT(EXISTS(SELECT * FROM sys.sysdatabases where name='{0}')) BEGIN CREATE DATABASE {0}; END", Connection.Database), Connection);
}
Connection = ConnectionFactory.Factory(Configuration, Dialect);
new SchemaExport(SessionManager.Configuration).Create(false, true);
return this;
}
private string GetConnectionString()
{
var connectionBuilder = new ConnectionBuilder(Dialect, Connection);
if (Dialect is MySQLDialect)
{
return connectionBuilder
.With("Server", connectionBuilder.GetValueOfPart("Server"))
.With("User Id", connectionBuilder.GetValueOfPart("User Id"))
.With("Password", connectionBuilder.GetValueOfPart("Password"))
.Builder()
.ConnectionString;
}
if (Dialect is MsSql2000Dialect)
{
return connectionBuilder
.With("Server", connectionBuilder.GetValueOfPart("Server"))
.With("User Id", connectionBuilder.GetValueOfPart("User Id"))
.With("Password", connectionBuilder.GetValueOfPart("Password"))
.Builder()
.ConnectionString;
}
if (Dialect is PostgreSQLDialect)
{
return connectionBuilder
.With("Host", connectionBuilder.GetValueOfPart("Host"))
.With("User Id", connectionBuilder.GetValueOfPart("User Id"))
.With("Password", connectionBuilder.GetValueOfPart("Password"))
.With("Port", connectionBuilder.GetValueOfPart("Port"))
.With("DataBase", connectionBuilder.GetValueOfPart("DataBase"))
.Builder()
.ConnectionString;
}
return string.Empty;
}
/// <summary>
/// Drop data base
/// </summary>
/// <returns><see cref="DataBase"/></returns>
public DataBase Drop()
{
var connectionBuilder = new ConnectionBuilder(Dialect, Connection);
if (Dialect is MySQLDialect)
{
Connection.ConnectionString = connectionBuilder
.With("Server", connectionBuilder.GetValueOfPart("Server"))
.With("User Id", connectionBuilder.GetValueOfPart("User Id"))
.With("Password", connectionBuilder.GetValueOfPart("Password"))
.Builder()
.ConnectionString;
ExecuteCommand(string.Format("DROP DATABASE IF EXISTS {0};", Connection.Database), Connection);
}
Connection = ConnectionFactory.Factory(Configuration, Dialect);
return this;
}