Entity Framework with existing database

entity-framework

Solution

Even when a database already exists I still use the Code First approach, mapping the tables using annotations, because the domain is way more organized than on the EDMX file. If there are many tables the visual EDMX can become really useless since the design will be overcrowded with data and connections all over the place.

In two steps you can begin with this approach:

1) Create a domain model class, `Customer` for example, and map it to your table using data annotations:

[Table("tbl_cust")]
public class Customer
{
    [Key]
    [Column("cust_id")]
    public int CustomerId { get; set; }
    [Column("cust_name")]
    public string Name { get; set; }
    // Add other properties below
 }

2) Create a context class deriving from `DbContext` and set `DbSet<T>` properties for each model, we have only one in our case so:

public class MyApplicationContext: DbContext
{
    public MyApplicationContext() : base("name=ConnectionStringName") { }

    public DbSet<Customer> Customers { get; set; }
}

Now anywhere in your code can instantiate the derived `DbContext` class and make queries using Linq:

var _db = new MyApplicationContext();
var customer = _db.Customers.Where(c => c.CustomerId == 37).FirstOrDefault();

Don't forget to add a reference to EntityFramework assembly using NuGet.

Good Luck.

Problem

I'm looking to implement entity framework version 4.3.1 in my existing project which don't follow this EF.The database is already developed and is currently used applying ado.net.In this case how do I start with to work on EF, is it Database First,Code first.

Original source