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

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.