/// <summary>
/// Returns the schema collection specified by the collection name filtered by the restrictions.
/// </summary>
/// <param name="collectionName">The collection name.</param>
/// <param name="restrictions">
/// The restriction values to filter the results. A description of the restrictions is contained
/// in the Restrictions collection.
/// </param>
/// <returns>The collection specified.</returns>
public override DataTable GetSchema(string collectionName, string[] restrictions)
{
using (var tempConn = new NpgsqlConnection(ConnectionString))
{
switch (collectionName)
{
case "MetaDataCollections":
return(NpgsqlSchema.GetMetaDataCollections());
case "Restrictions":
return(NpgsqlSchema.GetRestrictions());
case "DataSourceInformation":
return(NpgsqlSchema.GetDataSourceInformation());
case "DataTypes":
throw new NotSupportedException();
case "ReservedWords":
return(NpgsqlSchema.GetReservedWords());
// custom collections for npgsql
case "Databases":
return(NpgsqlSchema.GetDatabases(tempConn, restrictions));
case "Schemata":
return(NpgsqlSchema.GetSchemata(tempConn, restrictions));
case "Tables":
return(NpgsqlSchema.GetTables(tempConn, restrictions));
case "Columns":
return(NpgsqlSchema.GetColumns(tempConn, restrictions));
case "Views":
return(NpgsqlSchema.GetViews(tempConn, restrictions));
case "Users":
return(NpgsqlSchema.GetUsers(tempConn, restrictions));
case "Indexes":
return(NpgsqlSchema.GetIndexes(tempConn, restrictions));
case "IndexColumns":
return(NpgsqlSchema.GetIndexColumns(tempConn, restrictions));
case "Constraints":
case "PrimaryKey":
case "UniqueKeys":
case "ForeignKeys":
return(NpgsqlSchema.GetConstraints(tempConn, restrictions, collectionName));
case "ConstraintColumns":
return(NpgsqlSchema.GetConstraintColumns(tempConn, restrictions));
default:
throw new ArgumentOutOfRangeException("collectionName", collectionName, "Invalid collection name");
}
}
}
/// <summary>
/// Returns the schema collection specified by the collection name filtered by the restrictions.
/// </summary>
/// <param name="collectionName">The collection name.</param>
/// <param name="restrictions">
/// The restriction values to filter the results. A description of the restrictions is contained
/// in the Restrictions collection.
/// </param>
/// <returns>The collection specified.</returns>
public DataTable GetSchema(string collectionName, string[] restrictions)
{
switch (collectionName)
{
case "MetaDataCollections":
return(NpgsqlSchema.GetMetaDataCollections());
case "Restrictions":
return(NpgsqlSchema.GetRestrictions());
case "DataSourceInformation":
case "DataTypes":
case "ReservedWords":
throw new NotSupportedException();
// custom collections for npgsql
case "Databases":
return(new NpgsqlSchema(new NpgsqlConnection(ConnectionString)).GetDatabases(restrictions));
case "Tables":
return(new NpgsqlSchema(new NpgsqlConnection(ConnectionString)).GetTables(restrictions));
case "Columns":
return(new NpgsqlSchema(new NpgsqlConnection(ConnectionString)).GetColumns(restrictions));
case "Views":
return(new NpgsqlSchema(new NpgsqlConnection(ConnectionString)).GetViews(restrictions));
case "Users":
return(new NpgsqlSchema(new NpgsqlConnection(ConnectionString)).GetUsers(restrictions));
default:
throw new NotSupportedException();
}
}
/// <summary>
/// Returns the supported collections
/// </summary>
public override DataTable GetSchema()
{
return(NpgsqlSchema.GetMetaDataCollections());
}