EF - Fluent API (Table Mapping) | C# Online Compiler

EF - Fluent API (Table Mapping) by ZZZ Projects

// @nuget: Z.EntityFramework.Classic

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())
		{
			FiddleHelper.WriteTable(context.Authors.ToList());
		}
	}
	
	public static void InsertData()
	{
		using (var context = new BookStore())
		{
			var Authors = new List<Author>
			{
				new Author() {FirstName = "Mark", LastName = "Cuban"},
				new Author() {FirstName = "Andy", LastName = "Holloway"}
			};
			
		    context.Authors.AddRange(Authors);
			context.SaveChanges();
			
		}
	}
	
	public class BookStore : DbContext
    {
        public BookStore() : base(FiddleHelper.GetConnectionStringSqlServer())
        {
        }

        public DbSet<Author> Authors { get; set; }
		
		protected override void OnModelCreating(DbModelBuilder modelBuilder)
    	{
        	modelBuilder.Entity<Author>()
            	.ToTable("AuthorsData");
    	}
    }

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

​x
 
// @nuget: Z.EntityFramework.Classic
​
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())
        {
            FiddleHelper.WriteTable(context.Authors.ToList());
        }
    }
    
    public static void InsertData()
    {
        using (var context = new BookStore())
        {
            var Authors = new List<Author>
            {
                new Author() {FirstName = "Mark", LastName = "Cuban"},
                new Author() {FirstName = "Andy", LastName = "Holloway"}
            };
            
            context.Authors.AddRange(Authors);
            context.SaveChanges();
            
        }
    }
    
    public class BookStore : DbContext
    {
        public BookStore() : base(FiddleHelper.GetConnectionStringSqlServer())
        {
        }
​
        public DbSet<Author> Authors { get; set; }
        
        protected override void OnModelCreating(DbModelBuilder modelBuilder)
        {
            modelBuilder.Entity<Author>()
                .ToTable("AuthorsData");
        }
    }
​
    public class Author
    {
        public int AuthorId { get; set; }
        public string FirstName { get; set; }
        public string LastName { get; set; }
    }
}

Unhandled exception. System.TypeInitializationException: The type initializer for 'System.Data.Entity.DbContext' threw an exception.
---> System.TypeInitializationException: The type initializer for 'Z.EntityFramework.Classic.EntityFrameworkManager' threw an exception.
---> System.TypeInitializationException: The type initializer for '' threw an exception.
---> System.IO.FileNotFoundException: Could not load file or assembly 'System.Configuration.ConfigurationManager, Version=8.0.0.0, Culture=neutral, PublicKeyToken=cc7b13ffcd2ddd51'. The system cannot find the file specified.

File name: 'System.Configuration.ConfigurationManager, Version=8.0.0.0, Culture=neutral, PublicKeyToken=cc7b13ffcd2ddd51'
   at Z.Expressions.CompilerManager..cctor()
   at Z.Expressions.CompilerManager.LoadEntityFrameworkClassicConfiguration()
   at Z.Expressions.ExceptionMessage.ThrowLicenseException()
   at ..cctor()
   --- End of inner exception stack trace ---
   at .()
   at Z.EntityFramework.Classic.EntityFrameworkManager..cctor()
   --- End of inner exception stack trace ---
   at Z.EntityFramework.Classic.EntityFrameworkManager.Initialize()
   at System.Data.Entity.DbContext..cctor()
   --- End of inner exception stack trace ---
   at System.Data.Entity.DbContext..ctor(String nameOrConnectionString)
   at Program.BookStore..ctor()
   at Program.InsertData()
   at Program.Main()
Command terminated by signal 6

Last Run:	8:40:32 pm
Compile:	0.04s
Execute:	0.16s
Memory:	11.59Mb
CPU:	0.2s

View IL Code