在ASP.NET中存储带有EF的字符串集合

很难缠,没用,但很准确。这是一个典型的m:m场景。

public class Topic {
    public int TopicId { get; set; }
    // other topic stuff
    public virtual User Owner { get; set; }
    public virtual ICollection<Collaboration> Collaborators { get; set; }
}

public class User {
    public int UserId { get; set; }
    // other user stuff
    public virtual ICollection<Collaboration> Collaborators { get; set; }
}

public class Collaboration {
    public int CollaborationId { get; set; }
    // other stuff dependent on topic + user
    public int UserId { get; set; }
    public virtual User User { get; set; }
    public int TopicId { get; set; }
    public virtual Topic Topic { get; set; }
}

db.Topics.Include("Collaborators").Include("Collaboration.User").FirstOrDefault(p => p.TopicId == <key value>);

用户可以编辑的所有主题

db.Users.Include("Collaborators").Include("Collaboration.Topic").FirstOrDefault(p => p.UserId == <key value>);