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