在.net中利用membership来创建的用户,涉及到一些表,而这些表之间又有各种映射关系,所以删除表的数据要有一定的顺序,总的来说这个顺序是这样的:
Delete From aspnet_profile
Delete From aspnet_paths
Delete From aspnet_PersonalizationAllUsers
Delete From aspnet_PersonalizationPerUser
Delete From aspnet_SchemaVersions
Delete From aspnet_WebEvent_Events
Delete From aspnet_UsersInRoles
Delete From aspnet_Roles
Delete From aspnet_Membership
Delete From aspnet_Users
Delete From aspnet_Applications
Delete From aspnet_profile
Delete From aspnet_paths
Delete From aspnet_PersonalizationAllUsers
Delete From aspnet_PersonalizationPerUser
Delete From aspnet_SchemaVersions
Delete From aspnet_WebEvent_Events
Delete From aspnet_UsersInRoles
Delete From aspnet_Roles
Delete From aspnet_Membership
Delete From aspnet_Users
Delete From aspnet_Applications