问题描述
我有一个MVC-EF逆向工程code第一种模式,并且希望使用属性,包括另一个表。
I have an MVC-EF Reverse Engineer Code first model, and want to include another table using a property.
public virtual OtherTableModel OtherTableModel{ get; set; }
但是当我这样做,我得到的错误:
However when I do this, I get the error:
显然,如果有EDMX有一个简单的方法来做到这一点。在这种情况下,这两个表有相同的主键:
Apparently if there is an edmx there is an easy way to do this. In this case, both tables have the exact same primary key:
string id {get; set}
我怎样才能获得包括命令工作?
How can I get the include command to work?
在我的控制器code是:
In my controller the code is:
ourList = db.Table1.Include(t => t.OtherTableModel)
我得到的错误是:
The error I get is:
An exception of type 'System.InvalidOperationException' occurred in
EntityFramework.SqlServer.dll but was not handled in user code
Additional information: A specified Include path is not valid. The
EntityType Solution1.Models.User' does not declare a navigation property
with the name 'OtherTableModel'.
请注意:我研究这个错误,但没有我发现答案是朝反向工程code第一种方法为目标。
NOTE: I have researched this error but none of the answers I found is geared toward the reverse-engineer code first approach.
在此先感谢!
推荐答案
您需要配置在表1的关系。 EF可以判断的关系,如果你的名字[表] + ID:
You need to configure the relationship in Table1. EF can determine the relationship if you name it [table] + Id:
public string OtherTableId {get; set;}
public OtherTableModel OtherTableModel {get; set;}
也可以添加注释:
or you can add annotations:
[ForeignKey("Id")]
public OtherTableModel OtherTableModel {get; set;}
或者你可以使用流畅的API,我preFER:
or you could use the fluent API that I prefer:
public class Table1Configuration : EntityTypeConfiguration<Table1>
{
public Table1Configuration()
{
HasRequired(p => p.OtherTableModel)
.WithMany(p => p.Table1s)
.HasForeignKey(p => p.Id)
.WillCascadeOnDelete(false);
}
}
这篇关于MVC-EF逆向工程code首先包括另一个表的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!