• 0

entity framework 4.1 two tables with the same property name


Question

i'm having some problems with entity framework and a sql database. so my problem is this: in my database there are two tables that have the same property, they are identical in type and length but they are not related in any way. no foreign key whatsoever. as soon as i start to interact with the database entity framework spits out the famous error:

error 0019: Each property name in a type must be unique. Property name was already defined.

i'm using the code first approach and a sql server 2008 by the way.

this is one of the class representations of the tables:


[Table("bo")]
public class TbPBO
{
[Required(AllowEmptyStrings = false, ErrorMessage = "O campo de nome nao pode ser nulo")]
[MaxLength(55, ErrorMessage = "O campo de nome nao pode ter mais que 55 caracteres")]
[Column("nome", TypeName = "char", Order = 4)]
public string TbBonome { get; set; }
}[/CODE]

this is the other class representation of the table:

[CODE]
[Table("bi")]
public class TbPBi
{
[Required(AllowEmptyStrings = false, ErrorMessage = "O campo nome nao pode ser nulo")]
[MaxLength(55, ErrorMessage = "O campo nome nao pode ter mais que 55 caracteres")]
[Column("nome", TypeName = "char", Order = 62)]
public string TbBinome { get; set; }
}
[/CODE]

any idea on how to work around this? one more thing. the database must not be changed in any way. i cannot modify it.

help would be appreciated. thanks in advance

Link to comment
Share on other sites

3 answers to this question

Recommended Posts

  • 0

i've solved the problem by installing ef power tools and reverse engineer my database. it created the entities and context. i've been testing the code and it works. no more problems.

thanks for the help

Link to comment
Share on other sites

This topic is now closed to further replies.