There should be some documentation here about what happens, if anything, to the entities when a rollback occurs.

dotnet / EntityFramework.Docs

Documentation for Entity Framework Core and Entity Framework 6

https://docs.microsoft.com/ef/

Creative Commons Attribution 4.0 International

1.63k stars 1.96k forks source link

There should be some documentation here about what happens, if anything, to the entities when a rollback occurs. #2791

Open adraut opened 4 years ago

adraut commented 4 years ago

[Enter feedback here]

Document Details

⚠ Do not edit this section. It is required for docs.microsoft.com ➟ GitHub issue linking.

ID: 1073c238-9389-d826-a696-f1108a4f2ce0
Version Independent ID: cf56babd-def0-d76e-8eee-e33341b6a009
Content: Transactions - EF Core
Content Source: entity-framework/core/saving/transactions.md
Product: entity-framework
Technology: entity-framework-core
GitHub Login: @roji
Microsoft Alias: avickers

phonglevishn commented 3 years ago

Hi @roji I upgraded EF core version 3.1 to 5 with new feature SavePoints (auto created when use transaction manual)

I have a memory-optimized table in SQL Server 2016.

When I call the "SaveChanges" command the system throws an exception "Creating a savepoint is not supported with memory optimized tables." How can I turn off savepoints when use memory optimized tables in transaction sql ?

NOTE: If I use TransactionScope then success.

Please give me the solution to handle this situation

Thank you

roji commented 3 years ago

@phonglevishn a in https://github.com/dotnet/EntityFramework.Docs/pull/2698#issuecomment-735734472, I've opened https://github.com/dotnet/efcore/issues/23526 (this isn't really related to this issue).