给定这两个EF模型,我该如何使用LINQ选择所有在InteractionSegmentDetail中存在但不在Custom_SegmentsParsed中存在的记录?使用InteractionIDKey字段作为比较器。
public partial class Custom_SegmentsParsed
{
public string InteractionIDKey { get; set; }
public string SegmentNum { get; set; }
public System.DateTime ServerTs { get; set; }
public System.DateTime CUTC { get; set; }
public Nullable<int> Duration { get; set; }
public string LocalParty { get; set; }
public string Queue { get; set; }
public string EndCode { get; set; }
public string Details { get; set; }
}
public partial class InteractionSegmentDetail
{
public string InteractionIDKey { get; set; }
public short SiteID { get; set; }
public byte SeqNo { get; set; }
public System.DateTime StartDateTimeUTC { get; set; }
public int StartDTOffset { get; set; }
public string ConversationID { get; set; }
public string SegmentLog { get; set; }
}