雇员
public class Employee
{
public int id { get; set; }
public String guid { get; set; }
public String name { get; set; }
public DateTime dt_hired { get; set; } public virtual Employee Leader { get; set; }
public virtual ICollection<Employee> Staff { get; set; }
}
层级关系表CREATE TABLE `e2e` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`e0` VARCHAR(50) NOT NULL COMMENT '上级guid',
`e1` VARCHAR(50) NOT NULL COMMENT '下级guid',
`dt_assigned` DATETIME NOT NULL,
PRIMARY KEY (`id`)
)这个如何用Fluent API描述呢?
public class Employee
{
public int id { get; set; }
public String guid { get; set; }
public String name { get; set; }
public DateTime dt_hired { get; set; } public virtual Employee Leader { get; set; }
public virtual ICollection<Employee> Staff { get; set; }
}
层级关系表CREATE TABLE `e2e` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`e0` VARCHAR(50) NOT NULL COMMENT '上级guid',
`e1` VARCHAR(50) NOT NULL COMMENT '下级guid',
`dt_assigned` DATETIME NOT NULL,
PRIMARY KEY (`id`)
)这个如何用Fluent API描述呢?
public class Employee
{
public int id { get; set; }
public int ParentId { get; set; }
public String guid { get; set; }
public String name { get; set; }
public DateTime dt_hired { get; set; }
public String duties { get; set; }
[ForeignKey("ParentId")]
public virtual Employee Leader { get; set; }
public virtual ICollection<Employee> Staff { get; set; }
}