New Versions of dotConnect Data Providers Released!

April 29, 2009

dotConnects continue to move towards being the optimal ORM solutions available on the market. The new versions of dotConnect for Oracle, MySQL, PostgreSQL, and SQLite fill the last gaps in implementation of LINQ to SQL and Entity Framework support.

In LINQ to Oracle, LINQ to MySQL, and LINQ to PostgreSQL dotConnects introduce full support for stored procedures, user-defined functions, database management, and SqlMethods class.

dotConnect for PostgreSQL is enhanced with SSL connections and binary mode in PgSqlLoader. There are also new classes: PgSqlAlerter to handle LISTEN/NOTIFY commands, PgSqlArray to represent PostgreSQL ARRAY data type, and PgSqlLargeObject to support PostgreSQL large objects. PgSqlDump now can optionally include different database object types.

The functionality of dotConnect for MySQL was improved by adding new properties to the MySqlConnection class. The Charset property allows to avoid using the Unicode mode to reduce net traffic. The PingInterval property serves for connection maintaining, as ping command is sent to server to prevent closing connection unilaterally.

In Entity Framework support, Entity Developer 2.00 now fully replaces standard Microsoft tools and leaves them behind by offering a set of advanced features. Complex Type support, availability of all three types of inheritance, and Validation schema improvement make the tool ideal for working with models.

Entity Developer is much faster and more flexible than Visual Studio wizards and designers for Entity Framework and LINQ to SQL models. This is especially important for dotConnect for SQLite, where Entity Framework design time was not available at all due to Visual Studio limitations.

You are welcome to enjoy the world of efficient application development with the new dotConnects!

If you wish to provide feedback on the new versions, you can do it in our forums or with contact form. There is also feedback form in the support zone of every product. We are always glad to hear your comments and take into account your development needs.