NativeTransactions

Transakcje SQL Server

private static void TransactionTest()
        {
            Artist artist1 = new Artist();
            Artist artist2 = new Artist();
 
            using (var context = new MusicStoreContext())
            using (var transaction = context.Database.BeginTransaction())
            {
                try
                {
                    context.Artists.Add(artist1);
                    context.Artists.Add(artist2);
                    transaction.Commit();
                }
                catch(Exception)
                {
                    transaction.Rollback();
                }
            }
        }