EF - SaveChanges (Deleting Data)

CSharp · Console

/Program.cs

// @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()
	{
		InsertData();
		using (var context = new BookStore())
		{
			var author = context.Authors
				.Where(a => a.AuthorId == 2)
				.FirstOrDefault();
			
			context.Authors.Remove(author);
			context.SaveChanges();
			
			var authors = context.Authors.ToList();
			FiddleHelper.WriteTable(authors);
		}
	}
	
	public static void InsertData()
	{
		using (var context = new BookStore())
		{
			Author author1 = new Author()
		    {
		        FirstName = "Mark",
				LastName = "Cuban",
		    };
			
			Author author2 = new Author()
		    {
		        FirstName = "Andy",
				LastName = "Russell",
		    };
			
			Author author3 = new Author()
		    {
		        FirstName = "Johnny",
				LastName = "Bravo",
		    };
			
		    context.Authors.Add(author1);
			context.Authors.Add(author2);
			context.Authors.Add(author3);

		    context.SaveChanges();
		}
	}
	
	public class BookStore : DbContext
    {
        public BookStore() : base(FiddleHelper.GetConnectionStringSqlServer())
        {
        }

        public DbSet<Author> Authors { get; set; }
    }

    public class Author
	{
    	public int AuthorId { get; set; }
    	public string FirstName { get; set; }
		public string LastName { get; set; }
	}
}