| Name | Description | |
|---|---|---|
 | PostgreSqlProvider Constructor | Perform initialization of the Provider |
The following tables list the members exposed by PostgreSqlProvider.
Public Constructors
Public Properties
| Name | Description | |
|---|---|---|
 | Connection | Get a reference to the database connection (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) |
| ConnectionString | The connection string (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) |
| DatabaseName | Returns database name (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) |
| DirtyReadClause | Overridden. PostgreSql does not support dirty reads |
| FriendlyProviderName | Overridden. Get a friendly name for the provider |
| IsConnectionOpen | True if the connection is open (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) |
| IsFileBasedDatabase | Overridden. The database is not a single file |
| IsInTransaction | True if we are inside a transaction (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) |
| LicenseKey | The license key for the license (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) |
| MixedCase | Gets or sets a value indicating whether /[mixed case]. The default for PostgreSQL is false |
| ParameterPrefix | Overridden. The parameter prefix for PostgreSQL is _ |
| SupportComments | Returns true if the provider supports comments (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) |
| Transaction | Get a reference to the current transaction (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) |
| UserName | The user name for the license (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) |
Protected Properties
| Name | Description | |
|---|---|---|
 | IsBatchMode | Returns true if batch mode is active (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) |
Public Methods
| Name | Description | |
|---|---|---|
 | BeginTransaction | Begin a new transaction (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) |
| BuildDatabaseSpecificConnectionString | Overridden. Build a connection string based on the passed in database |
| ChangeDatabase | Overridden. Change database |
| ClearLog | Overloaded. Clear the file log (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) |
| CloseConnection | Close the database connection (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) |
| CommitTransaction | Commit the current transaction (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) |
| ConnectionValid | Opens and closes the connection to ensure it is valid. (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) |
| CountRecordsInTable | Overridden. Get the number of records in a table |
| CreateDatabase | Overridden. Create new database |
| DatabaseExists | Overridden. Check database existence |
| DisableLogging | Disable all logging (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) |
| Dispose | Close the connection on Dispose (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) |
| DropTable | Drop (remove) a table from the database (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) |
| EnableLogging | Overloaded. Log to the console (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) |
| ExecuteNonQuery | Overloaded. Execute the passed query and return the number of affected records (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) |
| ExecuteNonQuerySproc | Overloaded. Execute the passed stored procedure and return the number of affected records. Output parameters will be set on return. (Inherited from KellermanSoftware.NetDataAccessLayer.BaseStoredProcedureProvider) |
| ExecuteScalar | Overloaded. Execute the passed query and return the first column of the first row (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) |
| ExecuteScalarSproc | Overloaded. Execute the passed stored procedure and return the first column of the first row (Inherited from KellermanSoftware.NetDataAccessLayer.BaseStoredProcedureProvider) |
| FillDataTable | Overloaded. Fill a data table with the passed sql and parameters (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) |
| ForeignKeyExists | Returns true if the Foreign Key Exists (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) |
| GetAddColumnSql | Get the SQL for adding a column to an existing table (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) |
| GetAllForeignKeyConstraints | Overridden. Get all the foreign key constraints for the database |
| GetColumnDefinitionSql | Overridden. Get portion of SQL used for the column definition for add column and create table sql |
| GetCommentLine | Get sql comment using the given comment text (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) |
| GetCommentSeparatorLine | Get comment separator line (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) |
| GetCreateIndexSql | Get the SQL needed to create an index |
| GetCreateSequenceSql | Overridden. Currently not supported |
| GetCreateTableSql | Get the SQL for creating a table with the primary key (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) |
| GetCreateTableSqlWithCompositeKey | Overridden. Get the SQL for creating a table with composite keys |
| GetCreateTableSqlWithPrimaryKey | Overridden. Get the SQL for creating a table with a primary key |
| GetCreateTablesSql | Get the SQL to create the tables (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) |
| GetCreateTriggerSql | Overridden. Currently not supported |
| GetDatabaseNameFromConnectionString | Overridden. Get database name from connection string. |
| GetDatabases | Overridden. Get a list of databases for the database server |
| GetDatabaseServerDate | Overridden. Get the current database date |
| GetDatabaseTables | Overridden. Get a list of tables for the current database |
| GetDatabaseTypeForDbType | Overridden. Get the database field type for the passed standard DbType |
| GetDataTable | Overloaded. Get a datatable from the passed sql (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) |
| GetDbType | Overridden. Get a DbType associated with a string from a database |
| GetDbTypeForClrType | Get the DbType for provided ClrType (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) |
| GetDropSequenceSql | Overridden. Currently not supported |
| GetDropTableSql | Overridden. Get the sql to drop a table |
| GetDropTriggerSql | Overridden. Currently not supported |
| GetFieldType | Overridden. Get a .NET type associated with a string from a database |
| GetIdentity | Get the identity for the last insert in the current scope |
| GetIdentitySql | Get the SQL used to get the identity for the last inserted record |
| GetIndexesForTable | Get indexes for a table |
| GetLimitClause | Get a limit clause for a provider |
| GetMaxPrimaryKey | Get the maximum value for the primary key (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) |
| GetMaxPrimaryKeySql | Get the SQL required to get the maximum value of the primary key (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) |
| GetPagingSql | Generate SQL that will get a page of records |
| GetRecordsFromSproc | Get records from stored procedure using passed parameters (Inherited from KellermanSoftware.NetDataAccessLayer.BaseStoredProcedureProvider) |
| GetServerNameFromConnectionString | Overridden. Get the server name from the connection string |
| GetTruncateSql | Overridden. Get the sql to truncate a table. |
| GetUpdateTablesSql | Get the SQL to update the tables (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) |
| IndexExists | Returns true if an index exists for a given table |
| Load | Overloaded. Get a list of records using the passed SQL (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) |
| LoadFromSproc | Overloaded. Get records by stored procedure with the passed parameters (Inherited from KellermanSoftware.NetDataAccessLayer.BaseStoredProcedureProvider) |
| LoadOne | Overloaded. Overridden. Get one record from a table by the passed column and value |
| LoadPage | Get a page of records for a table (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) |
| LoadTop | Overloaded. Get a limited number of records for a table (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) |
| MarkForeignKeys | Mark foreign key columns by convention (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) |
| MarkPrimaryKey | Mark Primary Key in a table (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) |
| MarkPrimaryKeys | Mark primary key columns by convention (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) |
| OpenConnection | Open the database connection (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) |
| RecordExists | Overloaded. Returns true if the record exists (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) |
| RollbackTransaction | Perform a rollback of the current transaction (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) |
| StoredProcedureExists | Overridden. Returns true if the stored procedure exists |
| TableExists | Overridden. Returns true if the table exists |
| TruncateTable | Delete all the records from a table (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) |
| Wrap | Overridden. For PostgreSql table names and field names are not wrapped in square brackets or back ticks |
Protected Methods
Top
See Also