// @nuget: EntityFramework

​

using System;

using System.Data.Entity;

using System.Linq;

using System.Collections.Generic;

using System.ComponentModel.DataAnnotations.Schema;

public class Program

{

    public static void Main()

    {

        using (var context = new EntityContext())

        {

            Student student = new Student()

            {

                FullName = "Mark",

                EnrollmentDate = DateTime.Now

            };

​

            Teacher teacher = new Teacher()

            {

                FullName = "John",

                HireDate = DateTime.Now

            };

​

            context.People.Add(student);

            context.People.Add(teacher);

​

            context.SaveChanges();

            var query = context.People.OfType<Student>().ToString();

            Console.WriteLine(query);

        }

    }

    public class EntityContext : DbContext

    {

        public EntityContext() : base(FiddleHelper.GetConnectionStringSqlServer())

        {

​

        }

        public DbSet<Person> People { get; set; }

​

        protected override void OnModelCreating(DbModelBuilder modelBuilder)

        {

​

            modelBuilder.Entity<Student>().ToTable("Students");

            modelBuilder.Entity<Teacher>().ToTable("Teachers");

        }

    }

    public abstract class Person

    {

        public int Id { get; set; }

        public string FullName { get; set; }

    }

​

    [Table("Students")]

    public class Student : Person

    {

        public DateTime EnrollmentDate { get; set; }

    }

​

    [Table("Teachers")]

    public class Teacher : Person

    {

        public DateTime HireDate { get; set; }

    }

}