Skip to main content

Npgsql 2.0.13 beta1 released!


Today we released the first beta of Npgsql 2.0.13! 

This new beta release had a lot of bugs fixed and initial support for Entity Framework 6! More information about how to use Entity framework 6 with Npgsql can be found in this post.

Checkout the release notes for more information about the bugs fixed in this release.

Download it from our downloads section.

Important notice about this release


Unfortunately, I made a mistake when updating the assembly version for this release and it was created with a wrong value. I'm very sorry for that.

This release should have been 2.0.12.91 and not 2.0.13.91

Next beta release will have the version value fixed.

What are the implications? 

The biggest problem is that this beta version will have a version number higher than the final 2.0.13 version while this beta version has 2.0.13.91. As it is a beta and it is not supposed to be deployed in production systems, we think this won't give problems to our users. We are very sorry for any problem this may have caused.

How is Npgsql assembly versioned?

In the beginning, we used to use the same assembly version througout all the beta release cycle until the final release.
With this approach, Npgsql 2.0.10 beta1 would have the assembly version of 2.0.10.0 and beta2 would also have the assembly version of 2.0.10.0. This was creating confusion between users because they couldn't differentiate which version they were working with.

Starting with 2.0.11, we changed this in order to identify each version. We started to use the last two parts of the assembly version in order to identify beta releases. 

This way, a beta release was identified in the following form:

  • Npgsql 2.0.11 beta1 would be identified as: 2.0.10.91;
  • Npgsql 2.0.11 beta2 would be identified as 2.0.10.92 and so on. 
With this schema, the beta versions will be incremented towards the final version 2.0.11.0. 


Regarding this 2.0.13 beta1 release, its assembly version should have been 2.0.12.91 and not 2.0.13.91. The former value indicates the assembly is approaching the 2.0.13 while the latter indicates the assembly is approaching 2.0.14 which is not the case.

We hope this won't happen again. :(



Comments

Unknown said…
Can download this by Nuget ?
This comment has been removed by the author.
I still need to update Nuget with this release. Sorry for that.
Any chance to this or next beta in NuGet soon? It has some very important fixes with transactions. Seems we have problems with them.
GLane said…
when u r going to release 2.0.13 stable release.... because when we try out beta version with visual studio 2012, end-up with errors...we cannot even see npgsql data provider inside providers list....This one is pretty urgent, so Please reply..... Thank you
Unknown said…
Nice work. Will give a try for sure!
Unknown said…
Can you point out to some sort of guide to get it ready to use?

I am trying to set it up for use with VS 2012 Express and found out that due Microsoft Licensing restrictions, no provider should be available for EF Design/Diagrams

I have downloaded the Professional/Premium/Ultimate Trial versions of VS 2013 and it not working in Full.

I do can connect to PostgreSQL and access data out there, but I get a lot of Exceptions about dbo schema not existing, absence of __MigrationHistory table and so on.

Since it don´t show as Data Provider for EF Models and Database connections, it will not generate the EF metadata info.

I am going to do a second try with VS2012.

What I did:

1. Downloaded Npgsql2.0.13.91-bin-ms-net4.5eE6.zip (beta)
2. Expanded it
3. Run gacutil -i Npgsql.dll
4. Run gacutil -l | findstr /i Npgsql to check it it was there
5. Created a new project and tried to add a new EF model, but PostgreSQL was not a option there
6. Registered it as an EF provider at , as an Factory Provider at and a Connection at in the app.config file
7. Using NuGet, installed Npgsql (and -Pre) and EntityFramework

I want to use it for Database First option.

What I am missing to get it working with diagrams, ef models, etc?

Popular posts from this blog

UUID datatype and COPY IN/OUT support added to cvs

Hi all! It was just added support to uuid datatype in cvs head. This type will be available in next Postgresql release 8.3. Thanks to David Bachmann for his patch! You can get more info about this patch in this mailing list post . Also was added support for copy in and copy out operations. Now, users can provide streams which can be copied directly to and from Postgresql tables! Thanks to Kalle Hallivuori for providing a patch! Thanks to Truviso for giving support to Kalle. More info about that including a demo and ready to use compiled Npgsql.dll versions can be found here . That's it! As soon as we get more features added, I will post info about them here. Stay tuned! :)

Npgsql Tips: Using " in (...)" queries with parameters list and "any" operator

Hi, all! We have received some users questions about how to send a list of values to be used in queries using the "in" operator. Something like: select foo, bar from table where foo in (blah1, blah2, blah3); Npgsql supports array-like parameter values and the first idea to have this working would try to use it directly: NpgsqlCommand command = new NpgsqlCommand("select * from tablee where field_serial in (:parameterlist)", conn); ArrayList l = new ArrayList(); l.Add(5); l.Add(6); command.Parameters.Add(new NpgsqlParameter("parameterlist", NpgsqlDbType.Array | NpgsqlDbType.Integer)); command.Parameters[0].Value = l.ToArray(); NpgsqlDataReader dr = command.ExecuteReader(); but unfortunately this won't work as expected. Npgsql will send a query like this: select * from tablee where field_serial in ((array[5,6])::int4[]) And Postgresql will complain with the followin

Stream seek error

Hi all! Since Npgsql RC1, we started to receive some error reports about problems when closing connections. The typical stack trace looked like this: System.NotSupportedException : This stream does not support seek operations. at System.Net.Sockets.NetworkStream.Seek(Int64 offset, SeekOrigin origin) at System.IO.BufferedStream.FlushRead() at System.IO.BufferedStream.WriteByte(Byte value) − at Npgsql.NpgsqlQuery.WriteToStream(Stream outputStream) in C:\Npgsql\Npgsql2\src\Npgsql\NpgsqlQuery.cs:line 62 − at Npgsql.NpgsqlReadyState.QueryEnum(NpgsqlConnector context, NpgsqlCommand command) in C:\Npgsql\Npgsql2\src\Npgsql\NpgsqlReadyState.cs:line 64 − at Npgsql.NpgsqlConnector.ReleasePlansPortals() in C:\Npgsql\Npgsql2\src\Npgsql\NpgsqlConnector.cs:line 373 − at Npgsql.NpgsqlConnectorPool.UngetPooledConnector(NpgsqlConnection Connection, NpgsqlConnector Connector) in C:\Npgsql\Npgsql2\src\Npgsql\NpgsqlConnectorPool.cs:line 541 − at Npgsql.NpgsqlConnectorPool.ReleasePooledConnector(NpgsqlConn