How to delete all users in my membership table?

Question

I have a test that requires all users in my SimpleMembershipProvider UserProfile table to be deleted. I'd like to do this in my SeedMembership() method (below). Something like membership.DeleteAllUsers. Any idea how this can be done?

private int SeedMembership()
        {

            if (!WebMatrix.WebData.WebSecurity.Initialized)
            {
                WebSecurity.InitializeDatabaseConnection("TestConnection", "UserProfile", "UserId", "UserName", autoCreateTables: true);
            }


            var roles = (SimpleRoleProvider)Roles.Provider;
            var membership = (SimpleMembershipProvider)Membership.Provider;

            if (!roles.RoleExists("Admin"))
            {
                roles.CreateRole("Admin");
            }
            if (!roles.RoleExists("User"))
            {
                roles.CreateRole("User");
            }

            // Somehow delete all users here

            if (membership.GetUser("user", false) == null)
            {
                membership.CreateUserAndAccount("user", "covert");
            }
            if (!roles.GetRolesForUser("user").Contains("Admin"))
            {
                roles.AddUsersToRoles(new[] { "user" }, new[] { "admin" });
            }

            return membership.GetUserId("user");

        }

score 1 · Answer 1 · answered May 05 '13 at 18:55

1

go through this link

http://blogs.thesitedoctor.co.uk/tim/Trackback.aspx?guid=b16a67b9-4c34-4566-a689-088e6c087405

or simply do this...

foreach (MembershipUser u in Membership.GetAllUsers())
{
 Membership.DeleteUser(u.UserName, true);
}

answered May 05 '13 at 18:55

Ankush Jain

1,532
1
15
24

This will not work in OP's case - they're using the `SimpleMembershipProvider` (part of WebMatrix), and the documentation states that the `GetAllUsers` method will fail if the provider has been initialized by a call to `WebSecurity.InitializeDatabaseConnection`, which OP has in the code. – Tim May 05 '13 at 19:02
I got this error: Item has already been added. Key in dictionary: – Anas Naim Mar 24 '16 at 07:43

score 1 · Answer 2 · answered May 05 '13 at 19:05

1

In SQL Server and MySQL you can run:

TRUNCATE my_aspnet_users
TRUNCATE my_aspnet_membership
TRUNCATE my_aspnet_profiles
TRUNCATE my_aspnet_roles

answered May 05 '13 at 19:05

Alberto León

2,879
2
25
24

score 0 · Answer 3 · answered May 05 '13 at 19:10

0

well if you want to delete all members , delete the table and recreate it ,its more like a trick not an answer . Or use entity framework its easier .

answered May 05 '13 at 19:10

Narek Minaskan

109
1
1
6

score 0 · Accepted Answer · answered May 13 '13 at 10:01

I have had to implement similar functionality on several projects, the simplest way I have found to do it is this (from memory, but I think this is going to work):

var dbUsernames = context.Database.SqlQuery<string>("SELECT UserName FROM UserProfile");
foreach (string dbUsername in dbUsernames)
{
    string[] userRoles = Roles.GetRolesForUser(dbUsername);
    if (userRoles != null && userRoles.Length > 0)
    {
        Roles.RemoveUserFromRoles(dbUsername, userRoles); 
    }
    int userId = context.Database.SqlQuery<int>("SELECT UserId FROM UserProfile WHERE UserName = {0}", dbUsername).First();
    // HERE: Delete any other dependent rows in other tables that use UserId, and have referential integrity
    // Now tear down any final bits and delete the user, for example: 
    Membership.DeleteUser(dbUsername, true);
    context.Database.ExecuteSqlCommand(
        "DELETE FROM webpages_Membership WHERE UserId = {0}", userId);
}

This is not that efficient, you're going to end up calling save on each call to delete the user — johnny 5, May 15 '20 at 16:20

How to delete all users in my membership table?

4 Answers4