Comments (3)
Please i have scenario here , in the following code i am assuming that for-each will be executed twice:
-first loop will be executed successfully and commit the inner transaction.
-second loop will fail and Rollback the inner transaction.
I am expected to find the added rows by the first transaction before rollback the outer transaction but looks like what is happening is rolling back second loop will roll back also first loop
looks like using BeginTransaction within TransactionScope has some issues in addition to the issues with nested transaction in EF6
Any thoughts on this?
using (var OuterTransactionScope = new TransactionScope())
{
using (DbContext = new DbContext())
{
foreach (var x in list) // assume this will be executed twice
{
try
{
var innerTransaction = DbContext.Database.BeginTransaction(isolationLevel);
DbContext.SaveChanges(); //Add row
DbContext.SaveChanges(); //Add row
innerTransaction.Commit();
}
catch (Exception ex)
{
innerTransaction.Rollback();
}
}
//Expecting to find two rows here but Actually no data get added
}
from ef6.
Ported from CodePlex https://entityframework.codeplex.com/workitem/2909
from ef6.
Moved to the docs repo as the EF6.x docs are going to end up in the same repo as the EF Core docs. They are going thru a migration process, so changes are difficult right now. dotnet/EntityFramework.Docs#327
from ef6.
Related Issues (20)
- Visual Studio DB Save Changes HOT 1
- Bulk Insert/Update from C# .Net 4.8 HOT 1
- Package Manager Console doesn't take configuration from project only always compiles with ANY CPU option HOT 1
- add-migrations does not add Migrations folder HOT 1
- Nuget does not pull the dll's HOT 1
- Error when updating code to .NET 8 HOT 3
- After upgrading to the latest version of vs, running DbMigrator reports an error HOT 1
- Add-Migration not recognized after install of Microsoft.EntityFrameworkCore.Tools HOT 1
- To match the data types of columns in the database and in the class HOT 1
- Entity Framework not able to import stored procedures HOT 1
- Entity Framework not importing stored procedures HOT 1
- Thread.CurrentThread.CurrentCulture settings are leaked into the generated SQL causing invalid SQL HOT 7
- Next Release for Microsoft.Data.SqlClient HOT 20
- EF 6.5 release checklist HOT 35
- EntityFramework package initialization error in Package Manager Console HOT 1
- EF6.5 + Azure + ASP.NET MVC + Microsoft.Data.SqlClient ProviderName HOT 6
- Cannot use EF6 with Microsoft.EntityFramework.SqlServer and Microsoft.Data.SqlClient HOT 6
- Documentation for HResult -2146232004 HOT 1
- No app.config override for Microsoft.Data.SqlClient? HOT 2
- EF 6.5.0 RTM NuGet Package BROKEN HOT 11
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from ef6.