Edit Question - KnowledgeHub

Title Body

Here's my situation: I have been working on an ASP.NET MVC 3 application for a while. It has a database (built out of a db project; I'm going db-first) for which I have an edmx model and then a set of POCOs. My entities have plural names in the database and POCOs have singular names. Everything maps nicely without a problem. Or used to until I added a new table (called TransactionStatuses). Now all of the old entities still work but the new one does not. When I try to eagerly load it together with a related entity: var transactions = (from t in db.Transactions.Include(s => s.TransactionStatus) //TransactionStatus - navigation property in Transactions to TransactionStatuses where t.CustomerID == CustomerID select t).ToList(); I get Invalid object name 'dbo.TransactionStatus'. I even did a simpler test: List<TransactionStatus> statuses = db.TransactionStatuses.ToList(); = same result. I have updated (and even re-created) edmx from the db and have gone through it back and forth trying to figure out what is different about the mapping for dbo.TransactionStatus* es * which trips the whole thing up. If somebody can point me in the direction of a fix it'd be wonderful. P.S. Turning off pluralisation is not an option, thanks. Update : I figured it out - my answer below.

Tags (comma-separated) Cancel