{
[Key]
public int CabinetId { get; set; }
[Display(Name = "机柜")]
public string name { get; set; }
public virtual ICollection<Device> Devices { get; set; }
}
public class Device
{
[Key]
public int DeviceId { get; set; }
/// <summary>
/// UMG508-2200-7032
/// </summary>
public string name { get; set; }
/// <summary>
/// Id
/// </summary>
public int id { get; set; }
/// <summary>
/// JanitzaUMG508
/// </summary>
public string type { get; set; }
/// <summary>
/// Janitza electronics GmbH,UMG508
/// </summary>
public string description { get; set; }
/// <summary>
/// ModbusTCP:192.168.1.170|502|5000|1|TCP|ModTCP|3
/// </summary>
public string connectionString { get; set; }
/// <summary>
/// 2200-0027
/// </summary>
public string serialNr { get; set; }
[Display(Name = "DeviceDetail")]
public string More { get; set; }
[Display(Name = "监测场所")]
public string ViewSapce { get; set; }
public string ValuesJson { get; set; }
[Required(AllowEmptyStrings = true)]
public int ProjectId { get; set; }
[Required(AllowEmptyStrings = true)]
public int CabinetId { get; set; }
public virtual Project Project { get; set; }
public virtual Cabinet Cabinet { get; set; }
public virtual ICollection<MonitorSite> MonitorSites { get; set; }
}
这样cabinet与device之间有外键约束,为了不在加device时出现外键约束造成的冲突,在SQL中对外键约束进行修改:
强制外键约束:否;强制外键复制:否