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();
 }