Mapping MySQL database tables/fields to C# entity classes manually

Question

With version 4 of the Entity Framework, you have the option to doing what they call Code First. The thing is that the naming of your classes and fields/properties need to match the database from what I know. I am using MySQL and as such I use all lowercase and underscores in naming as capitalization is not supported on all OSes and can make MySQL act weird if you try to force it. The issue is that I use the standard C# naming conventions of using camelCase and PascalCase. Is there a way to map the naming in my database to my classes in C# without using the entity model designer (the .edmx file) as the design seems a bit buggy. Thanks.

Buildstarted · Accepted Answer · 2010-12-17 20:52:11Z

2

You can use the overridable method OnModelCreating which will run on first instantiation of the class. There you can override individual tables like so

public class Context : DbContext {

    //your models

    protected override void OnModelCreating(ModelBuilder modelBuilder) {
        modelBuilder.Entity<SomeTable>()
                         .MapSingleType()
                         .ToTable("YourTableNameInDatabase");
    }
}

It's that simple :)

edited Dec 17, 2010 at 20:52

answered Dec 5, 2010 at 18:33

Buildstarted

26.7k10 gold badges88 silver badges96 bronze badges

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

2 Comments

ryanzec Over a year ago

The model classes does extend or anything so there are no override-able methods since it is just a POCO.

Buildstarted Over a year ago

You're correct, however the DbContext class is the class with the override.

Collectives™ on Stack Overflow

Mapping MySQL database tables/fields to C# entity classes manually

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related