public int IglinkId { get; set; } // iglink_id (Primary key) public int IGroupNo { get; set; } // i_group_no. FK to i_group public string Department { get; set; } // department (length: 10). FK to items public string Category { get; set; } // category (length: 10) public string Item { get; set; } // item (length: 10) // Foreign keys public virtual IGroup IGroup { get; set; } // FK_i_glink_i_group public virtual Items Items { get; set; } // FK_i_glink_itemsThis is ItemsList class:
public string Department { get; set; } // Department (length: 10) public string Category { get; set; } // Category (length: 10) public string Item { get; set; } // Item (length: 10) public int DepartmeId { get; set; } // DepartmeId public int CategoryId { get; set; } // CategoryId public int ItemId { get; set; } // ItemId public string Descrip { get; set; } // Descrip (length: 135) public bool Hidden { get; set; } // HiddenSo, I am only interested of using ItemId, Category, Department, Item properties.