i have the following web.config and everything was fine until i added role provider.
i have two connection strings defined and code in my asp.net application to detect what machine is running the web app and pull the correct DB connection string for the environment (dev/ prod)
now i added role provider and everything is working but the definition in the web.config links the roles provider to a single DB in its declaration.
below is the section of my web.config in question.
how can i make it such that the roles in both DEV and PROD are independent and isolated as they should be???