How Would I Map This Using Fluent Api

Question

0.00/5 (No votes)

See more:

Hi guys im battling to to map this using fluent api

this is the movies.cs

C#

[Key]
        [Column]
        public int MovieID { get; set; }
        [Column]
        public string Title { get; set; }
        [Column]
        public string Storyline { get; set; }
        [Column]
        public string Year { get; set; }
        [Column]
        public string Runtime { get; set; }
        [Column]
        public DateTime ReleaseDate { get; set; }
        [Column]
        public DateTime DateTimeAdded { get; set; }
        [Column]
        public DateTime? DateTimeEdited { get; set; }

public virtual ICollection<MovieProducers> MovieProducers { get; set; }

The MovieProducers must be maped like this

C#

public int MovieProducerID { get; set; }
        public int MovieID { get; set; }
        public int PersonID { get; set; }

        public virtual People Person { get; set; }

How would i do this :)

Posted 20-Oct-14 21:14pm

Nico_Travassos

Add a Solution

2 solutions

Solution 1

I'm guessing that you mean EF, using fluent API.

This is a simple model, so shouldn't need a custom mapper.

C#

public class Movie
{    
    [Key]
    public int MovieID { get; set; }
    public string Title { get; set; }
    public string Storyline { get; set; }
    public string Year { get; set; }
    public string Runtime { get; set; }
    public DateTime ReleaseDate { get; set; }
    public DateTime DateTimeAdded { get; set; }
    public DateTime? DateTimeEdited { get; set; }
 
    public virtual ICollection<MovieProducers> MovieProducers { get; set; }
}

Then we link back by simply adding a foreign key attribute to MovieProducers. This attribute points to a virtual property.

C#

public class MovieProducer
{
    [Key]
    public int MovieProducerID { get; set; }

    [ForeignKey("Movie")]
    public int MovieID { get; set; }

    [ForeignKey("Person")]
    public int PersonID { get; set; }
 
    public virtual Movie Movie{ get; set; }
    public virtual People Person { get; set; }
}

You should have fully mapped access with this structure.

Posted 21-Oct-14 1:21am

Nathan Minier

Updated 21-Oct-14 1:29am

v2

Comments

Nico_Travassos 21-Oct-14 7:25am

What i was trying to do is some like this but im not sure how to do it with the above example

protected override void OnModelCreating(DbModelBuilder modelBuilder)
{
modelBuilder.Entity<course>().
HasMany(c => c.Students).
WithMany(p => p.CoursesAttending).
Map(
m =>
{
m.MapLeftKey("CourseId");
m.MapRightKey("PersonId");
m.ToTable("PersonCourses");
});
}

Nathan Minier 21-Oct-14 7:27am

Unless you're already overriding your context's model binder (assuming EF+) you do not need to for these classes. They're simple enough for the default to keep tabs on.

Nico_Travassos 21-Oct-14 7:31am

MovieProducer is many to many relationship in database so apparently i dont need the class i can just use below example to auto create the table for me is that no correct

protected override void OnModelCreating(DbModelBuilder modelBuilder)
{
modelBuilder.Entity().
HasMany(c => c.Students).
WithMany(p => p.CoursesAttending).
Map(
m =>
{
m.MapLeftKey("CourseId");
m.MapRightKey("PersonId");
m.ToTable("PersonCourses");
});
}

Nathan Minier 21-Oct-14 8:03am

You'll still need the MoveProducers class. If you want to use the un-attributed model, then you can map it as follows:

protected override void OnModelCreating(DbModelBuilder modelBuilder)
{
base.OnModelCreating(modelBuilder);

modelBuilder.Entity<Person>()
.HasRequired(c => c.Movie)
.WithMany(d => d.Person)
.Map(m => {
m.MapLeftKey("MovieID");
m.MapRightKey("PersonID");
m.ToTable("MovieProducers");
});

modelBuilder.Entity<movie>()
.HasRequired(c => c.Person)
.WithMany(d => d.Movie)
.Map(m => {
m.MapLeftKey("PersonID");
m.MapRightKey("MovieID");
m.ToTable("MovieProducers");
});
}

Nico_Travassos 21-Oct-14 8:05am

Check my solution 2 see what i did is correct?

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Nico_Travassos · Accepted Answer · 2014-10-21T01:56:00

I think i did it correct

Movie.cs

C#

[Key]
        [Column]
        public int MovieID { get; set; }
        [Column]
        public string Title { get; set; }
        [Column]
        public string Storyline { get; set; }
        [Column]
        public string Year { get; set; }
        [Column]
        public string Runtime { get; set; }
        [Column]
        public DateTime ReleaseDate { get; set; }
        [Column]
        public DateTime DateTimeAdded { get; set; }
        [Column]
        public DateTime? DateTimeEdited { get; set; }

        public virtual ICollection<People> MovieProducers { get; set; }

People.cs

C#

public class People
    {
        [Key]
        [Column]
        public int PersonID { get; set; }
        [Column]
        public string FirstName { get; set; }
        [Column]
        public string MiddleName { get; set; }
        [Column]
        public string LastName { get; set; }

        public virtual ICollection<Movies> Movies { get; set; }
    }

DbContext.cs

C#

public DbSet<Movies> Movies { get; set; }
        public DbSet<People> Person { get; set; }

        protected override void OnModelCreating(DbModelBuilder modelBuilder)
        {
            modelBuilder.Conventions.Remove<PluralizingTableNameConvention>();

            modelBuilder.Entity<Movies>().
              HasMany(c => c.MovieProducers).
              WithMany(p => p.Movies).
              Map(
               m =>
               {
                   m.MapLeftKey("MovieID");
                   m.MapRightKey("PersonID");
                   m.ToTable("MovieProducer");
               });
        }