How to change the table name to lower case in generated tables?

Question

I am using entityframework core 5.0 + asp.net core web

and it will generate table name or column name as the class name or property name.

for example I have class

public class MyClassA
{
public int Id{get;set;}
public DeviceNo{get;set;}
public CreatedTime{get;set;}

}

the table name will be MyClassA and the column name will be Id;DeviceNo;CreatedTime.

how to get the table name my_class_a and the column name id.device_no .created_time while in Add-Migration?

I know can use the Column("my_class_a") attribute but there is so many properties I do not want to specify each of them.

Answer 1

Hi 6666666,
You can try to use EFCore.NamingConventions which automatically makes all your table and column names have snake_case naming.
More details you can refer to this link.
Best Regards,
Daniel Zhang

---

If the response is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Try something like this:

[Table("my_class_a")]
public class MyClassA
{
   [Column("id")]
   public int Id{get;set;}

   [Column("device_no")]
   public int DeviceNo{get;set;}

   [Column("created_time")]
   public DateTime CreatedTime{get;set;}
}