Entity Framework Code First CTP5 Mapping

Question

I've just started to implement EF CTP 5 in to a new project. In this case all my database fields are named differently to my POCO properties due to an obscure database naming convention. Am I right in thinking the best way to map this is to override OnModelCreating and have code like this

    modelBuilder.Entity<Sale>().Property(s => s.ID).HasColumnName("sale_id");
    modelBuilder.Entity<Sale>().Property(s => s.ProductName).HasColumnName("product_name");
    modelBuilder.Entity<Sale>().Property(s => s.ProductPrice).HasColumnName("product_price");
    modelBuilder.Entity<Sale>().Property(s => s.SaleDate).HasColumnName("sale_date");

This is going to end up very large very quick, is it really the best way to do this?

Morteza Manavi · Accepted Answer · 2010-12-13 15:02:26Z

3

I think you should consider using the new CTP5 Column attribute. Using data annotations seems to be a better choice than fluent API in this case. Your Sale class will look like the code below:

public class Sale
{
    [Column(Name="sale_id")]
    public int ID { get; set; }

    [Column(Name="product_name")]
    public string ProductName { get; set; }

    [Column(Name="product_price")]
    public string ProductPrice { get; set; }

    [Column(Name="sale_date")]
    public DateTime SaleDate { get; set; }
}

edited Dec 13, 2010 at 15:02

answered Dec 13, 2010 at 14:48

Morteza Manavi

33.2k6 gold badges103 silver badges84 bronze badges

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

1 Comment

KallDrexx Over a year ago

Although, if you are keeping your Business Entities separated from your data layer this doesn't seem like the best approach

Gavin · Accepted Answer · 2011-01-05 09:59:26Z

1

Thanks for the answers

I ended up sticking with my original approach as I wanted to keep the entities seperate from the data layer.

However to make it more manageable I made the context a partial class and created a file for each entity with a private method like MapUsers or MapRoles then in the OnModelCreating I just called these methods.

answered Jan 5, 2011 at 9:59

Gavin

17.5k19 gold badges68 silver badges111 bronze badges

2 Comments

Pure.Krome Over a year ago

Interesting solution - using partials and then the Event. This means you could have 1 partial class per poco, right? (worse case scenario).

Gavin Over a year ago

yes that's right. Maybe its not for everyone but for me it makes the code a lot more manageable.

Collectives™ on Stack Overflow

Entity Framework Code First CTP5 Mapping

2 Answers 2

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related