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;
			using (DbContextTransaction transaction = context.Database.BeginTransaction())
    		{
				try
				{
					Author author1 = new Author() {	Name = "Mark" };
					Author author2 = new Author() {	Name = "John" };
				
					context.Authors.Add(author1);
					context.SaveChanges();
			
					context.Authors.Add(author2);
					context.SaveChanges();
					transaction.Commit();
				}
				catch (Exception ex)
        		{
            		transaction.Rollback();
        		}
			}
		}
		
	}
	
	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;
            using (DbContextTransaction transaction = context.Database.BeginTransaction())
            {
                try
                {
                    Author author1 = new Author() { Name = "Mark" };
                    Author author2 = new Author() { Name = "John" };
                
                    context.Authors.Add(author1);
                    context.SaveChanges();
            
                    context.Authors.Add(author2);
                    context.SaveChanges();
                    transaction.Commit();
                }
                catch (Exception ex)
                {
                    transaction.Rollback();
                }
            }
        }
        
    }
    
    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 1/26/2025 4:25:19 AM +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 1/26/2025 4:25:19 AM +00:00

-- Completed in 33 ms with result: 0

Closed connection at 1/26/2025 4:25:19 AM +00:00

Opened connection at 1/26/2025 4:25:19 AM +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 1/26/2025 4:25:20 AM +00:00

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

Closed connection at 1/26/2025 4:25:20 AM +00:00

Opened connection at 1/26/2025 4:25:20 AM +00:00

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

-- Executing at 1/26/2025 4:25:20 AM +00:00

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

Closed connection at 1/26/2025 4:25:20 AM +00:00

Opened connection at 1/26/2025 4:25:21 AM +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 1/26/2025 4:25:21 AM +00:00

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

Closed connection at 1/26/2025 4:25:21 AM +00:00

Opened connection at 1/26/2025 4:25:21 AM +00:00

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

-- Executing at 1/26/2025 4:25:21 AM +00:00

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

Closed connection at 1/26/2025 4:25:21 AM +00:00

Opened connection at 1/26/2025 4:25:21 AM +00:00

Started transaction at 1/26/2025 4:25:21 AM +00:00

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

-- Executing at 1/26/2025 4:25:21 AM +00:00

-- Completed in 12 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 1/26/2025 4:25:21 AM +00:00

-- Completed in 3 ms with result: -1

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

-- Executing at 1/26/2025 4:25:21 AM +00:00

-- Completed in 2 ms with result: 1

Committed transaction at 1/26/2025 4:25:21 AM +00:00

Opened connection at 1/26/2025 4:25:21 AM +00:00

Started transaction at 1/26/2025 4:25:21 AM +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 1/26/2025 4:25:22 AM +00:00

-- Completed in 3 ms with result: SqlDataReader

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 1/26/2025 4:25:22 AM +00:00

-- Completed in 1 ms with result: SqlDataReader

Committed transaction at 1/26/2025 4:25:22 AM +00:00

Closed connection at 1/26/2025 4:25:22 AM +00:00

Cached Result
Last Run:	4:25:18 am
Compile:	0.237s
Execute:	6.764s
Memory:	27.22Mb
CPU:	3.328s

View IL Code