Entity Framework and the "Undefined column mapping" Exception

I've recently run across an exception that occurs while trying to update Entity Framework data models from their respective databases. The exception message is "Unable to generate the model because of the following exception: 'An error occurred while executing the command definition. See the inner exception for details. Undefined column mapping."

I searched online and couldn't find any mention of this exception. This surprised me, considering the frequency with which I've been encountering it. I thought that perhaps it had something to do with the DbContext I'm using with Entity Framework 4.1 to create persistence ignorant POCO (plain old CLR object) classes. I tried a few things to alleviate the issue, but to no avail.

As of now, the only solution I have to this problem is merely a workaround: delete all of the entities from the model and re-add them. I hope to eventually find a good solution to this problem, but with limited time and no other leads to go by, this is the best I could come up with for now. I hope it helps someone out. I know it's not an ideal solution (especially if you've got a lot of entities in your data model) but for now, this is the best I could come up with. If anyone else has a better workaround or a solution, please share it.


Popular Posts

How To Mock Out Child Components In Unit Tests of Angular 2 Code

A Generic Method Using HttpClient to Make a Synchronous Get Request

The Cause and Solution for the "System.Runtime.Serialization.InvalidDataContractException: Type 'System.Threading.Tasks.Task`1[YourTypeHere]' cannot be serialized." Exception

Unit Testing with a Mock Entity Framework DbContext and Fake DbSets

A Red Herring When Using Moq to Mock Methods With Optional Parameters