1个实体2表与DbContext生成器？ [英] 1 Entity 2 Tables with DbContext Generator?

问题描述

您可以使用de ADO.NET DBContext Generator创建一个使用2个表的实体吗？

 

i拥有my_aspnet_membership和my tabler usuarios，

my_aspnet_membership（userId，email）; usuarios（usuarioID，Nome）

我用1到0..1 relationshionp链接。 my_aspnet_membership.userId - > Usuario.UsuarioID

我想创建一个带有属性"email"的usuarios实体映射到表my_aspnet_membership的列。

我试图映射但我收到错误

错误    1   错误3033：从第667行开始映射片段时出现问题：EntitySets'Usuarios'和'my_aspnet_membership'都映射到表'my_aspnet_membership'。他们的主键可能会发生碰撞。



我该怎么做才能解决这个问题？

 

解决方案

我认为您正在创建两个表的主键之间的关系。将Usuario.UsuarioID定义为外键，将my_aspnet_membership.userId定义为主键并创建关系。

Hi is it possible to create a entity using 2 tables using de ADO.NET DBContext Generator ?

 

i have the my_aspnet_membership and my tabler usuarios,

my_aspnet_membership (userId,email) ; usuarios (usuarioID, Nome)

i linked using 1 to 0..1 relationshionp. my_aspnet_membership.userId -> Usuario.UsuarioID

i want to create usuarios entity with a property "email" mapped to the column of the table my_aspnet_membership.

i tried to map but i get the error

Error    1    Error 3033: Problem in mapping fragments starting at line 667:EntitySets 'Usuarios' and 'my_aspnet_membership' are both mapped to table 'my_aspnet_membership'. Their primary keys may collide.

what can i do to fix this?

 

解决方案

I think you are creating relationship between primary keys of two table.Define Usuario.UsuarioID as foreign key and my_aspnet_membership.userId as your primary key and create relationship.

这篇关于1个实体2表与DbContext生成器？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！