Using RoleProvider in TransactionScope

Topics: NetSqlAzMan Core
Jan 15, 2014 at 10:57 AM
Hello there!

I am using NetSqlAzMan v3.6.0.15 Roles Provider in a WPF application.

We have one module where we use the
  • provider.RemoveUsersFromRoles()
  • provider.AddUsersToRoles()
    methods to update the roles of certain users and this works fine as is.
However, if we wrap the code in a using (TransactionScope scope) statement, connections to the database are created and they are not closed until the application is closed.

Has anyone else come across this issue(maybe has a fix) or has a better way of creating transactional updates that we are missing?

Thanks in advance,