mikecole

var posts = context.Posts
                   .Include(p => p.Author.JobTitle) //We are going two levels deep
                   .ToArray();
                   
                   
//We are going two levels deep here, also. However, since Authors.Posts is a collection, we
//need to do a little LINQ-Fu to properly include Categories.
var author = context.Authors
                .Include(a => a.Posts.Select(p => p.Category))
                .Single(a => a.ID == id);

mikecole

kick

mikecole

CREATE TABLE [dbo].[Authors](
  [ID] [int] IDENTITY(1,1) NOT NULL,
	[Name] [nvarchar](max) NULL,
	[TwitterHandle] [nvarchar](max) NULL,
	[JobTitle_ID] [int] NULL,
 CONSTRAINT [PK_dbo.Authors] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

mikecole

using System.Data.Entity;
using System.Data.Entity.ModelConfiguration;
using System.Data.Entity.ModelConfiguration.Conventions;
using EntityFrameworkExtraMile.Web.Domain.Model;

namespace EntityFrameworkExtraMile.Web.DataAccess
{
    public class BlogContext : DbContext
    {
        public BlogContext()

mikecole

CREATE TABLE [dbo].[Author](
  [ID] [int] IDENTITY(1,1) NOT NULL,
	[Name] [nvarchar](50) NOT NULL,
	[TwitterHandle] [nvarchar](50) NULL,
	[JobTitleID] [int] NULL,
 CONSTRAINT [PK_dbo.Author] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

mikecole

    [Table("Author")]
    public class Author : EntityBase
    {
        public Author()
        {
            Posts = new Collection<Post>();
        }

        [Required]
        [StringLength(50)]

mikecole

namespace EntityFrameworkExtraMile.Web.Migrations
{
    using System;
    using System.Data.Entity;
    using System.Data.Entity.Migrations;
    using System.Linq;

    internal sealed class Configuration : DbMigrationsConfiguration<EntityFrameworkExtraMile.Web.DataAccess.BlogContext>
    {
        public Configuration()

mikecole

namespace EntityFrameworkExtraMile.Web.Migrations
{
    using System;
    using System.Data.Entity.Migrations;
    
    public partial class InitialCreate : DbMigration
    {
        public override void Up()
        {
            CreateTable(

mikecole

namespace EntityFrameworkExtraMile.Web.Migrations
{
    using System.Data.Entity.Migrations;
    
    public partial class AddEmailToAuthor : DbMigration
    {
        public override void Up()
        {
            AddColumn("dbo.Author", "Email", c => c.String(maxLength: 50));
        }

mikecole

namespace EntityFrameworkExtraMile.Web.Migrations
{
    using System.Data.Entity.Migrations;
    
    public partial class InitializeEtc : DbMigration
    {
        public override void Up()
        {
            CreateIndex("Category", "Name", true);
            CreateIndex("JobTitle", "Title", true);