namespace LckLib.EF.V6.Models
{
    public class Role
    {
        public int ID { get; set; }
        [MaxLength(20)]
        [Required]
        public string RoleName { get; set; }
        public string Remark { get; set; }
        public virtual List<User> Users { get; set; }
    }

    public class User
    {
        public int ID { get; set; }
        [MaxLength(20)]
        public string UserName { get; set; }
        public string Account { get; set; }
        public string Password { get; set; }
        public DateTime CreateDate { get; set; }
        public string Remark { get; set; }
        public virtual Role Role { get; set; }
    }
}

namespace LckLib.EF.V6.Models
{
    public class Activity
    {
        public int ActivityId { get; set; }
        [Required, MaxLength(50)]
        public string Name { get; set; }
        public List<Trip> Trips { get; set; }
    }

    public class Trip
    {
        public int TripId { get; set; }
        public DateTime StartDate { get; set; }
        public DateTime EndDate { get; set; }
        public decimal CostUSD { get; set; }
        public byte[] RowVersion { get; set; }
        public List<Activity> Activities { get; set; }
    }
}

namespace LckLib.EF.V6.Models
{
    public class Person
    {
        public int ID { get; set; }
        public int SocialSecurityNumber { get; set; }
        public string FirstName { get; set; }
        public string LastName { get; set; }
        [Timestamp]
        public byte[] RowVersion { get; set; }
        public PersonPhoto Photo { get; set; }
    }

    public class PersonPhoto
    {
        [Key, ForeignKey("PhotoOf")]
        public int ID { get; set; }
        public byte[] Photo { get; set; }
        public string Caption { get; set; }
        public Person PhotoOf { get; set; }
    }
}

namespace LckLib.EF.V6
{
    public class LckDbContext : DbContext
    {
        public LckDbContext()
        {
            //默认是开启延迟加载
            this.Configuration.LazyLoadingEnabled = true;
        }

        public DbSet<User> Users { get; set; }
        public DbSet<Role> Roles { get; set; }

        public DbSet<Activity> Activities { get; set; }
        public DbSet<Trip> Trips { get; set; }

        public DbSet<Person> Persons { get; set; }
        public DbSet<PersonPhoto> PersonPhotos { get; set; }

    }
}

            LckDbContext ef = new LckDbContext();
            var personInfo = from a in ef.Persons.Include("Photo")
                             select a;
            Console.WriteLine(personInfo.FirstOrDefault().Photo.Caption);