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; }