Removing defunct/missing applications' references from ASP.NET SQL memership DB?

Creating my first site that uses the login/membership system provided in ASP.NET (v4).

So far all is good, used the web.config to point it at a remote SQL server, and it's working.

What I didn't do originally was specify an 'applicationName' for the membership provider, so when looking at the table(s) in the SQL server it shows the name as "/".

I updated the web.config and added the Membership and Provider sections needed to assign a name, assigned one, and ran the ASP.NET Configuration Wizard to re-initialize the user DB.

In the SQL server the application now shows its name and a new GUID, and works as expected.

My question is, is there an automated way to get rid of all the (now unneeded) records associated to the 'old site' from the various ASP.NET SQL table(s), or am I stuck doing it manually?

If I need to do this manually, is anyone aware of a laid out set of procedures to ensure all references are removed from the DB?

6
задан techie007 23 October 2011 в 20:09
поделиться