codefoster

Here’s the scenario. You’re a developer and a you create a great set of objects and relationships between them that perfectly expresses the structure of your prospective application. You want to just tell your code to go ahead and create a new database (or map to an existing one) that matches your model and allows you to store the data?

So you do this with EFCF and all is well. Except that occasionally you tweak your model and run into a mapping error and all is not well. EF has a hard time communicating to you what exactly is wrong and can give some pretty obscure exception messages, and you can spend a lot of time (personal experience) tracking down what you’ve done wrong.

The error I just ran into is this one: “Type Address_Country is not defined in namespace PEP.CIM.Entities.Mapping (Alias=Self).” Huh? I know that I just tried to create a Country navigation property on my Address entity so I have a general idea of where my error might be, but after a double check of my code I can’t see how it’s any different from my other relationships that are working fine. So what’s the problem?

I stumbled upon a great way to troubleshoot these kinds of issues, though… the Entity Framework Power Tools (at CTP1 as I type). I have used this tool countless times to reverse engineer a database into good-lookin’ C# code, but today I used it for something else. When the tool is installed (and you have EF referenced in your project!), you can right click on your context and get a few options under the Entity Framework menu item.

In my case, I was able to use View Entity Data Model XML and then look through the resulting XML for the Address_Country relationship. I fairly quickly discovered that I had NavigationProperty elements for my Address_Country but I didn’t have a coresponding Association (as I did for my working relationships). This lead me back to my fluent mapping statement…

HasRequired(t => t.Country).WithMany(t => t.AddressesByAdrCountryCdvId).HasForeignKey(t => t.AdrStateProvinceCdvId); HasRequired(t => t.State).WithMany(t => t.AddressesByAdrCountryCdvId).HasForeignKey(t => t.AdrStateProvinceCdvId);

where I discovered that I had made a grievous copy paste error. As you can see, I’m attempting to add mappings for Country and State, but it’s all wrong. Each is mapping AddressesByAdrCountryCdvId and AdrStateProvinceCdvId. Here’s the way it should look…

HasRequired(t => t.Country).WithMany(t => t.AddressesByAdrCountryCdvId).HasForeignKey(t => t.AdrCountryCdvId); HasRequired(t => t.State).WithMany(t => t.AddressesByStateProvinceCdvId).HasForeignKey(t => t.AdrStateProvinceCdvId);

Now that’s better! Now not only does my build succeed, but my unit tests all pass as well.

It also may help to use the same technique to View Entity Data Model DDL SQL and see what SQL would be generated to create your tables and constraints.

I hope this helps you find mapping issues in your code first projects. Happy coding.