如何在数据库中存储数据表?

或List<KeyValuePair<int,Object>>或字典.

根据Entity Framework和PostgreSQL数据库，我们试图对一部分数据建模，该数据基本上由对名为OtherObject的具有ID的对象的引用列表组成.我们尝试存储的数据是一个MyObject，由一个Id以及两个列表(最大长度为12)组成，该列表包含一个或多个对OtherObject的引用和OtherObject的数量.因此，我们要存储与此相关的数据(例如在单独的表和列中)

Depending on Entity Framework and PostgreSQL database we are trying to model a part of data which basically consists of a list of references to an object called OtherObject which has an ID. The data we try to store is a MyObject and consists of an Id, and two lists (with a maximum length of 12) of one or more references to the OtherObject and the amount of OtherObjects. So we want to store data (in for example a separate table and columns) which correlates to this:

FirstPattern:
OtherObject with ID 1, 10 times
OtherObject with ID 4, 12 times

SecondPattern:
OtherObject with ID 2, 2 times
OtherObject with ID 3, 4 times
OtherObject with ID 4, 11 times

为此，我们认为KeyValuePair中的ICollection是合适的.这样，我们就有了一个列表，其中包含每个键(OtherObject)的值(金额).

To do this we thought an ICollection of KeyValuePairs would be appropriate. That way we have a list that has a value (an amount) for each Key (the OtherObject).

该模型现在基本上如下所示:

The model now basically looks as follows:

public class MyObject
{
    public int Id { get; set; }
    public IDictionary<OtherObject, int> FirstPattern { get; set; }
    public IDictionary<OtherObject, int> SecondPattern { get; set; }
}

如何将KeyValuePair个ICollection的这个ICollection存储在数据库中?
有(更好的)方法吗?

How can we possible store this ICollection of KeyValuePairs in the database?
Is there a (better) way?