Class MySqlSimpleMembershipProvider

Manages storage of simple membership information for an ASP.NET application in a MySQL database.

Inheritance

System.Object

System.Configuration.Provider.ProviderBase

System.Web.Security.MembershipProvider

WebMatrix.WebData.ExtendedMembershipProvider

MySqlSimpleMembershipProvider

Namespace: MySql.Web.Security

Assembly: MySql.Web.dll

Version: 9.3.0

Syntax

public class MySqlSimpleMembershipProvider : ExtendedMembershipProvider

Constructors

MySqlSimpleMembershipProvider()

Declaration

public MySqlSimpleMembershipProvider()

MySqlSimpleMembershipProvider(MembershipProvider)

Declaration

public MySqlSimpleMembershipProvider(MembershipProvider previousProvider)

Parameters

Type	Name	Description
System.Web.Security.MembershipProvider	previousProvider

Properties

ApplicationName

Declaration

public override string ApplicationName { get; set; }

Property Value

Type	Description
System.String

Overrides

System.Web.Security.MembershipProvider.ApplicationName

ConnectionString

Gets or sets the connection string.

Declaration

public string ConnectionString { get; set; }

Property Value

Type	Description
System.String

ConnectionStringName

Gets or sets the name associated to the connection string when stored in the configuration manager.

Declaration

public string ConnectionStringName { get; set; }

Property Value

Type	Description
System.String

EnablePasswordReset

Declaration

public override bool EnablePasswordReset { get; }

Property Value

Type	Description
System.Boolean

Overrides

System.Web.Security.MembershipProvider.EnablePasswordReset

EnablePasswordRetrieval

Declaration

public override bool EnablePasswordRetrieval { get; }

Property Value

Type	Description
System.Boolean

Overrides

System.Web.Security.MembershipProvider.EnablePasswordRetrieval

MaxInvalidPasswordAttempts

Declaration

public override int MaxInvalidPasswordAttempts { get; }

Property Value

Type	Description
System.Int32

Overrides

System.Web.Security.MembershipProvider.MaxInvalidPasswordAttempts

MinRequiredNonAlphanumericCharacters

Declaration

public override int MinRequiredNonAlphanumericCharacters { get; }

Property Value

Type	Description
System.Int32

Overrides

System.Web.Security.MembershipProvider.MinRequiredNonAlphanumericCharacters

MinRequiredPasswordLength

Declaration

public override int MinRequiredPasswordLength { get; }

Property Value

Type	Description
System.Int32

Overrides

System.Web.Security.MembershipProvider.MinRequiredPasswordLength

PasswordAttemptWindow

Declaration

public override int PasswordAttemptWindow { get; }

Property Value

Type	Description
System.Int32

Overrides

System.Web.Security.MembershipProvider.PasswordAttemptWindow

PasswordFormat

Declaration

public override MembershipPasswordFormat PasswordFormat { get; }

Property Value

Type	Description
System.Web.Security.MembershipPasswordFormat

Overrides

System.Web.Security.MembershipProvider.PasswordFormat

PasswordStrengthRegularExpression

Declaration

public override string PasswordStrengthRegularExpression { get; }

Property Value

Type	Description
System.String

Overrides

System.Web.Security.MembershipProvider.PasswordStrengthRegularExpression

ProviderName

Gets or sets the name of this provider.

Declaration

public string ProviderName { get; set; }

Property Value

Type	Description
System.String

RequiresQuestionAndAnswer

Declaration

public override bool RequiresQuestionAndAnswer { get; }

Property Value

Type	Description
System.Boolean

Overrides

System.Web.Security.MembershipProvider.RequiresQuestionAndAnswer

RequiresUniqueEmail

Declaration

public override bool RequiresUniqueEmail { get; }

Property Value

Type	Description
System.Boolean

Overrides

System.Web.Security.MembershipProvider.RequiresUniqueEmail

UserIdColumn

Gets the name of the column storing the user ids.

Declaration

public string UserIdColumn { get; }

Property Value

Type	Description
System.String

UserNameColumn

Gets the name of the column storing the user names.

Declaration

public string UserNameColumn { get; }

Property Value

Type	Description
System.String

UserTableName

Gets the name of the table storing user information.

Declaration

public string UserTableName { get; }

Property Value

Type	Description
System.String

Methods

ChangePassword(String, String, String)

Declaration

public override bool ChangePassword(string username, string oldPassword, string newPassword)

Parameters

Type	Name	Description
System.String	username
System.String	oldPassword
System.String	newPassword

Returns

Type	Description
System.Boolean

Overrides

System.Web.Security.MembershipProvider.ChangePassword(System.String, System.String, System.String)

ChangePasswordQuestionAndAnswer(String, String, String, String)

Declaration

public override bool ChangePasswordQuestionAndAnswer(string username, string password, string newPasswordQuestion, string newPasswordAnswer)

Parameters

Type	Name	Description
System.String	username
System.String	password
System.String	newPasswordQuestion
System.String	newPasswordAnswer

Returns

Type	Description
System.Boolean

Overrides

System.Web.Security.MembershipProvider.ChangePasswordQuestionAndAnswer(System.String, System.String, System.String, System.String)

ConfirmAccount(String)

Declaration

public override bool ConfirmAccount(string accountConfirmationToken)

Parameters

Type	Name	Description
System.String	accountConfirmationToken

Returns

Type	Description
System.Boolean

Overrides

WebMatrix.WebData.ExtendedMembershipProvider.ConfirmAccount(System.String)

ConfirmAccount(String, String)

Declaration

public override bool ConfirmAccount(string userName, string accountConfirmationToken)

Parameters

Type	Name	Description
System.String	userName
System.String	accountConfirmationToken

Returns

Type	Description
System.Boolean

Overrides

WebMatrix.WebData.ExtendedMembershipProvider.ConfirmAccount(System.String, System.String)

CreateAccount(String, String, Boolean)

Declaration

public override string CreateAccount(string userName, string password, bool requireConfirmationToken)

Parameters

Type	Name	Description
System.String	userName
System.String	password
System.Boolean	requireConfirmationToken

Returns

Type	Description
System.String

Overrides

WebMatrix.WebData.ExtendedMembershipProvider.CreateAccount(System.String, System.String, System.Boolean)

CreateOrUpdateOAuthAccount(String, String, String)

Declaration

public override void CreateOrUpdateOAuthAccount(string provider, string providerUserId, string userName)

Parameters

Type	Name	Description
System.String	provider
System.String	providerUserId
System.String	userName

Overrides

WebMatrix.WebData.ExtendedMembershipProvider.CreateOrUpdateOAuthAccount(System.String, System.String, System.String)

CreateUser(String, String, String, String, String, Boolean, Object, out MembershipCreateStatus)

Declaration

public override MembershipUser CreateUser(string username, string password, string email, string passwordQuestion, string passwordAnswer, bool isApproved, object providerUserKey, out MembershipCreateStatus status)

Parameters

Type	Name	Description
System.String	username
System.String	password
System.String	email
System.String	passwordQuestion
System.String	passwordAnswer
System.Boolean	isApproved
System.Object	providerUserKey
System.Web.Security.MembershipCreateStatus	status

Returns

Type	Description
System.Web.Security.MembershipUser

Overrides

System.Web.Security.MembershipProvider.CreateUser(System.String, System.String, System.String, System.String, System.String, System.Boolean, System.Object, System.Web.Security.MembershipCreateStatus)

CreateUserAndAccount(String, String, Boolean, IDictionary<String, Object>)

Declaration

public override string CreateUserAndAccount(string userName, string password, bool requireConfirmation, IDictionary<string, object> values)

Parameters

Type	Name	Description
System.String	userName
System.String	password
System.Boolean	requireConfirmation
System.Collections.Generic.IDictionary<System.String, System.Object>	values

Returns

Type	Description
System.String

Overrides

WebMatrix.WebData.ExtendedMembershipProvider.CreateUserAndAccount(System.String, System.String, System.Boolean, System.Collections.Generic.IDictionary<System.String, System.Object>)

DeleteAccount(String)

Declaration

public override bool DeleteAccount(string userName)

Parameters

Type	Name	Description
System.String	userName

Returns

Type	Description
System.Boolean

Overrides

WebMatrix.WebData.ExtendedMembershipProvider.DeleteAccount(System.String)

DeleteOAuthAccount(String, String)

Declaration

public override void DeleteOAuthAccount(string provider, string providerUserId)

Parameters

Type	Name	Description
System.String	provider
System.String	providerUserId

Overrides

WebMatrix.WebData.ExtendedMembershipProvider.DeleteOAuthAccount(System.String, System.String)

DeleteOAuthToken(String)

Declaration

public override void DeleteOAuthToken(string token)

Parameters

Type	Name	Description
System.String	token

Overrides

WebMatrix.WebData.ExtendedMembershipProvider.DeleteOAuthToken(System.String)

DeleteUser(String, Boolean)

Declaration

public override bool DeleteUser(string username, bool deleteAllRelatedData)

Parameters

Type	Name	Description
System.String	username
System.Boolean	deleteAllRelatedData

Returns

Type	Description
System.Boolean

Overrides

System.Web.Security.MembershipProvider.DeleteUser(System.String, System.Boolean)

FindUsersByEmail(String, Int32, Int32, out Int32)

Declaration

public override MembershipUserCollection FindUsersByEmail(string emailToMatch, int pageIndex, int pageSize, out int totalRecords)

Parameters

Type	Name	Description
System.String	emailToMatch
System.Int32	pageIndex
System.Int32	pageSize
System.Int32	totalRecords

Returns

Type	Description
System.Web.Security.MembershipUserCollection

Overrides

System.Web.Security.MembershipProvider.FindUsersByEmail(System.String, System.Int32, System.Int32, System.Int32)

FindUsersByName(String, Int32, Int32, out Int32)

Declaration

public override MembershipUserCollection FindUsersByName(string usernameToMatch, int pageIndex, int pageSize, out int totalRecords)

Parameters

Type	Name	Description
System.String	usernameToMatch
System.Int32	pageIndex
System.Int32	pageSize
System.Int32	totalRecords

Returns

Type	Description
System.Web.Security.MembershipUserCollection

Overrides

System.Web.Security.MembershipProvider.FindUsersByName(System.String, System.Int32, System.Int32, System.Int32)

GeneratePasswordResetToken(String, Int32)

Declaration

public override string GeneratePasswordResetToken(string userName, int tokenExpirationInMinutesFromNow)

Parameters

Type	Name	Description
System.String	userName
System.Int32	tokenExpirationInMinutesFromNow

Returns

Type	Description
System.String

Overrides

WebMatrix.WebData.ExtendedMembershipProvider.GeneratePasswordResetToken(System.String, System.Int32)

GetAccountsForUser(String)

Declaration

public override ICollection<OAuthAccountData> GetAccountsForUser(string userName)

Parameters

Type	Name	Description
System.String	userName

Returns

Type	Description
System.Collections.Generic.ICollection<WebMatrix.WebData.OAuthAccountData>

Overrides

WebMatrix.WebData.ExtendedMembershipProvider.GetAccountsForUser(System.String)

GetAllUsers(Int32, Int32, out Int32)

Declaration

public override MembershipUserCollection GetAllUsers(int pageIndex, int pageSize, out int totalRecords)

Parameters

Type	Name	Description
System.Int32	pageIndex
System.Int32	pageSize
System.Int32	totalRecords

Returns

Type	Description
System.Web.Security.MembershipUserCollection

Overrides

System.Web.Security.MembershipProvider.GetAllUsers(System.Int32, System.Int32, System.Int32)

GetCreateDate(String)

Declaration

public override DateTime GetCreateDate(string userName)

Parameters

Type	Name	Description
System.String	userName

Returns

Type	Description
System.DateTime

Overrides

WebMatrix.WebData.ExtendedMembershipProvider.GetCreateDate(System.String)

GetLastPasswordFailureDate(String)

Declaration

public override DateTime GetLastPasswordFailureDate(string userName)

Parameters

Type	Name	Description
System.String	userName

Returns

Type	Description
System.DateTime

Overrides

WebMatrix.WebData.ExtendedMembershipProvider.GetLastPasswordFailureDate(System.String)

GetNumberOfUsersOnline()

Declaration

public override int GetNumberOfUsersOnline()

Returns

Type	Description
System.Int32

Overrides

System.Web.Security.MembershipProvider.GetNumberOfUsersOnline()

GetOAuthTokenSecret(String)

Declaration

public override string GetOAuthTokenSecret(string token)

Parameters

Type	Name	Description
System.String	token

Returns

Type	Description
System.String

Overrides

WebMatrix.WebData.ExtendedMembershipProvider.GetOAuthTokenSecret(System.String)

GetPassword(String, String)

Declaration

public override string GetPassword(string username, string answer)

Parameters

Type	Name	Description
System.String	username
System.String	answer

Returns

Type	Description
System.String

Overrides

System.Web.Security.MembershipProvider.GetPassword(System.String, System.String)

GetPasswordChangedDate(String)

Declaration

public override DateTime GetPasswordChangedDate(string userName)

Parameters

Type	Name	Description
System.String	userName

Returns

Type	Description
System.DateTime

Overrides

WebMatrix.WebData.ExtendedMembershipProvider.GetPasswordChangedDate(System.String)

GetPasswordFailuresSinceLastSuccess(String)

Declaration

public override int GetPasswordFailuresSinceLastSuccess(string userName)

Parameters

Type	Name	Description
System.String	userName

Returns

Type	Description
System.Int32

Overrides

WebMatrix.WebData.ExtendedMembershipProvider.GetPasswordFailuresSinceLastSuccess(System.String)

GetUser(Object, Boolean)

Declaration

public override MembershipUser GetUser(object providerUserKey, bool userIsOnline)

Parameters

Type	Name	Description
System.Object	providerUserKey
System.Boolean	userIsOnline

Returns

Type	Description
System.Web.Security.MembershipUser

Overrides

System.Web.Security.MembershipProvider.GetUser(System.Object, System.Boolean)

GetUser(String, Boolean)

Declaration

public override MembershipUser GetUser(string username, bool userIsOnline)

Parameters

Type	Name	Description
System.String	username
System.Boolean	userIsOnline

Returns

Type	Description
System.Web.Security.MembershipUser

Overrides

System.Web.Security.MembershipProvider.GetUser(System.String, System.Boolean)

GetUserId(String)

Gets the id of the specified user.

Declaration

public int GetUserId(string userName)

Parameters

Type	Name	Description
System.String	userName	The name of the user.

Returns

Type	Description
System.Int32	An integer representing the id of the user.

GetUserIdFromOAuth(String, String)

Declaration

public override int GetUserIdFromOAuth(string provider, string providerUserId)

Parameters

Type	Name	Description
System.String	provider
System.String	providerUserId

Returns

Type	Description
System.Int32

Overrides

WebMatrix.WebData.ExtendedMembershipProvider.GetUserIdFromOAuth(System.String, System.String)

GetUserIdFromPasswordResetToken(String)

Declaration

public override int GetUserIdFromPasswordResetToken(string token)

Parameters

Type	Name	Description
System.String	token

Returns

Type	Description
System.Int32

Overrides

WebMatrix.WebData.ExtendedMembershipProvider.GetUserIdFromPasswordResetToken(System.String)

GetUserNameByEmail(String)

Declaration

public override string GetUserNameByEmail(string email)

Parameters

Type	Name	Description
System.String	email

Returns

Type	Description
System.String

Overrides

System.Web.Security.MembershipProvider.GetUserNameByEmail(System.String)

GetUserNameFromId(Int32)

Declaration

public override string GetUserNameFromId(int userId)

Parameters

Type	Name	Description
System.Int32	userId

Returns

Type	Description
System.String

Overrides

WebMatrix.WebData.ExtendedMembershipProvider.GetUserNameFromId(System.Int32)

HasLocalAccount(Int32)

Declaration

public override bool HasLocalAccount(int userId)

Parameters

Type	Name	Description
System.Int32	userId

Returns

Type	Description
System.Boolean

Overrides

WebMatrix.WebData.ExtendedMembershipProvider.HasLocalAccount(System.Int32)

Initialize(String, NameValueCollection)

Declaration

public override void Initialize(string name, NameValueCollection config)

Parameters

Type	Name	Description
System.String	name
System.Collections.Specialized.NameValueCollection	config

Overrides

System.Configuration.Provider.ProviderBase.Initialize(System.String, System.Collections.Specialized.NameValueCollection)

IsConfirmed(String)

Declaration

public override bool IsConfirmed(string userName)

Parameters

Type	Name	Description
System.String	userName

Returns

Type	Description
System.Boolean

Overrides

WebMatrix.WebData.ExtendedMembershipProvider.IsConfirmed(System.String)

ReplaceOAuthRequestTokenWithAccessToken(String, String, String)

Declaration

public override void ReplaceOAuthRequestTokenWithAccessToken(string requestToken, string accessToken, string accessTokenSecret)

Parameters

Type	Name	Description
System.String	requestToken
System.String	accessToken
System.String	accessTokenSecret

Overrides

WebMatrix.WebData.ExtendedMembershipProvider.ReplaceOAuthRequestTokenWithAccessToken(System.String, System.String, System.String)

ResetPassword(String, String)

Declaration

public override string ResetPassword(string username, string answer)

Parameters

Type	Name	Description
System.String	username
System.String	answer

Returns

Type	Description
System.String

Overrides

System.Web.Security.MembershipProvider.ResetPassword(System.String, System.String)

ResetPasswordWithToken(String, String)

Declaration

public override bool ResetPasswordWithToken(string token, string newPassword)

Parameters

Type	Name	Description
System.String	token
System.String	newPassword

Returns

Type	Description
System.Boolean

Overrides

WebMatrix.WebData.ExtendedMembershipProvider.ResetPasswordWithToken(System.String, System.String)

StoreOAuthRequestToken(String, String)

Declaration

public override void StoreOAuthRequestToken(string requestToken, string requestTokenSecret)

Parameters

Type	Name	Description
System.String	requestToken
System.String	requestTokenSecret

Overrides

WebMatrix.WebData.ExtendedMembershipProvider.StoreOAuthRequestToken(System.String, System.String)

UnlockUser(String)

Declaration

public override bool UnlockUser(string userName)

Parameters

Type	Name	Description
System.String	userName

Returns

Type	Description
System.Boolean

Overrides

System.Web.Security.MembershipProvider.UnlockUser(System.String)

UpdateUser(MembershipUser)

Declaration

public override void UpdateUser(MembershipUser user)

Parameters

Type	Name	Description
System.Web.Security.MembershipUser	user

Overrides

System.Web.Security.MembershipProvider.UpdateUser(System.Web.Security.MembershipUser)

ValidateUser(String, String)

Declaration

public override bool ValidateUser(string username, string password)

Parameters

Type	Name	Description
System.String	username
System.String	password

Returns

Type	Description
System.Boolean

Overrides

System.Web.Security.MembershipProvider.ValidateUser(System.String, System.String)