Fluent Api in Entity Framework 6 not compatible Entity Framework Core

Question

I had implemented Fluent API using Entity Framework 6. Have problems when implementing the same using EnityFrameworkCore.

Below is the code using Fluent API using EntityFramework 6

 public class CustomerConfiguration : EntityTypeConfiguration<Customers>
    {
        public CustomerConfiguration()
        {
            ToTable("Customers");
            Property(c => c.FirstName).IsRequired().HasMaxLength(50);
            Property(c => c.LastName).IsRequired().HasMaxLength(50);
            Property(c => c.Gender).IsRequired().HasMaxLength(10);
            Property(c => c.Email).IsRequired().HasMaxLength(25);
            Property(c => c.Address).IsRequired().HasMaxLength(50);
            Property(c => c.City).IsRequired().HasMaxLength(25);
            Property(c => c.State).IsOptional().HasMaxLength(15);

        }
    }


  protected override void OnModelCreating(ModelBuilder modelBuilder)
        {
            modelBuilder.Configurations.Add(new CustomerConfiguration());
            modelBuilder.Configurations.Add(new OrderConfiguration());
            modelBuilder.Configurations.Add(new ProductConfiguration());

            modelBuilder.Entity<Orders>()
           .HasRequired(c => c.Customers)
           .WithMany(o => o.Orders)
           .HasForeignKey(f => f.CustomerId);

            modelBuilder.Entity<Orders>()
                .HasMany<Products>(s => s.Products)
                .WithMany(c => c.Orders)
                .Map(cs =>
                {
                    cs.MapLeftKey("OrderRefId");
                    cs.MapRightKey("ProductRefId");
                    cs.ToTable("OrderDetails");
                });


        }

The issues that I am getting in EntityFrameworkCore are

It dosent recognize ToTable and Property keywords in CustomerConfiguration()
It dosent recognize Configurations, HasRequired,MapLeftKey,MapRightKey,ToTable keyword in OnModelCreating method

Could somebody tell me how to achieve this using Fluent API in EntityFrameWork Core

Look at the EF Core documentation: learn.microsoft.com/en-us/ef/core/modeling — ErikEJ
– ErikEJ, Commented Nov 20, 2016 at 19:03

Sampath · Accepted Answer · 2016-11-20 19:41:14Z

5

EF core uses completely different APIs.So you must learn it first.

As an example : This is the way how it sets the ToTable().

protected override void OnModelCreating(ModelBuilder modelBuilder)
    {
        modelBuilder.Entity<Blog>()
            .ToTable("blogs");
    }

To learn you have to read these links :

Table Mapping

Relationships

Creating a Model

To encapsulate the configuration for an entity type in a class :

using Microsoft.EntityFrameworkCore.Metadata.Builders;

namespace Microsoft.EntityFrameworkCore
{
    public abstract class EntityTypeConfiguration<TEntity>
        where TEntity : class
    {
        public abstract void Map(EntityTypeBuilder<TEntity> builder);
    }

    public static class ModelBuilderExtensions
    {
        public static void AddConfiguration<TEntity>(this ModelBuilder modelBuilder, EntityTypeConfiguration<TEntity> configuration)
            where TEntity : class
        {
            configuration.Map(modelBuilder.Entity<TEntity>());
        }
    }
}

You can see more details here (see the first post which was edited by @rowanmiller : Github

edited Nov 20, 2016 at 19:41

answered Nov 20, 2016 at 19:06

Sampath

66.2k70 gold badges329 silver badges462 bronze badges

Sign up to request clarification or add additional context in comments.

7 Comments

Tom Over a year ago

So I cant create seperate configuration files and they add the configuration in onmodelcreating

Sampath Over a year ago

you can refer this link.please let me know whether is that working or not ? stackoverflow.com/questions/34855989/…

Botond Balázs Over a year ago

As far as I can see you can't. The issue for EntityTypeConfiguration<T> still open: github.com/aspnet/EntityFramework/issues/2805

Sampath Over a year ago

Thanks for the link.EF team has given workaround for that.please see my post @BotondBalázs

Botond Balázs Over a year ago

Looks great! I don't understand why they haven't included it in the framework itself.

|

Alexander Taran · Accepted Answer · 2016-11-20 19:07:12Z

0

direct link to table maping documentation. Read the rest of it as well. EF core is a new product not an upgrade to EF6.

answered Nov 20, 2016 at 19:07

Alexander Taran

6,7252 gold badges42 silver badges61 bronze badges

Collectives™ on Stack Overflow

Fluent Api in Entity Framework 6 not compatible Entity Framework Core

2 Answers 2

7 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

7 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related