// Entity Framework Extensions

// Doc: https://entityframework-extensions.net/bulk-insert

​

// @nuget: Microsoft.EntityFrameworkCore.SqlServer

// @nuget: Z.EntityFramework.Extensions.EFCore

​

using System;

using System.Collections.Generic;

using System.ComponentModel.DataAnnotations;

using System.ComponentModel.DataAnnotations.Schema;

using System.Linq;

using Microsoft.Data.SqlClient;

using Microsoft.EntityFrameworkCore;

using Microsoft.EntityFrameworkCore.Metadata;

​

public class Program

{

    public static void Main()

    {

        using (var context = new EntityContext())

        {

            context.Database.EnsureCreated();

        }

        // INSERT with values

        using (var context = new EntityContext())

        {

            context.Database.OpenConnection();

            var entity = new GeneratedValueWithDataAnnotation() {

                TestName = "INSERT with values",

                DefaultValue = "INSERT (Throw)",

            };

​

            context.GeneratedValueWithDataAnnotations.Add(entity);

            context.SaveChanges();

        }

    }

    public class EntityContext : DbContext

    {

        public EntityContext() 

        {

        }

​

        protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)

        {

            optionsBuilder.UseSqlServer(new SqlConnection(FiddleHelper.GetConnectionStringSqlServer()));

​

            base.OnConfiguring(optionsBuilder);

        }

        protected override void OnModelCreating(ModelBuilder modelBuilder)

        {

            modelBuilder.Entity<GeneratedValueWithDataAnnotation>().HasKey(x => x.ID);

            modelBuilder.Entity<GeneratedValueWithDataAnnotation>().Property(x => x.DefaultValue).HasDefaultValue("Entity Framework Extensions").Metadata.SetBeforeSaveBehavior(PropertySaveBehavior.Throw); // specifying an explicit value will now throw an error when adding an entity;

​

            base.OnModelCreating(modelBuilder);

        }

        public DbSet<GeneratedValueWithDataAnnotation> GeneratedValueWithDataAnnotations { get; set; }

    }

​

    public class GeneratedValueWithDataAnnotation

    {

        public Guid ID { get; set; }

​

        public string TestName { get; set; }

        public string DefaultValue { get; set; }

    }

}