public DbProviderReaderAdapter(SchemaParameters schemaParameters)
: base(schemaParameters)
{
_schemaReader = SchemaReaderFactory.Create(schemaParameters.ConnectionString, schemaParameters.ProviderName);
_schemaReader.Owner = schemaParameters.Owner;
_schemaReader.CommandTimeout = CommandTimeout;
}
public SchemaConstraintLoader(SchemaExtendedReader schemaReader)
{
_sr = schemaReader;
var pks = _sr.PrimaryKeys(null);
_noPks = (pks.Rows.Count == 0);
if (!_noPks)
{
_pkConverter = new SchemaConstraintConverter(pks, ConstraintType.PrimaryKey);
}
var fks = _sr.ForeignKeys(null);
_noFks = (fks.Rows.Count == 0);
if (!_noFks)
{
_fkConverter = new SchemaConstraintConverter(fks, ConstraintType.ForeignKey);
}
//foreign key columns
var fkcols = _sr.ForeignKeyColumns(null);
_fkColumnConverter = new ForeignKeyColumnConverter(fkcols);
var uks = _sr.UniqueKeys(null);
_ukConverter = new SchemaConstraintConverter(uks, ConstraintType.UniqueKey);
var cks = _sr.CheckConstraints(null);
_ckConverter = new SchemaConstraintConverter(cks, ConstraintType.Check);
var dfs = _sr.DefaultConstraints(null);
_dfConverter = new SchemaConstraintConverter(dfs, ConstraintType.Default);
}
public ColumnLoader(SchemaExtendedReader schemaReader)
{
_sr = schemaReader;
var cols = _sr.Columns(null);
_noColumns = (cols.Rows.Count == 0);
_columnConverter = new ColumnConverter(cols);
}
public SchemaConstraintLoader(SchemaExtendedReader schemaReader)
{
_sr = schemaReader;
var pks = _sr.PrimaryKeys(null);
_noPks = (pks.Rows.Count == 0);
if (!_noPks)
{
_pkConverter = new SchemaConstraintConverter(pks, ConstraintType.PrimaryKey);
}
var fks = _sr.ForeignKeys(null);
_noFks = (fks.Rows.Count == 0);
if (!_noFks)
{
_fkConverter = new SchemaConstraintConverter(fks, ConstraintType.ForeignKey);
}
//foreign key columns
var fkcols = _sr.ForeignKeyColumns(null);
_fkColumnConverter = new ForeignKeyColumnConverter(fkcols);
var uks = _sr.UniqueKeys(null);
_ukConverter = new SchemaConstraintConverter(uks, ConstraintType.UniqueKey);
var cks = _sr.CheckConstraints(null);
_ckConverter = new SchemaConstraintConverter(cks, ConstraintType.Check);
var dfs = _sr.DefaultConstraints(null);
_dfConverter = new SchemaConstraintConverter(dfs, ConstraintType.Default);
}
public ViewColumnLoader(SchemaExtendedReader schemaReader)
{
_sr = schemaReader;
var cols = _sr.ViewColumns(null);
_noColumns = (cols.Rows.Count == 0);
_columnConverter = new ViewColumnConverter(cols);
}
public IndexLoader(SchemaExtendedReader schemaReader)
{
_sr = schemaReader;
DataTable indexes = _sr.Indexes(null);
DataTable indexColumns = _sr.IndexColumns(null);
//MySql and Postgresql only allow indexcolumns per table
_noIndexColumns = (indexColumns.Rows.Count == 0 && indexes.Rows.Count > 0);
_noIndexes = (indexes.Rows.Count == 0);
_indexConverter = new IndexConverter(indexes, indexColumns);
}
public IndexLoader(SchemaExtendedReader schemaReader)
{
_sr = schemaReader;
DataTable indexes = _sr.Indexes(null);
DataTable indexColumns = _sr.IndexColumns(null);
//MySql and Postgresql only allow indexcolumns per table
_noIndexColumns = (indexColumns.Rows.Count == 0 && indexes.Rows.Count > 0);
_noIndexes = (indexes.Rows.Count == 0);
_indexConverter = new IndexConverter(indexes, indexColumns);
}
public static SchemaExtendedReader Create(string connectionString, SqlType sqlType)
{
SchemaExtendedReader schemaReader;
switch (sqlType)
{
case SqlType.Oracle:
schemaReader = new OracleSchemaReader(connectionString, "System.Data.OracleClient");
break;
case SqlType.SqlServer:
schemaReader = new SqlAzureOrSqlServerSchemaReader(connectionString, "System.Data.SqlClient");
break;
case SqlType.SqlServerCe:
schemaReader = new SqlServerCeSchemaReader(connectionString, "System.Data.SqlServerCe.4.0");
break;
case SqlType.MySql:
schemaReader = new MySqlSchemaReader(connectionString, "MySql.Data.MySqlClient");
break;
case SqlType.PostgreSql:
schemaReader = new PostgreSqlSchemaReader(connectionString, "Npgsql");
break;
case SqlType.Db2:
schemaReader = new Db2SchemaReader(connectionString, "IBM.Data.DB2");
break;
case SqlType.SQLite:
schemaReader = new SchemaExtendedReader(connectionString, "System.Data.SQLite");
break;
default:
throw new ArgumentOutOfRangeException("sqlType", "Not a recognized SqlType");
}
return(schemaReader);
}
public ProcedureLoader(SchemaExtendedReader schemaReader, DatabaseSchema databaseSchema, Exclusions exclusions)
{
_schemaReader = schemaReader;
_databaseSchema = databaseSchema;
_exclusions = exclusions;
}
public static SchemaExtendedReader Create(string connectionString, string providerName)
{
if (string.IsNullOrEmpty(providerName))
throw new ArgumentNullException("providerName", "providerName must not be empty");
SchemaExtendedReader schemaReader = null;
var type = ProviderToSqlType.Convert(providerName);
switch (type)
{
case SqlType.Oracle:
schemaReader = new OracleSchemaReader(connectionString, providerName);
break;
case SqlType.SqlServer:
schemaReader = new SqlAzureOrSqlServerSchemaReader(connectionString, providerName);
break;
case SqlType.SqlServerCe:
schemaReader = new SqlServerCeSchemaReader(connectionString, providerName);
break;
case SqlType.MySql:
schemaReader = new MySqlSchemaReader(connectionString, providerName);
break;
case SqlType.PostgreSql:
schemaReader = new PostgreSqlSchemaReader(connectionString, providerName);
break;
case SqlType.Db2:
schemaReader = new Db2SchemaReader(connectionString, providerName);
break;
default:
//all the other types
if (providerName.Equals("Ingres.Client", StringComparison.OrdinalIgnoreCase))
{
schemaReader = new IngresSchemaReader(connectionString, providerName);
}
else if (providerName.Equals("iAnyWhere.Data.SQLAnyWhere", StringComparison.OrdinalIgnoreCase))
{
schemaReader = new SybaseAsaSchemaReader(connectionString, providerName);
}
else if (providerName.Equals("Sybase.Data.AseClient", StringComparison.OrdinalIgnoreCase))
{
schemaReader = new SybaseAseSchemaReader(connectionString, providerName);
}
else if (providerName.Equals("iAnyWhere.Data.UltraLite", StringComparison.OrdinalIgnoreCase))
{
schemaReader = new SybaseUltraLiteSchemaReader(connectionString, providerName);
}
else if (providerName.Equals("System.Data.OleDb", StringComparison.OrdinalIgnoreCase))
{
schemaReader = new OleDbSchemaReader(connectionString, providerName);
}
else if (providerName.Equals("System.Data.VistaDB", StringComparison.OrdinalIgnoreCase))
{
schemaReader = new VistaDbSchemaReader(connectionString, providerName);
}
else if (providerName.Equals("IBM.Data.DB2.iSeries", StringComparison.OrdinalIgnoreCase))
{
schemaReader = new Db2ISeriesSchemaReader(connectionString, providerName);
}
else if (providerName.Equals("FirebirdSql.Data.FirebirdClient", StringComparison.OrdinalIgnoreCase))
{
schemaReader = new FirebirdSqlSchemaReader(connectionString, providerName);
}
break;
}
if (schemaReader == null)
{
schemaReader = new SchemaExtendedReader(connectionString, providerName);
}
return schemaReader;
}
public static SchemaExtendedReader Create(string connectionString, SqlType sqlType)
{
SchemaExtendedReader schemaReader;
switch (sqlType)
{
case SqlType.Oracle:
schemaReader = new OracleSchemaReader(connectionString, "System.Data.OracleClient");
break;
case SqlType.SqlServer:
schemaReader = new SqlAzureOrSqlServerSchemaReader(connectionString, "System.Data.SqlClient");
break;
case SqlType.SqlServerCe:
schemaReader = new SqlServerCeSchemaReader(connectionString, "System.Data.SqlServerCe.4.0");
break;
case SqlType.MySql:
schemaReader = new MySqlSchemaReader(connectionString, "MySql.Data.MySqlClient");
break;
case SqlType.PostgreSql:
schemaReader = new PostgreSqlSchemaReader(connectionString, "Npgsql");
break;
case SqlType.Db2:
schemaReader = new Db2SchemaReader(connectionString, "IBM.Data.DB2");
break;
case SqlType.SQLite:
schemaReader = new SchemaExtendedReader(connectionString, "System.Data.SQLite");
break;
default:
throw new ArgumentOutOfRangeException("sqlType", "Not a recognized SqlType");
}
return schemaReader;
}
public AllTablesLoader(SchemaExtendedReader schemaReader, Exclusions exclusions)
{
_schemaReader = schemaReader;
_exclusions = exclusions;
}
public static SchemaExtendedReader Create(string connectionString, string providerName)
{
if (string.IsNullOrEmpty(providerName))
{
throw new ArgumentNullException("providerName", "providerName must not be empty");
}
SchemaExtendedReader schemaReader = null;
var type = ProviderToSqlType.Convert(providerName);
switch (type)
{
case SqlType.Oracle:
schemaReader = new OracleSchemaReader(connectionString, providerName);
break;
case SqlType.SqlServer:
schemaReader = new SqlAzureOrSqlServerSchemaReader(connectionString, providerName);
break;
case SqlType.SqlServerCe:
schemaReader = new SqlServerCeSchemaReader(connectionString, providerName);
break;
case SqlType.MySql:
schemaReader = new MySqlSchemaReader(connectionString, providerName);
break;
case SqlType.PostgreSql:
schemaReader = new PostgreSqlSchemaReader(connectionString, providerName);
break;
case SqlType.Db2:
schemaReader = new Db2SchemaReader(connectionString, providerName);
break;
default:
//all the other types
if (providerName.Equals("Ingres.Client", StringComparison.OrdinalIgnoreCase))
{
schemaReader = new IngresSchemaReader(connectionString, providerName);
}
else if (providerName.Equals("iAnyWhere.Data.SQLAnyWhere", StringComparison.OrdinalIgnoreCase))
{
schemaReader = new SybaseAsaSchemaReader(connectionString, providerName);
}
else if (providerName.Equals("Sybase.Data.AseClient", StringComparison.OrdinalIgnoreCase))
{
schemaReader = new SybaseAseSchemaReader(connectionString, providerName);
}
else if (providerName.Equals("iAnyWhere.Data.UltraLite", StringComparison.OrdinalIgnoreCase))
{
schemaReader = new SybaseUltraLiteSchemaReader(connectionString, providerName);
}
else if (providerName.Equals("System.Data.OleDb", StringComparison.OrdinalIgnoreCase))
{
schemaReader = new OleDbSchemaReader(connectionString, providerName);
}
else if (providerName.Equals("System.Data.VistaDB", StringComparison.OrdinalIgnoreCase))
{
schemaReader = new VistaDbSchemaReader(connectionString, providerName);
}
else if (providerName.Equals("IBM.Data.DB2.iSeries", StringComparison.OrdinalIgnoreCase))
{
schemaReader = new Db2ISeriesSchemaReader(connectionString, providerName);
}
break;
}
if (schemaReader == null)
{
schemaReader = new SchemaExtendedReader(connectionString, providerName);
}
return(schemaReader);
}
public DbProviderReaderAdapter(SchemaParameters schemaParameters)
: base(schemaParameters)
{
_schemaReader = SchemaReaderFactory.Create(schemaParameters.ConnectionString, schemaParameters.ProviderName);
_schemaReader.Owner = schemaParameters.Owner;
}
public ProcedureLoader(SchemaExtendedReader schemaReader, DatabaseSchema databaseSchema, Exclusions exclusions)
{
_schemaReader = schemaReader;
_databaseSchema = databaseSchema;
_exclusions = exclusions;
}
public TableLoader(SchemaExtendedReader schemaReader, DatabaseSchema databaseSchema)
{
_schemaReader = schemaReader;
_databaseSchema = databaseSchema;
}
public AllTablesLoader(SchemaExtendedReader schemaReader, Exclusions exclusions)
{
_schemaReader = schemaReader;
_exclusions = exclusions;
}
public TableLoader(SchemaExtendedReader schemaReader, DatabaseSchema databaseSchema)
{
_schemaReader = schemaReader;
_databaseSchema = databaseSchema;
}
