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