Nhibernate, Need help building an entity class

advertisements

I have 3 tables, they are very simple. User, Post, Favorite.

            User Table:
            Id: int
            Name: string
            --------------------------------

            Post Table:
            Id: int
            Title: string
            UserId: int  (this is the FK)
            --------------------------------

            Favorite Table:
            UserId: int
            PostId: int
            --------------------------------

I create 2 class files for User and Post tables. Dont know how to add Favorite table there, Favorite table allows User to bookmark their favorite posts.

            public class User : Entity
            {
                public User() { this.Posts = new List<Post>;}
                public virtual string Name { get; set; }
                public virtual IList<Post> Posts {get; set;}
            }

            public class Post : Entity
            {
                public Post() {}
                public virtual string Title { get; set; }
                public virtual User User { get; set; }
            }


You have a many to many relation. The Favorite Table is the relation table between User and Post.

public class Favorite : Entity
{
    public virtual Post Post { get; set; }
    public virtual User User { get; set; }
}