// @nuget: EntityFramework

// @nuget: Z.EntityFramework.Extensions

​

using System;

using System.Linq;

using System.Data.SqlClient;

using System.Data.Entity;

using System.ComponentModel.DataAnnotations;

using System.ComponentModel.DataAnnotations.Schema;

​

public class Program

{

    public static void Main()

    {   

        using (var context = new EntityContext())

        {

            // For create Table, without Permission for Database.

            context.Customers.Add(new Customer() { Name ="Customer_A", IsActive = false  });

            context.SaveChanges();

        }

        CreateTrigger();

        // ADD seed data here

        using (var context = new EntityContext())

        {

            try 

            {

                context.Customers.Add(new Customer() { Name ="Customer_A", IsActive = false  });

                context.Customers.Add(new Customer() { Name ="Customer_B", IsActive = true });

                context.Customers.Add(new Customer() { Name ="Customer_C", IsActive = false });

                context.SaveChanges();

            }

            catch (Exception e )

            {

                Console.WriteLine("SaveChanges : ");

                Console.WriteLine(e.Message);

                Console.WriteLine();

                Console.WriteLine("SaveChanges InnerException  1: ");

                Console.WriteLine(e.InnerException.Message);

                Console.WriteLine();

                Console.WriteLine("SaveChanges InnerException 2 : ");

                Console.WriteLine(e.InnerException.InnerException.Message);

            }

        }

        using (var context = new EntityContext())

        {

            try 

            {

                context.Customers.Add(new Customer() { Name ="Customer_A", IsActive = false  });

                context.Customers.Add(new Customer() { Name ="Customer_B", IsActive = true });

                context.Customers.Add(new Customer() { Name ="Customer_C", IsActive = false });

                context.BatchSaveChanges();

            }

            catch (Exception e )

            {

                Console.WriteLine();

                Console.WriteLine("BatchSaveChanges : ");

                Console.WriteLine(e.Message);

            }

        }

    }

    public class EntityContext : DbContext

    {

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

        {

​

        }

        public DbSet<Customer> Customers { get; set; }

    }

    public static void CreateTrigger() 

    {

        using (var connection = new SqlConnection(FiddleHelper.GetConnectionStringSqlServer()))

        {

            connection.Open();

            using (var command = connection.CreateCommand())

            {

                command.CommandText = @"   

CREATE TRIGGER [dbo].[TRIGER_Customer]

   ON  [dbo].[Customer]

   AFTER INSERT,DELETE,UPDATE

AS 

BEGIN

    ROLLBACK TRAN

    RAISERROR (N'Custom error!!!!!', -- Message text.  

           16, -- Severity,  

           1 -- State

           ); -- Second argument.   

END";

                command.ExecuteNonQuery();

            }

        }

    }

    [Table("Customer")]

    public class Customer

    {

        public int CustomerID { get; set; }

        public string Name { get; set; }

        public Boolean IsActive { get; set; }

    }

}