EntityFrameworkCore.FirebirdSQL icon indicating copy to clipboard operation
EntityFrameworkCore.FirebirdSQL copied to clipboard

Transaction not working ?

Open Herium opened this issue 6 years ago • 0 comments

Need to work with transactions , but not working, if i remove transaction code ,works fine

var sms = this.DbContext.SMS.Find(id);
            if (this._validation.DeleteValidation(httpContext, id))
            {
                using (var dbContextTransaction = this.DbContext.Database.BeginTransaction())
                {
                    this.DbContext.SMS.Remove(sms);


                    if (this.DbContext.SaveChanges() == 1)
                    {
                       //error here says the transaction does not exists anymore
                        dbContextTransaction.Commit();
                        return true;
                    }
                    dbContextTransaction.Rollback();
                }
                
            }

Herium avatar Nov 07 '19 16:11 Herium