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.

Did you like Npgsql? If so, send us a postcard! Send a mail to francisco at npgsql dot org and I will reply you back with the addresses you can sent it to.

Thank you very much!

Latest News

*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 Reynolds.  Lostechies 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.