public static IGenerator createGenerator(
ConnectionFactory.DBType type,
string host,
string database,
string user,
string pwd)
{
DbConnection con = null;
switch (type)
{
case ConnectionFactory.DBType.Ingres:
con = new Ingres.Client.IngresConnection(
ConnectionFactory.createConnectionString(
ConnectionFactory.DBType.Ingres,
host,
database,
user,
pwd));
//return new IngresGenerator();
return(new SchemaGenerator(con));
case ConnectionFactory.DBType.Postgres:
con = new Postgres.Client.PostgresConnection(
ConnectionFactory.createConnectionString(
ConnectionFactory.DBType.Postgres,
host,
database,
user,
pwd));
//return new IngresGenerator();
return(new SchemaGenerator(con));
case ConnectionFactory.DBType.Oracle:
con = new Oracle.Client.OracleConnection(
ConnectionFactory.createConnectionString(
ConnectionFactory.DBType.Oracle,
host,
database,
user,
pwd));
return(new SchemaGenerator(con));
}
throw new Exception("Unknown Type");
}
public EFDbConfiguration(ConnectionFactory.DBType dbType)
{
if (dbType == ConnectionFactory.DBType.MySql)
{
//DbMigrationsConfiguration.SetSqlGenerator("MySql.Data.MySqlClient", new MySql.Data.Entity.MySqlMigrationSqlGenerator());
//<add name="MySQL Data Provider" invariant="MySql.Data.MySqlClient" description=".Net Framework Data Provider for MySQL" type="MySql.Data.MySqlClient.MySqlClientFactory, MySql.Data, Version=6.8.3.0" />
string invariantname = MySql.Data.Entity.MySqlProviderInvariantName.ProviderName;//MySql.Data.MySqlClient
this.SetDefaultConnectionFactory(new MySql.Data.Entity.MySqlConnectionFactory());
//this.AddDependencyResolver(new SingletonDependencyResolver<IDbConnectionFactory>(new MySql.Data.Entity.MySqlConnectionFactory()));
this.SetProviderFactory(invariantname, new MySql.Data.MySqlClient.MySqlClientFactory());
this.SetProviderServices(invariantname, new MySql.Data.MySqlClient.MySqlProviderServices());
}
else if (dbType == ConnectionFactory.DBType.SQLServer)
{
this.SetDefaultConnectionFactory(new System.Data.Entity.Infrastructure.SqlConnectionFactory());
this.SetProviderServices("System.Data.SqlClient", System.Data.Entity.SqlServer.SqlProviderServices.Instance);
//this.AddDependencyResolver(new SingletonDependencyResolver<IDbConnectionFactory>(new System.Data.Entity.Infrastructure.SqlCeConnectionFactory(invariantname)));
//SetProviderFactory("System.Data.SqlClient",new System.Data.SqlClient.DbProviderFactory());
}
}
