The mapping of CLR type to EDM type is ambiguous

Shashangka Shekhar

Schema specified is not valid. Errors:

The mapping of CLR type to EDM type is ambiguous because multiple CLR types match the EDM type 'CmnAddressCity'.

Is there any solution?

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Felipe Batista Suardi8y ago
Just add the EntityFramework as "Code First from database" and not as "EF Designer from database". This resolved my problem, but it has a dark side, if you change your database you have to remove all the classes and add it again, or just edit the classes, I use the last when I change properties of the columns, like "Allows null" or the size of a string. But if you add columns I recomend remove and add again the classes.
Dorababu Meka10y ago
Check the answer herehttp://stackoverflow.com/a/14943989/388388
Shashangka Shekhar10y ago
Here the both class with diferent .edmx:

namespace Model.Tools
{
   using System;
   using System.Collections.Generic;

   public partial class Customer
   {
      public int Id { get; set; }
      public string CustName { get; set; }
      public string CustEmail { get; set; }
      public Nullable TypeID { get; set; }
   }
}
namespace Model.Sales
{
   using System;
   using System.Collections.Generic;

   public partial class Customer
   {
      public int Id { get; set; }
      public string CustName { get; set; }
      public string CustEmail { get; set; }
      public Nullable TypeID { get; set; }
     }
}
Dorababu Meka10y ago
Do you have the same entity in different classes?