Npgsql

Written entirely in C#, Npgsql is basically a .NET abstraction class for PostrgeSQL, a concept very familiar and widely used with PHP and MySQL databases.

Npgsql basically allows developers to inter-connect C# code with raw SQL operations, without exposing crucial database data and authentication details in the raw, original C# code.

Npgsql prototypes and abstracts (hence the abstraction class moniker) basic operations to common C# syntax, allowing developers to write complex SQL queries using C# code.

Besides classic .NET environments, Mono is supported as well.

What is new in this release:

• This is an important bugfix release, everyone should upgrade. Particularly important is a leak due to an EntityFramework issue.

What is new in version 3.0.4:

• This is an important bugfix release, everyone should upgrade. Particularly important is a leak due to an EntityFramework issue.

What is new in version 3.0.3:

• This is an important bugfix release, everyone should upgrade. Particularly important is a leak due to an EntityFramework issue.

What is new in version 2.2.6:

• This is an important bugfix release, everyone should upgrade. Particularly important is a leak due to an EntityFramework issue.

What is new in version 2.2.5:

• This is an important bugfix release, everyone should upgrade. Particularly important is a leak due to an EntityFramework issue.

What is new in version 2.2.4.3:

• Visual Studio DDEX support
• SSLStream support
• Added support for JSON, JSONB and HSTORE datatypes
• Added GSSAPI support on Windows
• Removed support for protocol v2
• Removed support for PostgreSQL 8.4 and below

What is new in version 2.1.1:

• This release contains a single last minute patch to fix HasRows property: Return true from NpgsqlDataReader.HasRows even after all rows have been read.

What is new in version 2.0.12:

• Fixed bugs:
• Wrong SQL statement based on LINQ Query.

What is new in version 2.0.11.91:

• Npgsql bug when handling bytea data with Postgresql 9.0.

What is new in version 2.0.10:

• Added NET40 define so the .NET 4.0 code gets compiled in.
• Added UInt16 type mapping.

Requirements:

• PostgreSQL 7 or higher