I’m working on a .NET application where I need to manage transactions across multiple DbContext instances. My application uses a custom NuGet package that interacts with the database using Entity Framework Core. The NuGet package has its own DbContext and creates its own transaction scope. However, I need this to participate in a broader transaction scope initiated in the calling application to ensure all operations are atomic. Both DBContext using the same MSSQL Database.