Npgsql

Npgsql is a .Net Data Provider for Postgresql. It allows any program developed for .Net framework to access database server. It is implemented in 100% C# code. Works with Postgresql 7.x and above.

Latest News

2014-04-09 Npgsql 2.1.3 released! This version contains fixes for #165 (KeyNotFoundException when setting ApplicationName on NpgsqlConnectionStringBuilder) and a regression when using NHibernate with queries containing '<' operator. #193 (Less Than' prepare failing).

2014-03-20 Npgsql 2.1.1 released! This is a one bug fix for the 2.1.0 release. This release contains a single last minute patch to fix HasRows property: Return true from NpgsqlDataReader.HasRows even after all rows have been read https://github.com/npgsql/Npgsql/pull/181 If you aren't affected by this bug, you don't need to download this version again. You can get more info about this release in github release notes. Nuget packages are available here. You also can download packages from github and pgfoundry.

2014-03-20 Npgsql 2.1 released! After a long time in the 2.0.x series, version 2.1 is available! You can get more info about this release in github release notes. Nuget packages are available here. You also can download packages from github and pgfoundry.

2014-01-17 Npgsql Google groups created! Today we created two groups related to Npgsql:
Npgsql-dev is for developer discussions on Npgsql.
Npgsql-help is for questions and discussion on Npgsql.
Give it a try on those groups and let the discussion begin!

2013-12-26 Npgsql 2.1.0 beta1 released! After a long time in the 2.0.x series, the first 2.1 beta release is available. This is a big performance and features improvements release. You can get more info about this release in github release notes. Nuget packages are available here. You also can download packages from github and pgfoundry.

2013-12-21 Npgsql 2.0.14.3 released! This is a small bugfix for Boolean constants converted to ETRUE and EFALSE instead of TRUE and FALSE when using Entity Framework. More info can be found on this github issue: https://github.com/npgsql/Npgsql/issues/132 You can download this version from Nuget: https://www.nuget.org/packages/Npgsql/2.0.14.3 and zip packages are available from github releases page: https://github.com/npgsql/Npgsql/releases/tag/v2.0.14.3

2013-12-15 Npgsql 2.0.14.2 released! This is a small bugfix release with fix for hangs which could happen when connecting to Postgresql 9.3. More info can be found here: http://fxjr.blogspot.com/2013/12/npgsql-2014-released.html You can download this version from Nuget: https://www.nuget.org/packages/Npgsql/2.0.14.2
We are working to get the zip packages built and they will be available soon.

2013-06-28 Npgsql2 2.0.13 beta1 released! Npgsql development team is proud to announce we just released our first beta of the 2.0.13 version. Check here for more details. This version brings a lot of improvements and fixes.

2013-06-23 Npgsql2 has initial Entity Framework 6 support. Check here for more information about it.

2013-05-02 Npgsql2 code repository changed to GitHub. Npgsql code is now hosted on GitHub. Find it here: http://git.npgsql.org More info about the change can be found here .

2012-09-02 Npgsql2 stable release 2.0.12 is out. Npgsql team is proud to announce we just released Npgsql 2.0.12 stable release. After more than a year of development, it is finally here. Please, get it from our downloads page and give it a try. Let us know what you think.

2012-07-06 Npgsql2 new stable release 2.0.12 is near. Yesterday we released the last beta of Npgsql. A new final release is coming later this month. If you want to give it a try today, please download it from the downloads page

2011-12-14 Npgsql2 source code mirror now available on github You can get more information on this blog post.

2011-05-29 Npgsql VS.Net Design Time support preview available for download! Thanks to Jerónimo Milea, Npgsql now has an initial support for design time in VS.Net. Check out here for more information about how to set it up and test it. Download it here. Please, let us know what do you think in our full release notes for more information. Download it here

2010-11-04 Npgsql bug when handling bytea data with Postgresql 9.0 We are aware of this problem and a fix is already done. We plan to release a new version with this fix in a couple days. Sorry for any problem. The current workaround is change postgresql.conf to use the previous mode of bytea handling. For more info, see this bug report

2010-09-14 Npgsql receives donation of a NDepend license! I would like to thank NDepend guys for donating us a license. We will be using it to analyse and improve our source code. Thank you! Check out more info about this tool at NDepend Homepage

2010-09-06 Npgsql2 2.0.10 fixes a huge problem with data handling. If you are seeing problems with 2.0.9 about 'backend sent an unrecognized message', or something strange about data which shouldn't be there, please, update to 2.0.10 or downgrade to 2.0.8. Npgsql 2.0.9 has a problem handling data coming from server due to a buffer problem. Check here for more details.

2010-08-23 Npgsql receives donation of an MSDN subscription! I'd like to thank the people who contributed to make this possible: Codebetter Crew: Ben Hall, Ward Bell, James Kovacs. Devlicious Crew: Hadi Hariri, Christopher Bennage, Tim Barcz, Rob ReynoldsLostechies Crew: Eric Hexter, Jimmy Bogard, Keith Dahlby and Josh Cooley for heads up! Check out the details here!

2010-04-02 Added SSL Connection article to blog! I just wrote an article about SSL Connection to highlight how to do it based on help of our Forums users Laurenz Albe and Jennifer Marienfeld. Check it out here!

2010-01-16 New Forums section created! Today we created a new section on our Forums called "articles". There you can post links to articles about Npgsql and/or .Net in general which can help Npgsql users. Please, fill free to check it out and post your links.

2009-12-28 Npgsql2 2.0.8 Released! This is a small bug fix release to the stable 2.0.x series. This release brings initial support to better handle Npgsql specific datatypes (i.e.: NpgsqlTimeStamp) and CLR datatypes(i.e.:DateTime) This way developer will have a possibility to get the best type for her work. Josh added fixes to Entity framework sql generation. Check out full release notes for more information.

2009-11-15 Npgsql2 2.0.7 Released! This is a small bug fix release to the stable 2.0.x series. This release brings fixes for problems with canceled queries, connection string builder properties and speed improvements. Check out full release notes for more information.

2009-07-11 Npgsql2 2.0.6 Released! This is a small bug fix release to the stable 2.0.x series. This release brings fixes for problems with command timeout, entity framework localization queries and many other bugs. Check out full release notes for more information.

2009-05-06 Npgsql2 2.0.5 Released! This is a small bug fix release to the stable 2.0.x series. This release brings fixes for regression with prepared statements and parameter size, fix for the famous stream does not support seek operation exception and others. Check out full release notes for more information.

2009-03-01 Npgsql2 2.0.4 Released! This is a small bug fix release to the stable 2.0.x series. This release brings fixes for last minute breaks input bytea handling and floating point values. Check out full release notes for more information.

2009-02-24 Npgsql2 2.0.3 Released! This is a small bug fix release to the stable 2.0.x series. This release brings some fixes for entity framework support and parameters handling. Check out full release notes for more information.

2008-11-04 Npgsql2 2.0.1 Released! This is a small bug fix release to the stable 2.0 final version. This release brings some fixes for entity framework support.

2008-10-06 Npgsql2 RTM released! After almost two years of development since Npgsql 1.0, Npgsql 2 brings new features and support for newer versions of .Net. Although externally Npgsql2 doesn't seem very different of Npgsql1 regarding features, internally Npgsql2 had a lot of improvements which represents a much more stable product, more bugs fixed and many implemented methods. It is strongly advised that current users update from Npgsql1 to Npgsql2.

Main features are:

  • Support for .Net 2.0 and 3.5
  • Entity Framework (EF): Josh Cooley did a great job and added support for EntityFramework. In order to use it, you have to download a special build with the 3.5 suffix in its name on our download page.
  • Improved performance for large resultsets:Different from Npgsql1, Npgsql2 doesn't read all table contents before returning control to user code. This makes Npgsql much more memory efficient when dealing with large tables. Thanks Jon Hanna for this.
    Check User Manual for more info about that and how to revert to old behavior of loading all data if you need it.
  • ASP.Net Providers: Thanks to Daniel Nauck, Npgsql now have support for ASP.Net providers. You can visit Daniel project page at: http://dev.nauck-it.de/projects/show/aspsqlprovider/
Thanks everybody which helped us to make this release with comments, patches and bug reports!

2008-07-28 Today, Npgsql project received a server donation from a person who prefers to remain anonymous. Now we will be able to provide some nightly builds as well a continuous integration build system. We are thinking about using CruiseControl.net. Thank you very much for this donation!

2008-05-15 Npgsql RC1 has been released!! Thanks Josh Cooley for all the help building it and for all others who helped with bug reports, fixes and comments. See changelog for more info. Give it a try!

2008-07-28 Added Daniel Nauck's ASP.Net Membership, Role, Profile and Session-State Store Provider Project to our list of projects which use Npgsql. Thanks, Daniel, for your work, help and support!

2008-05-15 Npgsql beta4 has been released!! See release notes for more info. Give it a try!

2008-04-07 Npgsql beta3 has been released!! See release notes for more info. Highlight goes to Jon Hanna's patch to improve Npgsql scalability when handling large resultsets. Give it a try!

2008-03-08 Npgsql has a TLD domain: npgsql.org! Now you can type: www.npgsql.org or just npgsql.org in your firefox!! Enjoy!

2007-11-06 Npgsql2 Beta1 Released!! Check out release notes here

2007-08-31 Npgsql Project Homepage has a new look! After some research on open source web design sites: www.oswd.org, http://www.openwebdesign.org and http://www.opendesigns.org, I finally choose this one, from styleshout. Npgsql Homepage now looks nicer than previous one. :)

2007-08-27 Npgsql is now licensed under BSD!! Check more info here

2007-08-27 Mike Griffin from EntitySpaces LLC informed us they concluded their Postgresql support using Npgsql!
More info can be found here.
Thank you Mike for your help and support!

Quotes from our users

Npgsql has been instrumental in getting our applications running on Windows as well as unix based systems under Mono. Thanks for all your hard work!

-- Robert S Wojciechowski
Lead Developer
SSG Innovations LLC / ExpressYard
www.ssgx.com / www.expressyard.com


Projects using Npgsql

These are projects which use Npgsql. Please, if you aren't seeing your project name here post a message in our forums about it.

  • MyGeneration - Code Generation, O/R Mapping, and Architectures

  • Gentle .NET - Object Persistence Framework

  • NHibernate - Port of Hibernate Core for Java to the .NET Framework

  • NpgsqlAltPool - Alternate connection pool implementation by Mikko Korkalo

  • .Traf - Proxy Server Log Analyzer

  • mojoPortal - An Object Oriented web site framework written in C#

  • npgsqldaab - An extension of Microsoft's Data Access Application Blocks for PostgreSQL

  • LLBLGen Pro - the productive O/R mapper for .NET

  • Lightning Admin - is a GUI administration program that is designed for Microsoft Windows. Note it is still under development

  • AspSQLProvider - is a PostgreSQL implementation of the ASP.NET 2.0 Membership, Role, Profile and Session-State Store Provider.

  • DataObjects.Net 4 - is rapid database application development framework.

Sites powered by Npgsql

These are sites which use Npgsql. Please, if you aren't seeing your project name here post a message in our forums about it.