public AspNetDbTablesAdapter()
{
SqlConnection connection = new SqlConnection(DataAccessUtil.GetConnectionString());
m_DeleteApplicationCommand = new SqlCommand();
m_DeleteallApplicationsCommand = new SqlCommand();
m_DeleteApplicationCommand.Connection = connection;
m_DeleteApplicationCommand.CommandType = CommandType.Text;
m_DeleteallApplicationsCommand.Connection = connection;
m_DeleteallApplicationsCommand.CommandType = CommandType.Text;
m_DeleteApplicationCommand.CommandText = @"
DECLARE @ApplicationId uniqueidentifier
SELECT @ApplicationId = ApplicationId
FROM dbo.aspnet_Applications
WHERE LOWER(@ApplicationName) = LoweredApplicationName
IF(@ApplicationId IS NOT NULL)
BEGIN
DELETE FROM dbo.aspnet_UsersInRoles
WHERE
UserID IN (SELECT UserID FROM dbo.aspnet_Users WHERE ApplicationID = @ApplicationId)
AND
RoleID IN (SELECT RoleID FROM dbo.aspnet_Roles WHERE ApplicationID = @ApplicationId)
DELETE FROM dbo.aspnet_Roles WHERE ApplicationId = @ApplicationId
DELETE FROM dbo.aspnet_Membership WHERE ApplicationId = @ApplicationId
DELETE FROM dbo.aspnet_Users WHERE ApplicationId = @ApplicationId
DELETE FROM dbo.aspnet_Paths WHERE ApplicationId = @ApplicationId
DELETE FROM dbo.aspnet_Applications WHERE ApplicationId = @ApplicationId
END";
m_DeleteApplicationCommand.Parameters.Add(new SqlParameter("@ApplicationName", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
m_DeleteallApplicationsCommand.CommandText = "DELETE FROM dbo.aspnet_UsersInRoles DELETE FROM dbo.aspnet_Roles DELETE FROM dbo.aspnet_Membership DELETE FROM dbo.aspnet_Users DELETE FROM dbo.aspnet_Paths DELETE FROM dbo.aspnet_Applications";
}
private void InitConnection()
{
this.m_connection = new SqlConnection();
this.m_connection.ConnectionString = DataAccessUtil.GetConnectionString();
}