Let's say I have a player class (model). I can save the player class easily with SQL and LINQ with just an ID and a text member that maps right to the table. (I can specify the [PrimaryKey, AutoIncrement] attributes, etc).
Let's say I have a playerChallenge class - where for each challenge, there are a list of obstacles. I guess the best thing is to have a row with challengeID, obstacleID, for each obstacle in that challenge (repeating challengeIDs).
My question is, how do I create the model for this class so that it's best used with LINQ? Normally I'd write a model that contains 2 members - an ID and a List<int> for obstacleIDs. But it seems like I'm doing something wrong because I won't get clean support for filling up that list without doing it manually (which is fine - just wondering if there's a cleaner way)...