Membership.GetUser () & MARS
I am using asp.net membership and I need to call Memberhip.GetUser () while I have another open SQL connection, but my code dies on this call. I have MultipleActiveResultSets = True in the connection string which is used by both my code and the membership provider. It looks like the Membership class is ignoring the MARS part of the connection string.
Any suggestions as to how I can get MARS to work with the Membership class so that I can resolve this issue?
Thank,
Scott
source to share
Have you tried using a separate connection string (one for the data for the membership provider) without the "MultipleActiveResultSets = True?"
Is this how it works? If it works, you can use SqlConnectionStringBuilder to create a new connection string (from the original) without the MARS option.
source to share