private BaseMetadataProvider GetMetadataProvider() { BaseMetadataProvider metaprov = null; switch (this.DatabasePlatform) { case QueryBuilderDatabasePlatform.Sybase: metaprov = new UniversalMetadataProvider(); AseConnection aseConn = new AseConnection(this.ConnectionString); metaprov.Connection = (IDbConnection)aseConn; //workaround for problem with using Sybase provider //NOTE: has been fixed as of 11/26/2013 release: see above code (12/2/13 mc) //metaprov = new ODBCMetadataProvider(); //string odbcConnectionString = ConvertSybaseConnectionStringToOdbc(this.ConnectionString); //OdbcConnection aseConn = new OdbcConnection(odbcConnectionString); //metaprov.Connection = (IDbConnection)aseConn; break; default: metaprov = new UniversalMetadataProvider(); metaprov.Connection = new OdbcConnection(this.ConnectionString); break; } return(metaprov); }
private BaseMetadataProvider GetMetadataProvider() { BaseMetadataProvider metaprov = null; switch (this.DatabasePlatform) { case QueryBuilderDatabasePlatform.Informix: queryBuilder.MetadataLoadingOptions.LoadSystemObjects = true; metaprov = new InformixMetadataProvider(); metaprov.Connection = new IfxConnection(this.ConnectionString); queryBuilder.DatabaseSchemaTreeOptions.DefaultExpandLevel = 0; //universal provider no better than informix metadata provider: still no objects showing in right side objects pane //metaprov = new UniversalMetadataProvider(); //IfxConnection ifxConn = new IfxConnection(this.ConnectionString); //metaprov.Connection = (IDbConnection)ifxConn; break; default: metaprov = new UniversalMetadataProvider(); metaprov.Connection = new OdbcConnection(this.ConnectionString); break; } return(metaprov); }
private BaseMetadataProvider GetMetadataProvider() { BaseMetadataProvider metaprov = null; switch (this.DatabasePlatform) { case QueryBuilderDatabasePlatform.MSSQLServer: metaprov = new MSSQLMetadataProvider(); metaprov.Connection = new SqlConnection(this.ConnectionString); break; case QueryBuilderDatabasePlatform.SQLServerCE: //metaprov = new MSSQLCEMetadataProvider(); //does not work //metaprov = new UniversalMetadataProvider(); //does not work //metaprov.Connection = new SqlCeConnection(this.ConnectionString); string oledbConnectionString = ConvertSQLCE35ConnectionStringToOLEDB(this.ConnectionString); metaprov = new OLEDBMetadataProvider(); metaprov.Connection = new OleDbConnection(oledbConnectionString); queryBuilder.DatabaseSchemaTreeOptions.DefaultExpandLevel = 0; break; case QueryBuilderDatabasePlatform.OLEDB: metaprov = new OLEDBMetadataProvider(); metaprov.Connection = new OleDbConnection(this.ConnectionString); break; case QueryBuilderDatabasePlatform.ODBC: metaprov = new ODBCMetadataProvider(); metaprov.Connection = new OdbcConnection(this.ConnectionString); break; case QueryBuilderDatabasePlatform.MSAccess: metaprov = new OLEDBMetadataProvider(); metaprov.Connection = new OleDbConnection(this.ConnectionString); queryBuilder.DatabaseSchemaTreeOptions.DefaultExpandLevel = 0; break; case QueryBuilderDatabasePlatform.Oracle: metaprov = new OracleMetadataProvider(); metaprov.Connection = new System.Data.OracleClient.OracleConnection(this.ConnectionString); queryBuilder.DatabaseSchemaTreeOptions.DefaultExpandLevel = 0; break; default: metaprov = new UniversalMetadataProvider(); metaprov.Connection = new OdbcConnection(this.ConnectionString); break; } return(metaprov); }
private BaseMetadataProvider GetMetadataProvider() { BaseMetadataProvider metaprov = null; switch (this.DatabasePlatform) { case QueryBuilderDatabasePlatform.MySQL: metaprov = new MySQLMetadataProvider(); metaprov.Connection = new MySqlConnection(this.ConnectionString); break; default: metaprov = new UniversalMetadataProvider(); metaprov.Connection = new OdbcConnection(this.ConnectionString); break; } return(metaprov); }
private BaseMetadataProvider GetMetadataProvider() { BaseMetadataProvider metaprov = null; switch (this.DatabasePlatform) { case QueryBuilderDatabasePlatform.Oracle: metaprov = new OracleMetadataProvider(); metaprov.Connection = new System.Data.OracleClient.OracleConnection(this.ConnectionString); queryBuilder.DatabaseSchemaTreeOptions.DefaultExpandLevel = 0; break; default: metaprov = new UniversalMetadataProvider(); metaprov.Connection = new OdbcConnection(this.ConnectionString); break; } return(metaprov); }
private BaseMetadataProvider GetMetadataProvider() { BaseMetadataProvider metaprov = null; switch (this.DatabasePlatform) { case QueryBuilderDatabasePlatform.SQLServerCE_V4: metaprov = new MSSQLCEMetadataProvider(); metaprov.Connection = new SqlCeConnection(this.ConnectionString); queryBuilder.DatabaseSchemaTreeOptions.DefaultExpandLevel = 0; break; default: metaprov = new UniversalMetadataProvider(); metaprov.Connection = new OdbcConnection(this.ConnectionString); break; } return(metaprov); }