Skip to main content

Npgsql 2.0.5 released!

Hi, all!

Npgsql Development Team released Npgsql 2.0.5.

This is a bug fix release. And we fixed some important bugs.

The first one is about the famous NotSupportedException seek operation. Npgsql now handles this by flushing the stream before writing to it. It is not the complete solution but it is an step in the right direction.

Another bug which is open for quite some time is the return value of DataAdapter.Update. It wasn't working very well for multiple statements. Now it is working ok.

Josh Cooley added a lot of fixes for Entity Framework and Transactions support.

Please, check our release notes to see all the changes on this release.

You can download this release on our usual location.

Thanks everybody who helped us with comments, feedback and patches.

Comments

Anonymous said…
Well, nice article buddy… Someone will love to read this infor if I tell her about this. She’s really interested in this subject. Thanks again… Please come visit my site St. Paul Business Directory when you got time.
Anonymous said…
Wow, loving the two photos you posted. You got potential. Please come visit my site Wichita Business Directory when you got time.
I really liked your blog! You have some great content. Please come visit my site Junk and Rubbish when you got time.
Thanks for posting, definitely going to subscribe! See you on my reader. Please come visit my site Commercial Gym Equipment and give me any valuable feedbacks.
There is obviously a lot more than this. Would you mind telling me how long it took you to gather your content? Please come visit my site San Jose Business Directory when you got time.
This article was extremely interesting, especially since I was searching for thoughts on this subject last Thursday. Please come visit my site Detroit Business Directory and give me any valuable feedbacks.
Thanks for posting, definitely going to subscribe! See you on my reader. Please come visit my site Indianapolis Business Directory wand give me any valuable feedbacks.
Anonymous said…
I enjoyed reading your work! GREAT post! I looked around for this… but I found you! Anyway, would you mind if I threw up a backlink from my site?
Please come visit my site Cincinnati Yellow Page Business Directory when you got time. Thanks.
Anonymous said…
I usually don’t leave comments!!! Trust me! But I liked your blog…especially this post! Would you mind terribly if I put up a backlink from my site to your site? Please come visit my site Toledo Yellow Page Business Directory when you got time. Thanks.
Wow! Thank you! I always wanted to write in my site something like that. Can I take part of your post to my blog?
Please come visit my site contact management
when you got time.
Thanks.
You got a really useful blog I have been here reading for about an hour. I am a newbee and your success is very much an inspiration for me. Please come visit my site dam digital asset
give me any valuable feedbacks.
Thanks.
rr8004 said…
Yeah it is a great and nice article looking forward to have such article it is so useful. Please come visit my site Nova Scotia facts when you got time.
Very nice information. Thanks for this. I would love some feedback on my site Shandong China when you got time.
I found your blog on google and read a few of your other posts. I just added you to my Google News Reader. Keep up the good work. Look forward to reading more from you in the future. Feel free to check out my site Sichuan China travel Expat when you got time.
stroke symptoms said…
Hello mate, I want to thank you for this nice blog. Would you mind telling me some secrets for a succesful blog ? Which could attract some visitors than it normally does. Please come visit my site symptoms of stroke when you got time.
scalp psoriasis said…
What a facinating article. I’m looking for a marketing expert to help with a project, could you help? Please visit my site psoriasis treatment when you got time.
rr8004 said…
It is very interesting article and quite impressive and more informative and looking forward to read such article. Please come visit my site Tucson Yellow Page Business Directory when you got time.
rr8004 said…
. Since I’m new to blogging, these articles are greatly appreciated; very useful and informative blog and every body must visit this blog. Please come visit my site Mesa Business Directory when you got time
rr8004 said…
This is just another reason why I like your website. I like your style of writing you tell your stories without out sending us to 5 other sites to complete the story. Please come visit my site Detroit Yellow Page Business Directory when you got time.
rr8004 said…
This is just another reason why I like your website. I like your style of writing you tell your stories without out sending us to 5 other sites to complete the story. Please come visit my site Detroit Yellow Page Business Directory when you got time.
rr8004 said…
I can see that you are an expert at your field! I am launching a website soon, and your information will be very useful for me. Thanks for all your help and wishing you all the success in your business. Please come visit my site Jacksonville Business Directory when you got time.
Anonymous said…
Hey congrats on the new posting come out
btw i love your blog although i have just stumbled upon it =)
Love the new pictures you got there! Please come visit my site Local Business Directory Of Seattle U.S.A. when you got time.
Anonymous said…
always kept talking about this. I will forward this article to him. Pretty sure he will have a good read. Thanks for sharing! Please come visit my site Arlington Business Directory when you got time.
Anonymous said…
Excellent article , i just share it with my friend of Italy. I Stumble UP your blog post , you will notice an increase of traffic within 24 hours for targeted people. Cheers . Please come visit my site Corpus Christi Business Directory when you got time.
Anonymous said…
Thanks for posting, definitely going to subscribe! See you on my reader. Please come visit my site Local Business Directory Of Pennsylvania when you got time.
Anonymous said…
Thanks for posting, definitely going to subscribe! See you on my reader. Please come visit my site Vermont Business Listing Yellow pages when you got time.
tile ceramic said…
Yeah it is a great and nice article looking forward to have such article it is so useful. Please come visit my site home improvement give me any valuable feedbacks.
algebra tutor said…
It is very interesting article and quite impressive and more informative and looking forward to read such article. Please come visit my site jobs when you got time.
Anonymous said…
Wow! Thank you! I always wanted to write in my site something like that. Can I take part of your post to my blog? Please come visit my site Phone Directory Of Boston City Massachusetts MA State when you got time.
Anonymous said…
Wow! Thank you! I always wanted to write in my site something like that. Can I take part of your post to my blog? Please come visit my site Business Directory Boston when you got time.
Anonymous said…
This is just another reason why I like your website. I like your style of writing you tell your stories without out sending us to 5 other sites to complete the story. Please come visit my site San Jose Phone Numbers when you got time.
Anonymous said…
This is just another reason why I like your website. I like your style of writing you tell your stories without out sending us to 5 other sites to complete the story. Please come visit my site San Jose Business Search when you got time.
rr8004 said…
You may have not intended to do so, but I think you have managed to express the state of mind that a lot of people are in. The sense of wanting to help, but not knowing how or where, is something a lot of us are going through. Please come visit my site San Diego City Business Search Engine when you got time.
Unknown said…
Since I’m new to blogging, these articles are greatly appreciated; very useful and informative blog and every body must visit this blog. Please come visit my site Business Forum give me any valuable feedbacks.
Unknown said…
I really liked your blog! You have some great content. Check out my blog and give me some feedback Please come visit my site Fashion Directory when you got time.
Anonymous said…
Garden Soil, soil testing, orgnic soil, plant soil basics and techniques online guide.soil technique
Anonymous said…
I found your blog on google and read a few of your other posts. I just added you to my Google News Reader. Keep up the good work. Look forward to reading more from you in the future. Please come visit my site Milwaukee City Business Listings when you got time.
rr8004 said…
I really liked your post on home financing! if you have more information elsewhere let me know. Please come visit my site Fortworth Business Phone Listing when you got time.
rr8004 said…
I really liked your post on home financing! if you have more information elsewhere let me know. Please come visit my site Business Yellow Pages Fortworth when you got time.
rr8004 said…
She’s really interested in this subject. Thanks again… Please come visit my site Arlington Business Search Engine when you got time.
rr8004 said…
She’s really interested in this subject. Thanks again… Please come visit my site Business Reviews Of Corpus Christi City when you got time.

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