Edit Question - KnowledgeHub

Title Body

I want to store an object that contains a List of primitives using EF. public class MyObject { public int Id {get;set;} public virtual IList<int> Numbers {get;set;} } I know that EF cannot store this, but I'd like to know possible solutions to solve this problem. The 2 Solutions I can think of are: 1. Create a Dummy object that has an Id and the Integervalue, e.g. public class MyObject { public int Id {get;set;} public virtual IList<MyInt> Numbers {get;set;} } public class MyInt { public int Id {get;set;} public int Number {get;set;} } 2. Store the list values as a blob , e.g. public class MyObject { public int Id {get;set;} /// use NumbersValue to persist/load the list values public string NumbersValue {get;set;} [NotMapped] public virtual IList<int> Numbers { get { return NumbersValue.split(','); } set { NumbersValue = value.ToArray().Join(","); } } } The Problem with the 2. approach is, that I have to create a Custom IList implementation to keep track if someone modifies the returned collection. Is there a better solution for this ?

Tags (comma-separated) Cancel