// @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 movie1 = new Movie { Id = 1, Title = "Godzilla" };

        var movie2 = new Movie { Id = 2, Title = "Iron Man" };

        using (var context = new MovieDb())

        {

            /*

            context.Database.Log = (s) => {

                Console.WriteLine(s);

            };

            */

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

            context.Movies.Add(movie1);

            context.SaveChanges();

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

​

            // LET EF CREATE ALL THE SCHEMAS AND STUFF THEN WE CAN TEST

​

            context.Database.Log = (s) => {

                Console.WriteLine(s);

            };

​

            Console.WriteLine("========= Start SELECT FIRST movie ==============");

            var movie1a = context.Movies.First();

            Console.WriteLine("========= End SELECT FIRST movie ==============");

            Console.WriteLine("========= Start Attach Movie2 ==============");

            context.Movies.Attach(movie2);

            Console.WriteLine("========= End Attach Movie2 ==============");

            Console.WriteLine("========= Start SELECT Movie2 ==============");

            var movie2a = context.Movies.FirstOrDefault(m => m.Id == 2);

            Console.WriteLine("========= End SELECT Movie2 ==============");

            Console.Write("Movie2a.Id = ");

            Console.WriteLine(movie2a == null ? "null" : movie2a.Id.ToString());

        }

​

    }

​

    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; }

    }

}