public void DetectsSqlServer()
{
const string providername = "System.Data.SqlClient";
var connectionString = ConnectionStrings.Northwind;
ProviderChecker.Check(providername, connectionString);
var target = new SqlAzureOrSqlServerSchemaReader(connectionString, providername);
var actual = target.IsAzureSqlDatabase;
Assert.IsFalse(actual);
}
public void DetectsSqlAzure()
{
const string providername = "System.Data.SqlClient";
const string connectionString = @"Server=tcp:SERVERNAME.database.windows.net,1433;Database=DBNAME;User ID=USERNAME@SERVERNAME;Password=PASSWORD;Trusted_Connection=False;Encrypt=True;";
ProviderChecker.Check(providername, connectionString);
var target = new SqlAzureOrSqlServerSchemaReader(connectionString, "System.Data.SqlClient");
var actual = target.IsAzureSqlDatabase;
Assert.IsTrue(actual);
}
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 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 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);
}