News, examples, tips, ideas and plans.
Thoughts around ORM, .NET and SQL databases.

Wednesday, April 13, 2011

DataObjects.Net 4.5 Alpha 1

We are pleased to announce the availability of DataObjects.Net 4.5 Alpha 1. This build includes all the fixes that are made to stable 4.4 version as well as two brand new data providers: Firebird 2.x & MySql 5.x, thanks to Csaba Beer & Malisa Ncube (thunderous applause here!).

As it is alpha, there are some limitations, such as:
- Upgrade doesn't work yet in most scenarios for both Firebird & MySql. Hence, use 'Recreate' to update the database schema.

Examples of ConnectionUrls/ConnectionStrings for these 2 providers are like the following:

// MySql
var connectionUrl = @"mysql://user:password@myserver:3306/database";

// Firebird
var provider = "firebird";
var connectionString = @"User=user;Password=password;Database=C:\Program Files\Firebird\Firebird_2_5\database.fdb;DataSource=myserver; Port=3050;Dialect=3; Charset=NONE;Role=;Connection lifetime=15;Pooling=true; MinPoolSize=0;MaxPoolSize=50;Packet Size=8192;ServerType=0;";
// or
var connectionUrl = @"firebird://user:password@myserver/C:\Program Files\Firebird\Firebird_2_5\database.fdb?Port=3050&Dialect=3&Charset=NONE&Role=&Connection lifetime=15&Pooling=true&MinPoolSize=0&MaxPoolSize=50&Packet Size=8192&ServerType=0";

The binaries are available at the corresponding section of Downloads page.

Feedback of any kind is highly appreciated.

Note: this is alpha version, it is not intended to be used in production.