Posted by: Rosario Barbagallo | August 31, 2017

Entity Framework

Entity Framework is an object-relational mapper. This means that it can return the data in your database as an object (e.g.: a Person object with the properties Id, Name, etc.) or a collection of objects.

Why Entity Framework?

  • Simplification of Queries
  • Use of LINQ
  • Easy to use

The Entity Framework provides facilities to do the following: materialize data returned from the database as entity objects; track changes that were made to the objects; handle concurrency; propagate object changes back to the database; and bind objects to controls.

Code Example:

namespace EF_Code_First_Tutorials
    public class SchoolContext: DbContext 
        public SchoolContext(): base()
        public DbSet<Student> Students { get; set; }
        public DbSet<Standard> Standards { get; set; }
public class Student
    public Student()
    public int StudentID { get; set; }
    public string StudentName { get; set; }
    public DateTime? DateOfBirth { get; set; }
    public byte[]  Photo { get; set; }
    public decimal Height { get; set; }
    public float Weight { get; set; }
    public Standard Standard { get; set; }

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s


%d bloggers like this: