How would I map something like this using the modelBuilder? Where theres a nullable foreign key referencing the same tables primary key
Table: Task
taskID int pk
taskName varchar
parentTaskID int (nullable) FK
Task class:
public class Task
{
public int taskID {get;set;}
public string taskName {get;set;}
public int parentTaskID {get;set;}
public Task parentTask {get;set;}
}
...
modelBuilder.Entity<Task>()
.HasOptional(o => o.ParentTask)....
The following code gives you the desired schema. Note that you also need to define
ParentTaskID
foreign key as a nullable integer, like I did below.