Npgsql Adds Support For Visual Studio Data Designer
Written by Kay Ewbank   
Tuesday, 09 September 2014

The latest release of Npgsql also adds improvements for Entity Framework and support for Postgre 9.4’s JSONB data type.

Npgsql is a .Net Data Provider for Postgresql that you can use from any program developed for the .Net framework to access the Postrgre database server.

Npgsql 2.2.0 overcomes a major drawback of the earlier version, which you couldn’t make accessible from Visual Studio because it didn’t support DDEX. There’s a tutorial on Github showing the steps you need to use Npgsql with DDEX. The developers are working on an EXE installer for Npgsql, which will provide an easier route.

Another improvement in the new version is support for the JSONB data type. This was introduced in Postgresql 9.4, and improves the way Postrgre handles data in JSON format. When PostgreSQL added support for ‘standard’ JSON, it meant the relational database could deal with data that would otherwise be handled by NoSQL systems. JSONB stores such data in a binary format, giving a better performance and features such as indexing. It is seen as the future for JSON data. The current version of Npgsql also supports JSON and HStore data types, so you can work with all three in .NET applications.

Support for Entity Framework 6 features is also included in this release. Support for EFMigration and database creation has been added, and the new version of Npgsql now lets you create Code First projects without having to first create a database. The way relational expressions, column references, and column name aliasing are handled have been fixed so that queries no longer fail. Handling of joins has also been improved so that if a name clash occurs, Npgsql now creates an alias.

Date functions are another area that has improved, with correctly functioning DateDiff functions. Operator precedence has also been made to work correctly for postfix, prefix and binary.

Support for GSSAPI on Windows has been added, so it’s easier to use Active Directory when authenticating users, and the final major improvement is full SSLStream support.

npgsqlsq

More Information

Npgsql

Npgsql on Open Hub

Related Articles

PostgreSQL 9.3 Released

RAD Studio XE6

 

 

To be informed about new articles on I Programmer, install the I Programmer Toolbar, subscribe to the RSS feed, follow us on, Twitter, Facebook, Google+ or Linkedin,  or sign up for our weekly newsletter.

Banner


Google Adds Multiple Database Support To Firestore
04/03/2024

Google has announced the general availability of Firestore Multiple Databases, which can be used to manage multiple Firestore databases within a single Google Cloud project.



Crazy Clocks
10/03/2024

It's that time again when the clocks change and  time is of the essence and I indulge my interest in crazy clocks. I am always surprised that there are still new ideas for how to display the time [ ... ]


More News

raspberry pi books

 

Comments




or email your comment to: comments@i-programmer.info

Last Updated ( Tuesday, 09 September 2014 )