Hello everyone,i have a service that inserts values into my database i'm inserting two different tables in this case one is for IContentService from umbraco

_contentService.SaveAndPublish(umbContent);

The Other one ise Using EntityFramework with UnitOfWork,but this cause some issues even though transaction fails it still inserts the value to Umbraco but not the database,in some cases it does inserts values into Database but not umbraco,i'm trying to prevent this. I know there is a thing called IScopeProvider from umbraco i'm using this somewhere else in my code but this sometimes caus the problem of inserting to the umbraco but not to my EF Table. Here is an example of my code how can i use transaction for data consistency? In this code it gives the error "The connection is already in a transaction and cannot participate in another transaction." Any ideas will be appreciated thanks. https://cdn.discordapp.com/attachments/1286598202862080060/1286598203042566174/message.txt?ex=66ee7d73&is=66ed2bf3&hm=a0ae130a2cb5bf11b26aa892596c068c38bf82cdcea07d2b6f261437653765ff&