how to use a different name for my class property than the sql column name

Question

For example, if I wanted my class property to be named like this for a laugh:

class Product
{
   [Key]
   int ProductID {get;set;}

   [Required]
   string TitleTOTHEMAX {get;set;}
}

My Sql table has 2 columns "ProductID" and "Title", how do I tell the class's property to map itself to "Title" column considering the "TitleTOTHEMAX" column does not exist :)

user_2115690 · Answer

You should use Fluent Api with those kind of configuration.

protected override void OnModelCreating(ModelBuilder modelBuilder)
{
     modelBuilder.Entity()
    .Property(x => x.TitleTOTHEMAX )
    .HasColumnName("Title")
}

how to use a different name for my class property than the sql column name

3 Answers