// Entity Framework Extensions

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

​

// @nuget: Microsoft.EntityFrameworkCore.SqlServer

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

// @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 Z.EntityFramework.Plus;

​

public class Program

{

    public static void Main()

    {

        using (var context = new EntityContext())

        {

            context.Database.EnsureCreated();

        }

        var guidID = new Guid("00000000-0000-0000-0000-000000000013");

        // INSERT with values

        using (var context = new EntityContext())

        {

            context.Database.OpenConnection();

            context.GeneratedValueWithDataAnnotations.SqlServerSetIdentityInsertOn(); // extension method from EF Plus

            // context.Database.ExecuteSqlRaw("SET IDENTITY_INSERT GeneratedValueWithDataAnnotations ON;");

            var entity = new GeneratedValueWithDataAnnotation() {

                TestName = "INSERT with values",

                ID = guidID, // INSERT (Saved)              

                Identity = 13, // INSERT (Saved)

                Computed = "INSERT (Ignore)",

                Concurrency = "INSERT (Save)",

                Timestamp = "INSERT (Ignore)",

            };

​

            context.GeneratedValueWithDataAnnotations.Add(entity);

            context.SaveChanges();

            FiddleHelper.WriteTable("1 - INSERT with values", context.GeneratedValueWithDataAnnotations.AsNoTracking().ToList());

        }

        // UPDATE with values

        using (var context = new EntityContext())

        {

            var entity = context.GeneratedValueWithDataAnnotations.First();

            entity.TestName = "UPDATE with values";

            //entity.ID = Guid.NewGuid(); // UPDATE (Throw)

            //entity.Identity = 99;  // UPDATE (Save), SQL Server throw the error, not EF COre

            entity.Computed = "UPDATE (Ignore)";

            entity.Concurrency = "UPDATE (Save)";

            entity.Timestamp = "UPDATE (Ignore)";

            context.SaveChanges();

            FiddleHelper.WriteTable("2 - UPDATE with values", context.GeneratedValueWithDataAnnotations.AsNoTracking().ToList());

        }

    }

    public class EntityContext : DbContext

    {

        public EntityContext() 

        {

        }

​

        protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)

        {

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

​

            base.OnConfiguring(optionsBuilder);

        }

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

    }

​

    public class GeneratedValueWithDataAnnotation

    {

        public string TestName { get; set; }

        [Key]

        public Guid ID { get; set; }

        [DatabaseGenerated(DatabaseGeneratedOption.Identity)]

        public int Identity { get; set; }   

        [DatabaseGenerated(DatabaseGeneratedOption.Computed)]

        public string Computed { get; set; }

        [ConcurrencyCheck]

        public string Concurrency { get; set; }

        [Timestamp]

        public string Timestamp { get; set; }

    }

}