Linq to SQL的多对多关系，使用集合

我有一个移动应用程序，我试图利用windows手机数据库。但是我遇到了一个小问题。

这是我到目前为止写的。

[Table]
public class CollectionManager
{
    [Column(IsPrimaryKey = true)]
    public int FilmID { get; set; }
    [Column(IsPrimaryKey = true)]
    public int CollectionID { get; set; }
    private EntityRef<FilmData> film;
    [Association(ThisKey = "FilmID", OtherKey = "ID", Storage = "film")]
    public FilmData Film{ get { return film.Entity; } set { film.Entity = value; } }
    private EntityRef<Collection> collection;
    [Association(ThisKey = "CollectionID", OtherKey = "ID", Storage = "collection")]
    public Collection Collection { get { return collection.Entity; } set { collection.Entity = value; } }
}

[Table]
public class FilmData
{
    [Column(IsPrimaryKey = true)]
    public int FilmID { get; set; }
    [Association(ThisKey = "ID", OtherKey = "FilmID")]
    public EntitySet<CollectionManager> CollectionManager { get; set; }
}

[Table]
public class Collection
{
    [Column(IsPrimaryKey = true)]
    public int CollectionID { get; set; }
    [Association(ThisKey = "ID", OtherKey = "CollectionID ")]
    public EntitySet<CollectionManager> CollectionManager { get; set; }
}

这是我的3张表，但是我正在努力

• 添加影片到集合
• 获取一个集合中的所有影片。

任何帮助我将非常感激，非常感谢你花时间阅读这篇文章!