CSharp · Console
// @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()
{
Id = 1,
FullName = "Mark",
EnrollmentDate = DateTime.Now
};
Teacher teacher = new Teacher()
{
Id = 2,
FullName = "John",
HireDate = DateTime.Now
};
context.People.Add(student);
context.People.Add(teacher);
context.SaveChanges();
var students = context.People.OfType<Student>().ToList();
var teachers = context.People.OfType<Teacher>().ToList();
FiddleHelper.WriteTable(students);
FiddleHelper.WriteTable(teachers);
}
}
public class EntityContext : DbContext
{
public EntityContext() : base(FiddleHelper.GetConnectionStringSqlServer())
{
}
public DbSet<Person> People { get; set; }
protected override void OnModelCreating(DbModelBuilder modelBuilder)
{
modelBuilder.Entity<Student>().Map(m =>
{
m.MapInheritedProperties();
m.ToTable("Students");
});
modelBuilder.Entity<Teacher>().Map(m =>
{
m.MapInheritedProperties();
m.ToTable("Teachers");
});
}
}
public abstract class Person
{
[DatabaseGenerated(DatabaseGeneratedOption.None)]
public int Id { get; set; }
public string FullName { get; set; }
}
public class Student : Person
{
public DateTime EnrollmentDate { get; set; }
}
public class Teacher : Person
{
public DateTime HireDate { get; set; }
}
}