My issue is that I need to delete and re-insert 15000 rows in order to update them. This must take place in only one transaction.
Row by row removal is really slow when I do it. Insertion went smoothly....Is it possible to run an ExecuteSqlCommand statement in the same transaction as the insert statements that save changes to the context?
An extract from ...Getting Started with Entity Framework 6 with ASP.NET Core... is shown below:..."The recommended way to use Entity Framework 6 in an ASP.NET Core 1.0
application is to put the EF6 context and model classes in a class
library project (.csproj project file) that targets the full
framework. Add a reference to the class library ...
And I tried to utilize Dapper and EF Core together inside of a TransactionScope when I called context, I first began utilizing EF Core. I have a SaveChanges() error....SqlConnection does not support parallel transactions....
The code reads as follows:...public class TestController : ControllerBase
private readonly MyDbContext dbContext;