Savepoint is not supported with memory optimized tables (EF core 5)

Question

Upgrade 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 called "Content".

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 ?

NOTE: If I use TransactionScope then pass success.

Please give me the solution to handle this situation https://learn.microsoft.com/en-us/ef/core/saving/transactions

Answer 1

I want to insert row into two table without foreign key.

in startup.cs file

public void ConfigureServices(IServiceCollection services)
    {
        services.AddHealthChecks();
        services.AddDbContext<wUtilityContentContext>(opts => opts.UseSqlServer(
           Algorithm.Decrypt(Configuration["ConnectionStrings:wUtilityContent_ConnectionString"]),
           b => b.MigrationsAssembly(typeof(Startup).GetTypeInfo().Assembly.GetName().Name)));

        services.AddUnitOfWorkPool(optionsBuilder =>
        {
            optionsBuilder.AddUnitOfWork<wUtilityContentContext>("Content");
        });
        services.AddScoped<IContentUow, ContentUow>();
        services.AddScoped<AuditCoreLog>();
        services.AddSingleton<IHttpContextAccessor, HttpContextAccessor>();
        ....
    }

In ContentService.cs file

public class ContentServices : ContentServiceBase
{
    private readonly AuditCoreLog _auditLog;
    private readonly IContentUow _contentUow;
    public ContentServices(IContentUow contentUow, AuditCoreLog auditLog)
    {
        _contentUow = contentUow;
        _auditLog = auditLog;
    }
    public override Task<MessageResponse> CategoryInsertUpdate(CategoryInsertUpdate_Request request, ServerCallContext context)
    {
        var response = new MessageResponse() { };
        try
        {
            int _RESPONSE_EXISTED_CATE = -2;
            int _RESPONSE_NOT_EXISTS_CATE = -3;
            int _nHotOrder = 0;
            var findnHotOrder = _contentUow.Category.Where(p => p.ParentId == request.ParentId).ToList();
            if (findnHotOrder != null && findnHotOrder.Count > 0)
               _nHotOrder = findnHotOrder.Max(x => x.OrderNo).GetValueOrDefault();
            var insertCategory = _contentUow.Category.Add(new TblCategory()
            {
                    ParentId = request.ParentId,
                    Alias = request.Alias,
                    OrderNo = _nHotOrder + 1,
                    Status = request.Status,
                    CreatedDate = DateTime.Now,
                    CreatedUser = request.CreatedUser,
                    SystemId = request.SystemId,
                    ImageUrl = request.ImageUrl
            });

                _contentUow.SaveChanges(); //savechange to DB -> get id identity
                var _categoryId = insertCategory.Entity.Id;
                var insertCategoryContent_vi = _contentUow.CategoryContent.Add(new TblCategoryContent()
                {
                    CategoryId = _categoryId,
                    CategoryName = request.CategoryNameVi,
                    CategoryContent = request.CategoryContentVi,
                    LanguageId = (int)PaymentApps_PaymentLanguage.VN
                });

                var insertCategoryContent_en = _contentUow.CategoryContent.Add(new TblCategoryContent()
                {
                    CategoryId = _categoryId,
                    CategoryName = request.CategoryNameEn,
                    CategoryContent = request.CategoryContentEn,
                    LanguageId = (int)PaymentApps_PaymentLanguage.EN
                });
            _contentUow.SaveChanges();
            _contentUow.CommitTransaction();
            response.ResponseStatus = ErrorCodes.SUCCESS;
        }
        catch (Exception ex)
        {
            response.ResponseStatus = ErrorCodes.SYSTEM_ERROR;
            _contentUow.RollbackTransaction();
        }
    }
}