by Jiří {x2} Činčura

You are reading

Ultimate EFv4 CTP4 Code First (full mapping) example (using Firebird)

There's a lot of content for latest CTP, CTP4, for Entity Framework "new features". It's mainly focused on Code First stuff, that fills the triad with Database First and Model First. I like Code First but what I also like is maintainable code. Hence I was more trying not to use convention-over-configuration, in opinion good for only small projects, and focus on specifying everything the way I want it to be, especially with my database structure (yes, I'm data consistency and storage freak).

Let's model some kind of simple library and try to use there couple of Entity Framework's features. And to make things worse, try to do it with ADO.NET provider for Firebird.

Good news is I succeeded. My database structure was my first and non-touchable object (to be honest the first was the idea what to create and how to represent it in database) together with the idea of objects.

So it's time to create mapping right? Nope. Now I'll switch my brain from ER thinking into OO thinking mode. Here's the world of entities (sure I made some adjustments to fit some Entity Framework features, like Complex Types):

So far we haven't touched any Entity Framework related stuff. So it's time to create our context and all DAL related stuff. Mine is very simple and exposes only few properties and methods, just to keep it simple and focus on the aim.

You may also notice, I've created object which implements IDatabaseInitializer. That's because, by default, Entity Framework will try to create database for you and check whether your database matches model (CreateDatabaseOnlyIfNotExists). I'm controlling my database. You have to add somewhere into your application before doing anything with the context call to SetInitializer:

And finally we're ready to dive into the mapping. Again, you can type the mapping directly into overridden OnModelCreating, useful if you have only couple of diversions from default conventions. I created configuration classes where I specified as much as I want. And I need (almost) everything to be nailed down (remember, data consistency and storage freak ;)) as I don't want to be surprised when something in database or in entities changes and application will start behave weird.

I don't know whether it's worth to describe the lines. Should be understandable if you know how the entities and database look like. Just maybe small notice. Besides Complex Types we used two most common inheritance mapping scenarions - TPH aka Table Per Hierarchy for Books and TPT aka Table Per Type for Authors (there's also TPC (Table Per Concrete Type)). However if you have questions feel free to use comments, if I'll know answer I'll be happy to reply.

I'm glad I was able to figure out how to map everything without touching database structure (although it's pretty straightforward) or letting the default rules to kick in. Hope it will help you if you struggle with something (and hope the naming will not change much in future). It's also nice to see the whole infrastructure fits together and changing provider, in my case for Firebird's, doesn't make the code to blow out.