// @nuget: EntityFramework

​

using System;

using System.Data.Entity;

using System.Linq;

using System.Collections.Generic;

using System.ComponentModel.DataAnnotations.Schema;

using System.ComponentModel.DataAnnotations;

​

public class Program

{

    public static void Main()

    {

        var actor1 = new Actor { Id = 1, Name = "Vin Diesel" }; 

        var movie1 = new Movie { Id = 1, Title = "Fast and Furious", PrimaryActor = actor1 };

        using (var context = new MovieDb())

        {

            Console.WriteLine("========= Start Add: movie1 ==============");

            context.Movies.Add(movie1);

            context.SaveChanges();

            Console.WriteLine("========= END Add: movie1 ==============");

            var m1 = context.Movies.First();

            Console.WriteLine(m1.PrimaryActor.Name);

​

            var m2 = context.Movies.Include(m => m.PrimaryActor).AsNoTracking().First();

            Console.WriteLine(m2.PrimaryActor.Name);

​

            var m3 = context.Movies.AsNoTracking().First();

            Console.WriteLine(m3.PrimaryActor.Name);

        }

    }

​

    public class MovieDb : DbContext

    {

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

        {

        }

​

        public DbSet<Movie> Movies { get; set; }

    }

​

    public class Movie

    {

        [Key]

        [DatabaseGenerated(DatabaseGeneratedOption.None)]

        public int Id { get; set; }

​

        public string Title { get; set; }

        public Actor PrimaryActor { get; set; }

        public int PrimaryActorId { get; set; }

    }

​

    public class Actor

    {

        [Key]

        [DatabaseGenerated(DatabaseGeneratedOption.None)]

        public int Id { get; set; }

​

        public string Name { get; set; }

    }

}