EF - Transaction | C# Online Compiler

EF - Transaction by ZZZ Projects

// @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()
	{
		using (var context = new BookStore())
		{
			context.Database.Log = Console.WriteLine;
			Author author1 = new Author() {	Name = "Mark" };
			Author author2 = new Author() {	Name = "John" };
				
			context.Authors.Add(author1);
			context.SaveChanges();
			
			context.Authors.Add(author2);
			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 Name { get; set; }
	}
}

​x
 
// @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()
    {
        using (var context = new BookStore())
        {
            context.Database.Log = Console.WriteLine;
            Author author1 = new Author() { Name = "Mark" };
            Author author2 = new Author() { Name = "John" };
                
            context.Authors.Add(author1);
            context.SaveChanges();
            
            context.Authors.Add(author2);
            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 Name { get; set; }
    }
}

Opened connection at 2/25/2025 6:17:23 PM +00:00

SELECT Count(*)
FROM INFORMATION_SCHEMA.TABLES AS t
WHERE t.TABLE_SCHEMA + '.' + t.TABLE_NAME IN ('dbo.Authors')
    OR t.TABLE_NAME = 'EdmMetadata'

-- Executing at 2/25/2025 6:17:23 PM +00:00

-- Completed in 26 ms with result: 0

Closed connection at 2/25/2025 6:17:23 PM +00:00

Opened connection at 2/25/2025 6:17:23 PM +00:00

SELECT
    [GroupBy1].[A1] AS [C1]
    FROM ( SELECT
        COUNT(1) AS [A1]
        FROM [dbo].[__MigrationHistory] AS [Extent1]
        WHERE [Extent1].[ContextKey] = @p__linq__0
    )  AS [GroupBy1]

-- p__linq__0: 'Program+BookStore' (Type = String, Size = 4000)

-- Executing at 2/25/2025 6:17:24 PM +00:00

-- Failed in 48 ms with error: Invalid object name 'dbo.__MigrationHistory'.

Closed connection at 2/25/2025 6:17:24 PM +00:00

Opened connection at 2/25/2025 6:17:24 PM +00:00

SELECT
    [GroupBy1].[A1] AS [C1]
    FROM ( SELECT
        COUNT(1) AS [A1]
        FROM [dbo].[__MigrationHistory] AS [Extent1]
    )  AS [GroupBy1]

-- Executing at 2/25/2025 6:17:24 PM +00:00

-- Failed in 1 ms with error: Invalid object name 'dbo.__MigrationHistory'.

Closed connection at 2/25/2025 6:17:24 PM +00:00

Opened connection at 2/25/2025 6:17:24 PM +00:00

SELECT
    [GroupBy1].[A1] AS [C1]
    FROM ( SELECT
        COUNT(1) AS [A1]
        FROM [dbo].[__MigrationHistory] AS [Extent1]
        WHERE [Extent1].[ContextKey] = @p__linq__0
    )  AS [GroupBy1]

-- p__linq__0: 'Program+BookStore' (Type = String, Size = 4000)

-- Executing at 2/25/2025 6:17:24 PM +00:00

-- Failed in 1 ms with error: Invalid object name 'dbo.__MigrationHistory'.

Closed connection at 2/25/2025 6:17:24 PM +00:00

Opened connection at 2/25/2025 6:17:24 PM +00:00

SELECT
    [GroupBy1].[A1] AS [C1]
    FROM ( SELECT
        COUNT(1) AS [A1]
        FROM [dbo].[__MigrationHistory] AS [Extent1]
    )  AS [GroupBy1]

-- Executing at 2/25/2025 6:17:24 PM +00:00

-- Failed in 1 ms with error: Invalid object name 'dbo.__MigrationHistory'.

Closed connection at 2/25/2025 6:17:24 PM +00:00

Opened connection at 2/25/2025 6:17:25 PM +00:00

Started transaction at 2/25/2025 6:17:25 PM +00:00

CREATE TABLE [dbo].[Authors] (
    [AuthorId] [int] NOT NULL IDENTITY,
    [Name] [nvarchar](max),
    CONSTRAINT [PK_dbo.Authors] PRIMARY KEY ([AuthorId])
)

-- Executing at 2/25/2025 6:17:25 PM +00:00

-- Completed in 7 ms with result: -1

CREATE TABLE [dbo].[__MigrationHistory] (
    [MigrationId] [nvarchar](150) NOT NULL,
    [ContextKey] [nvarchar](300) NOT NULL,
    [Model] [varbinary](max) NOT NULL,
    [ProductVersion] [nvarchar](32) NOT NULL,
    CONSTRAINT [PK_dbo.__MigrationHistory] PRIMARY KEY ([MigrationId], [ContextKey])
)

-- Executing at 2/25/2025 6:17:25 PM +00:00

-- Completed in 2 ms with result: -1

INSERT [dbo].[__MigrationHistory]([MigrationId], [ContextKey], [Model], [ProductVersion])
VALUES (N'202502251817252_InitialCreate', N'Program+BookStore',  0x1F8B0800000000000400CD57DD6EDB3614BE2FB0772078B5A1A9E93818B005528BD4490AA371125469EF69E9D8264A912A4905F6B3F5A28FB457D8A17E2D29769D6CC08600814D9DF3F13BDFF993FFFAFE2378B749257904638556213D1D8D290115EB44A8554873B77CF3077DF7F69757C155926EC897DAEECCDBA1A7B2215D3B979D3366E335A4DC8E52111B6DF5D28D629D329E6836198FFF64A7A70C1082221621C1A75C399142F105BF4EB58A21733997739D80B4D5393E890A5472CB53B0198F21A453B4B816C6BAE68C920B29383289402E29E14A69C71DF23CFF6C217246AB5594E101970FDB0CD06EC9A5858AFF796B7E6C28E3890F85B58E35549C5BA7D367029E9E55DAB0BEFB8B14A68D76A8DE15AAECB63EEA42C1905EE46EAD0D25FDABCEA7D278B390DE1BBD323C7D5D5A9E90C9F82C119BDFB39326F9E351F17742A6B974B9815041EE0C9727E43E5F48117F84ED83FE0A2A54B994BB7490103EEB1CE0115E988171DB4FB0EC909C2594B0AE37EBBB37CE03CF3298997267134A6E91085F486832BF1378E4B4810FA0C07007C93D770E0C266E9640A1DD8043EF46FFBFBE0D4B0DBB869239DFDC805AB97548F12325D76203497D5231F8AC0436193A399343F79280B5691B26135BC57181742B02EFB5FE5AC4F04452B1FCABBCDAEAA26E2C256204AE239FA5A4255036D5A8AE9BA778368CDAAE6565DBD6EDCDF6F47730E7598692EDF47B7542A2AAD9DF44CFEF82B4C460B17DA2191AB6CD4D281E5F41EFE9CE9CB9E48E2FB84FDA34490766ADFE7BB4ADEFE94ADCEF8256F1DADE7F2E7D8613AFCE470FA5D5EF1A434AB1828BE8A0E1D20C808163316AB9E4666F474DB5CC5375B8430F21959DB28B529E0C1102D68BA22F161BA8D59B137DF10F556DDFA4B9BDA9DE5E950655C53C6355D525549A5082D23C8AC4974FB4B50ED291371845DFE4540A8CB73598732596605D3950296E8B496FDBFD7F360FB3369147AD9FFF742708AFEF4FA7FE60651CBF06D42337F19A9B5F53BEF96D17E99F8EFAE1443A669C1F98E6653986345968245F926C76C00B47FDB03902B6FBB6175C8215AB16C2BFFB29887DD5B5A0B5CD4C2D75AD34C6B5CBA836E925620E8E2728CF857162C963878F63B0B6D8CB5FB8CCD1E42A5D40325377B9CB7277612DA40BD9D9F3013B7C7FB1CFBA9C83BBCC7FB3FF46084853600870A7DEE742260DEFEB6121EE83F095525537B2C2F712845B6D1BA45BAD8E04AAE4BB840C94EF8D0748338960F64E45FC115EC20D5F4A6E60C5E36D3DE3F683FC3C115DD9834BC1FDCBABAD305A7FFF0B86F99F306FFF06529079BEF40C0000 , N'6.2.0-61023')

-- Executing at 2/25/2025 6:17:25 PM +00:00

-- Completed in 2 ms with result: 1

Committed transaction at 2/25/2025 6:17:25 PM +00:00

Opened connection at 2/25/2025 6:17:25 PM +00:00

Started transaction at 2/25/2025 6:17:25 PM +00:00

INSERT [dbo].[Authors]([Name])
VALUES (@0)
SELECT [AuthorId]
FROM [dbo].[Authors]
WHERE @@ROWCOUNT > 0 AND [AuthorId] = scope_identity()

-- @0: 'Mark' (Type = String, Size = -1)

-- Executing at 2/25/2025 6:17:26 PM +00:00

-- Completed in 3 ms with result: SqlDataReader

Committed transaction at 2/25/2025 6:17:26 PM +00:00

Closed connection at 2/25/2025 6:17:26 PM +00:00

Opened connection at 2/25/2025 6:17:26 PM +00:00

Started transaction at 2/25/2025 6:17:26 PM +00:00

INSERT [dbo].[Authors]([Name])
VALUES (@0)
SELECT [AuthorId]
FROM [dbo].[Authors]
WHERE @@ROWCOUNT > 0 AND [AuthorId] = scope_identity()

-- @0: 'John' (Type = String, Size = -1)

-- Executing at 2/25/2025 6:17:26 PM +00:00

-- Completed in 0 ms with result: SqlDataReader

Committed transaction at 2/25/2025 6:17:26 PM +00:00

Closed connection at 2/25/2025 6:17:26 PM +00:00

Cached Result
Last Run:	6:17:21 pm
Compile:	0.244s
Execute:	7.31s
Memory:	27.17Mb
CPU:	3.141s

View IL Code