Entity Framework Core and DocumentDB Transaction

Use the same transaction in different methods with Entity Framework Core

EDIT (02/03/2018) :... Since Entity Framework Core 2.1, EF Core implements transactions, cross-context transactions, ambient transactions and transactions scopes so this question is now out of date. ...This is the official documentation about the transactions in EF Core : ...https://docs.microsoft.com/en-us/ef/core/saving/transactions.......How can...

How to unit-test transactions in Entity Framework Core?

You could check EF Core logs for a ...RelationalEventId.RollingbackTransaction... event type. I provided full details here: ...How to trace an Entity Framework Core event for integration testing?...How it could look:...Assert.True(eventList.Contains((int)RelationalEventId.CommittingTransaction));

Log DbContext.SaveChanges Exception to the database in Entity Framework/Entity Framework Core

In Entity framework Core, I have solved the problem easily using EF-Core ...Transaction...try { _unitOfWork.Repository<Product>().InsertEntity(product); await _unitOfWork.SaveChangesAsync();//This throws exception due the model validation failure } catch (Exception exception) { ExceptionModel exceptionModel = new ExceptionModel(); ...

How to create a DBContext as part of an existing transaction in Entity Framework Core

I have product that already uses ADO.Net to access SQL Server and I'm using Entity Framework Core for some new functionality. The problem I'm having is I have some operations that must be done in a single transaction and the first few actions are implemented through ADO.Net and I need add an extra action using Entity Framework so I need to pass the...

Best way to coordinate atomic transactions between different business services in .NET Core / EF Core 2.1?

Let's say you have a UsersService, a TenantsService, and a TenantUserRolesService. ...Each of these services has a "create" method to create their entity and has the same DbContext dependency injected, except for UsersService which has the Identity UserManager class injected....Your goal is to provide an API endpoint that lets a new tenant register...

Entity Framework Core: Transaction between reading and deleting data

Yes and no. You can wrap it into a transaction - which is trivial....https://docs.microsoft.com/en-us/ef/core/saving/transactions...show how....You basically just create a transaction:...using (var transaction = context.Database.BeginTransaction())...Alternatively you can use a DbTransaction on a DbConnection. Same link....But your code is simply b...

What's the point of multiple SaveChanges inside an entity-framework-core transaction?

I'm using EF for my .net-core application and I'm wondering what is the difference between calling ...SaveChanges... multiple times during a transaction and only calling it once before committing. To better illustrate my question, I will provide some pseudo code....public async Task<IActionResult> AddDepositToHousehold(int householdId, DepositReque...

Entity Framework Core MigrationBuilder "ALTER DATABASE statement not allowed within multi-statement transaction."

I am new to Entity Framework Migrations and using Migration Builder in ...Entity Framework Core 2.2.4... to create raw ...Sql... statements but getting this exception ...ALTER DATABASE statement not allowed within multi-statement transaction...Here is my code ...public partial class EnableChangeTracking : Migration { protected override void Up...

The transaction between Dapper and EF Core fails with an error. Parallel transactions are not supported by SqlConnection.

I started using EF Core with Dapper and while trying to use them both inside a TransactionScope when I call context.SaveChanges() I get the error ...SqlConnection does not support parallel transactions.... The code is the following:...public class TestController : ControllerBase { private readonly MyDbContext dbContext; private readonly IDb...

MS DTC Cancelling Transaction with Entity Framework Core

I'm receiving a...System.Data.SqlClient.SqlException (0x80131904): The Microsoft Distributed Transaction Coordinator (MS DTC) has cancelled the distributed transaction....error when using EF Core 2.1. The full stack trace is at the bottom of this message....Here's the basic process:...Read request message from Kafka...Write message to a set of "raw...