How to map table name to EF Entity?

Question

I have been using EF Code First for 1 month. My project needs to work with many tables (over 100 tables of data) and they will be changed many times in the future. It hard to control and take time to add the migration.

So is there any solution to skip the add-migration step, just create the table in the database and create a mapping to the Entity?

Example:

In database I have a table like this:

CREATE TABLE dbo.MyTable
(
    Id INT,
    Name VARCHAR(255),
    Description VARCHAR(1000)
);

I want to map it to the following entity:

public class MyEntity
{
   public Id int {get; set;}
   public Name string {get; set;}
   public Description string {get; set;}
}

My expected solution is something like this:

CreateMap("dbo.MyTable", MyEntity)

Answer 1

Use the attribute System.ComponentModel.DataAnnotations.Schema.Table

[Table("MyTable")]
public class MyEntity
{
   public Id int {get; set;}
   public Name string {get; set;}
   public Description string {get; set;}
}

If you don't actually want to run the migrations, I suggest create them anyway and comment out the relevant code before you run them. That way you will be well set up for the occassion when you do actually want to run them.