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