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