Naming C# classes from bad table columns

Question

I have used Entity Framework and a SQL Server database until now. So I can represent my table name as a class name and property names as properties like following.

class Product{ 
      public string Id { get; set;} 
      public string Name { get; set;} 
}

The table and column names are the same with my class.

But now I will work a project that uses a Postgresql database. Table names and column names are like this.

• Tables products, product_categories (lowercase)
• Columns product_id, product_name, category_id, ....

So I do not want to use class names like this:

class products { 
      public string product_id { get; set; }
      public string product_name { get; set; }
      public string category_id { get; set; }
}

This looks like an ugly naming conventions. How can I solve this issue?

Answer 1

Use table and column attributes. From MSDN example:

[Table("InternalBlogs")]
public class Blog
{   
    [Column("BlogDescription", TypeName="ntext")]
    public String Description {get;set;}
}