public virtual IDbmsSyntax CreateDbmsSyntax()
{
IDbmsSyntax dmDbmsSyntax;
switch (dbms)
{
case SupportedDbms.ORACLE:
dmDbmsSyntax = new OracleDbmsSyntax();
break;
case SupportedDbms.MSSQL:
dmDbmsSyntax = new MsSqlDbmsSyntax();
break;
case SupportedDbms.MYSQL:
dmDbmsSyntax = new MySqlDbmsSyntax();
break;
case SupportedDbms.FIREBIRD:
dmDbmsSyntax = new FirebirdDbmsSyntax();
break;
case SupportedDbms.POSTGRE:
dmDbmsSyntax = new PostgreDbmsSyntax();
break;
case SupportedDbms.SYBASE:
dmDbmsSyntax = new SybaseDbmsSyntax();
break;
default:
throw new DbmsNotSupportedException("Supported dbms: ora, mssql, mysql, firebird, postgre, sybase");
}
dmDbmsSyntax.SetDefaultDatabaseName(connectionString);
return dmDbmsSyntax;
}
/// <summary>
/// Ensures the table does not exist.
/// </summary>
/// <param name="tableName">Name of the table.</param>
protected override void EnsureTableDoesNotExist(string tableName)
{
var syntax = new MySqlDbmsSyntax();
var tableInfo = syntax.GetTableInfo(tableName);
this.ExecuteSql(string.Format(
CultureInfo.InvariantCulture,
@"DROP TABLE IF EXISTS {0}.{1}",
tableInfo.Schema, tableInfo.TableName));
}
public virtual IDbmsSyntax CreateDbmsSyntax()
{
IDbmsSyntax dmDbmsSyntax;
switch (dbms)
{
case SupportedDbms.ORACLE:
dmDbmsSyntax = new OracleDbmsSyntax();
break;
case SupportedDbms.MSSQL:
dmDbmsSyntax = new MsSqlDbmsSyntax();
break;
case SupportedDbms.MYSQL:
dmDbmsSyntax = new MySqlDbmsSyntax();
break;
case SupportedDbms.FIREBIRD:
dmDbmsSyntax = new FirebirdDbmsSyntax();
break;
case SupportedDbms.POSTGRE:
dmDbmsSyntax = new PostgreDbmsSyntax();
break;
case SupportedDbms.SYBASE:
dmDbmsSyntax = new SybaseDbmsSyntax();
break;
default:
throw new DbmsNotSupportedException("Supported dbms: ora, mssql, mysql, firebird, postgre, sybase");
}
dmDbmsSyntax.SetDefaultDatabaseName(connectionString);
return(dmDbmsSyntax);
}
/// <summary>
/// Ensures the table does not exist.
/// </summary>
/// <param name="tableName">Name of the table.</param>
protected override void EnsureTableDoesNotExist(string tableName)
{
var syntax = new MySqlDbmsSyntax();
var tableInfo = syntax.GetTableInfo(tableName);
this.ExecuteSql(string.Format(
CultureInfo.InvariantCulture,
@"DROP TABLE IF EXISTS {0}.{1}",
tableInfo.Schema, tableInfo.TableName));
}
