Monthly Archives: August 2008

Provider for Entity Framework for Firebird is back and ready for SP1 final

The final version of SP1 for VS2008 and .NET 3.5 is out for a while. And you may noticed, that there were some changes between SP1 beta and SP1 final. These changes are happily not huge as between EF Beta 3 and SP1 Beta 1.

So if you want to test new version of FirebirdClient working with SP1 check the weekly builds.

Store (server) generated values in Entity Framework in Firebird

You know, server generated values – not only autoincrements are very useful think. Entity Framework supports two types “Computed” and “Identity”. When you update or insert entity, these fields are automatically refreshed according to state in database (after calling SaveChanges). For more info look at StoreGeneratedPattern.

In Firebird, there’s no identity or autoincrement. Firebird uses generators (sequences) and triggers, but this isn’t problem. When you provide some value, it will be rewritten. Anyway, computed fields are supported and you can use it. When you generate model from DB, fields are correctly marked in SSDL and when inserting or updating entity, these fields are refreshed. I’ve finished “refreshing” implementation today, so feel free to test weekly builds.