MySQL Connector/Net

Users Guide
Visual Studio Integration
Installation
Programming
Connection Options
Tutorial
Support
Versions
Reference
MySql.Data.MySqlClient Namespace
MySqlBulkLoader Class
MySqlBulkLoader Members
MySqlBulkLoader Constructor
MySqlBulkLoader Methods
Load Method
MySqlBulkLoader Properties
CharacterSet Property
Columns Property
ConflictOption Property
Connection Property
EscapeCharacter Property
Expressions Property
FieldQuotationCharacter Property
FieldQuotationOptional Property
FieldTerminator Property
FileName Property
LinePrefix Property
LineTerminator Property
Local Property
NumberOfLinesToSkip Property
Priority Property
TableName Property
Timeout Property
MySqlBulkLoaderConflictOption Enumeration
MySqlBulkLoaderPriority Enumeration
MySqlCertificateStoreLocation Enumeration
MySqlClientFactory Class
MySqlClientFactory Members
MySqlClientFactory Constructor
MySqlClientFactory Fields
Instance Field
MySqlClientFactory Methods
CreateCommand Method
CreateCommandBuilder Method
CreateConnection Method
CreateConnectionStringBuilder Method
CreateDataAdapter Method
CreateParameter Method
MySqlClientFactory Properties
CanCreateDataSourceEnumerator Property
MySqlCommand Class
MySqlCommand Members
MySqlCommand Constructor
MySqlCommand Constructor
MySqlCommand Constructor (String)
MySqlCommand Constructor (String, MySqlConnection)
MySqlCommand Constructor (String, MySqlConnection, MySqlTransaction)
MySqlCommand Methods
BeginExecuteNonQuery Method
BeginExecuteNonQuery Method
BeginExecuteNonQuery Method (AsyncCallback, Object)
BeginExecuteReader Method
BeginExecuteReader Method
BeginExecuteReader Method (CommandBehavior)
Cancel Method
Clone Method
CreateParameter Method
Dispose Method
EndExecuteNonQuery Method
EndExecuteReader Method
ExecuteNonQuery Method
ExecuteReader Method
ExecuteReader Method
ExecuteReader Method (CommandBehavior)
ExecuteScalar Method
MemberwiseClone Method
Prepare Method
MySqlCommand Properties
CommandText Property
CommandTimeout Property
CommandType Property
Connection Property
DesignTimeVisible Property
IsPrepared Property
LastInsertedId Property
Parameters Property
Transaction Property
UpdatedRowSource Property
MySqlCommand Events
MySqlCommandBuilder Class
MySqlCommandBuilder Members
MySqlCommandBuilder Constructor
MySqlCommandBuilder Constructor
MySqlCommandBuilder Constructor (MySqlDataAdapter)
MySqlCommandBuilder Methods
DeriveParameters Method
Dispose Method
GetDeleteCommand Method
GetDeleteCommand Method
GetInsertCommand Method
GetInsertCommand Method
GetParameterName Method
GetUpdateCommand Method
GetUpdateCommand Method
MemberwiseClone Method
QuoteIdentifier Method
UnquoteIdentifier Method
MySqlCommandBuilder Properties
DataAdapter Property
MySqlCommandBuilder Events
MySqlConnection Class
MySqlConnection Members
MySqlConnection Constructor
MySqlConnection Constructor
MySqlConnection Constructor (String)
MySqlConnection Methods
BeginTransaction Method
BeginTransaction Method
BeginTransaction Method (IsolationLevel)
CancelQuery Method
ChangeDatabase Method
ClearAllPools Method
ClearPool Method
Clone Method
Close Method
CreateCommand Method
Dispose Method
EnlistTransaction Method
EnlistTransaction Method (Transaction)
GetSchema Method
GetSchema Method
GetSchema Method (String)
GetSchema Method (String, String[])
MemberwiseClone Method
Open Method
Ping Method
MySqlConnection Properties
ConnectionString Property
ConnectionTimeout Property
Database Property
DataSource Property
ServerThread Property
ServerVersion Property
State Property
UseCompression Property
MySqlConnection Events
InfoMessage Event
MySqlConnectionProtocol Enumeration
MySqlConnectionStringBuilder Class
MySqlConnectionStringBuilder Members
MySqlConnectionStringBuilder Constructor
MySqlConnectionStringBuilder Constructor
MySqlConnectionStringBuilder Constructor (String)
MySqlConnectionStringBuilder Methods
Clear Method
GetConnectionString Method
Remove Method
TryGetValue Method
MySqlConnectionStringBuilder Properties
AllowBatch Property
AllowUserVariables Property
AllowZeroDateTime Property
AutoEnlist Property
BlobAsUTF8ExcludePattern Property
BlobAsUTF8IncludePattern Property
CertificateFile Property
CertificatePassword Property
CertificateStoreLocation Property
CertificateThumbprint Property
CharacterSet Property
ConnectionLifeTime Property
ConnectionProtocol Property
ConnectionReset Property
ConnectionTimeout Property
ConvertZeroDateTime Property
Database Property
DefaultCommandTimeout Property
FunctionsReturnString Property
IgnorePrepare Property
InteractiveSession Property
Item Property
Keepalive Property
Logging Property
MaximumPoolSize Property
MinimumPoolSize Property
OldGuids Property
Password Property
PersistSecurityInfo Property
PipeName Property
Pooling Property
Port Property
ProcedureCacheSize Property
RespectBinaryFlags Property
Server Property
SharedMemoryName Property
SslMode Property
TreatBlobsAsUTF8 Property
TreatTinyAsBoolean Property
UseAffectedRows Property
UseCompression Property
UseOldSyntax Property
UsePerformanceMonitor Property
UseProcedureBodies Property
UserID Property
UseUsageAdvisor Property
MySqlDataAdapter Class
MySqlDataAdapter Members
MySqlDataAdapter Constructor
MySqlDataAdapter Constructor
MySqlDataAdapter Constructor (MySqlCommand)
MySqlDataAdapter Constructor (String, MySqlConnection)
MySqlDataAdapter Constructor (String, String)
MySqlDataAdapter Methods
Dispose Method
Fill Method
FillSchema Method
MemberwiseClone Method
Update Method
MySqlDataAdapter Properties
DeleteCommand Property
InsertCommand Property
SelectCommand Property
UpdateBatchSize Property
UpdateCommand Property
MySqlDataAdapter Events
RowUpdated Event
RowUpdating Event
MySqlDataReader Class
MySqlDataReader Members
MySqlDataReader Methods
Close Method
Dispose Method
GetBoolean Method
GetBoolean Method (Int32)
GetBoolean Method (String)
GetByte Method
GetByte Method (Int32)
GetByte Method (String)
GetBytes Method
GetChar Method
GetChar Method (Int32)
GetChar Method (String)
GetChars Method
GetDataTypeName Method
GetDateTime Method
GetDateTime Method (Int32)
GetDateTime Method (String)
GetDecimal Method
GetDecimal Method (Int32)
GetDecimal Method (String)
GetDouble Method
GetDouble Method (Int32)
GetDouble Method (String)
GetEnumerator Method
GetFieldType Method
GetFloat Method
GetFloat Method (Int32)
GetFloat Method (String)
GetGuid Method
GetGuid Method (Int32)
GetGuid Method (String)
GetInt16 Method
GetInt16 Method (Int32)
GetInt16 Method (String)
GetInt32 Method
GetInt32 Method (Int32)
GetInt32 Method (String)
GetInt64 Method
GetInt64 Method (Int32)
GetInt64 Method (String)
GetMySqlDateTime Method
GetMySqlDateTime Method (Int32)
GetMySqlDateTime Method (String)
GetMySqlDecimal Method
GetMySqlDecimal Method (Int32)
GetMySqlDecimal Method (String)
GetName Method
GetOrdinal Method
GetSByte Method
GetSByte Method (Int32)
GetSByte Method (String)
GetSchemaTable Method
GetString Method
GetString Method (Int32)
GetString Method (String)
GetTimeSpan Method
GetTimeSpan Method (Int32)
GetTimeSpan Method (String)
GetUInt16 Method
GetUInt16 Method (Int32)
GetUInt16 Method (String)
GetUInt32 Method
GetUInt32 Method (Int32)
GetUInt32 Method (String)
GetUInt64 Method
GetUInt64 Method (Int32)
GetUInt64 Method (String)
GetValue Method
GetValues Method
IsDBNull Method
MemberwiseClone Method
NextResult Method
Read Method
MySqlDataReader Properties
Depth Property
FieldCount Property
HasRows Property
IsClosed Property
Item Property
Item Property (Int32)
Item Property (String)
RecordsAffected Property
MySqlDbType Enumeration
MySqlDriverType Enumeration
MySqlError Class
MySqlError Members
MySqlError Constructor
MySqlError Methods
MySqlError Properties
Code Property
Level Property
Message Property
MySqlErrorCode Enumeration
MySqlException Class
MySqlException Members
MySqlException Methods
MySqlException Properties
Number Property
MySqlHelper Class
MySqlHelper Members
MySqlHelper Methods
DoubleQuoteString Method
EscapeString Method
ExecuteDataRow Method
ExecuteDataset Method
ExecuteDataset Method (MySqlConnection, String)
ExecuteDataset Method (String, String)
ExecuteDataset Method (MySqlConnection, String, MySqlParameter[])
ExecuteDataset Method (String, String, MySqlParameter[])
ExecuteNonQuery Method
ExecuteNonQuery Method (MySqlConnection, String, MySqlParameter[])
ExecuteNonQuery Method (String, String, MySqlParameter[])
ExecuteReader Method
ExecuteReader Method (String, String)
ExecuteReader Method (String, String, MySqlParameter[])
ExecuteScalar Method
ExecuteScalar Method (MySqlConnection, String)
ExecuteScalar Method (String, String)
ExecuteScalar Method (MySqlConnection, String, MySqlParameter[])
ExecuteScalar Method (String, String, MySqlParameter[])
UpdateDataSet Method
MySqlInfoMessageEventArgs Class
MySqlInfoMessageEventArgs Members
MySqlInfoMessageEventArgs Constructor
MySqlInfoMessageEventArgs Fields
errors Field
MySqlInfoMessageEventArgs Methods
MySqlInfoMessageEventHandler Delegate
MySqlParameter Class
MySqlParameter Members
MySqlParameter Constructor
MySqlParameter Constructor
MySqlParameter Constructor (String, MySqlDbType, Int32, ParameterDirection, Boolean, Byte, Byte, String, DataRowVersion, Object)
MySqlParameter Constructor (String, MySqlDbType)
MySqlParameter Constructor (String, Object)
MySqlParameter Constructor (String, MySqlDbType, Int32)
MySqlParameter Constructor (String, MySqlDbType, Int32, String)
MySqlParameter Methods
Clone Method
MemberwiseClone Method
ResetDbType Method
ToString Method
MySqlParameter Properties
DbType Property
Direction Property
IsNullable Property
MySqlDbType Property
ParameterName Property
PossibleValues Property
Precision Property
Scale Property
Size Property
SourceColumn Property
SourceColumnNullMapping Property
SourceVersion Property
Value Property
MySqlParameterCollection Class
MySqlParameterCollection Members
MySqlParameterCollection Methods
Add Method
Add Method (MySqlParameter)
Add Method (Object)
Add Method (String, MySqlDbType)
Add Method (String, Object)
Add Method (String, MySqlDbType, Int32)
Add Method (String, MySqlDbType, Int32, String)
AddRange Method
AddWithValue Method
Clear Method
Contains Method
Contains Method (Object)
Contains Method (String)
CopyTo Method
GetEnumerator Method
GetParameter Method
IndexOf Method
IndexOf Method (Object)
IndexOf Method (String)
Insert Method
MemberwiseClone Method
Remove Method
RemoveAt Method
RemoveAt Method (Int32)
RemoveAt Method (String)
SetParameter Method
MySqlParameterCollection Properties
Count Property
IsFixedSize Property
IsReadOnly Property
IsSynchronized Property
Item Property
Item Property (Int32)
Item Property (String)
SyncRoot Property
MySqlRowUpdatedEventArgs Class
MySqlRowUpdatedEventArgs Members
MySqlRowUpdatedEventArgs Constructor
MySqlRowUpdatedEventArgs Methods
CopyToRows Method
MySqlRowUpdatedEventArgs Properties
Command Property
MySqlRowUpdatedEventHandler Delegate
MySqlRowUpdatingEventArgs Class
MySqlRowUpdatingEventArgs Members
MySqlRowUpdatingEventArgs Constructor
MySqlRowUpdatingEventArgs Methods
MySqlRowUpdatingEventArgs Properties
Command Property
MySqlRowUpdatingEventHandler Delegate
MySqlScript Class
MySqlScript Members
MySqlScript Constructor
MySqlScript Constructor
MySqlScript Constructor (MySqlConnection)
MySqlScript Constructor (String)
MySqlScript Constructor (MySqlConnection, String)
MySqlScript Methods
Execute Method
MySqlScript Properties
Connection Property
Delimiter Property
Query Property
MySqlScript Events
Error Event
ScriptCompleted Event
StatementExecuted Event
MySqlScriptErrorEventArgs Class
MySqlScriptErrorEventArgs Members
MySqlScriptErrorEventArgs Constructor
MySqlScriptErrorEventArgs Methods
MySqlScriptErrorEventArgs Properties
Exception Property
Ignore Property
MySqlScriptErrorEventHandler Delegate
MySqlScriptEventArgs Class
MySqlScriptEventArgs Members
MySqlScriptEventArgs Constructor
MySqlScriptEventArgs Methods
MySqlScriptEventArgs Properties
Line Property
Position Property
StatementText Property
MySqlSslMode Enumeration
MySqlStatementExecutedEventHandler Delegate
MySqlTrace Class
MySqlTrace Members
MySqlTrace Constructor
MySqlTrace Methods
MySqlTrace Properties
Listeners Property
Switch Property
MySqlTraceEventType Enumeration
MySqlTransaction Class
MySqlTransaction Members
MySqlTransaction Methods
Commit Method
Dispose Method
MemberwiseClone Method
Rollback Method
MySqlTransaction Properties
Connection Property
IsolationLevel Property
UsageAdvisorWarningFlags Enumeration
MySql.Data.MySqlClient.Properties Namespace
Resources Class
Resources Members
Resources Methods
Resources Properties
AdapterIsNull Property
AdapterSelectIsNull Property
AttemptToAccessBeforeRead Property
BadVersionFormat Property
BufferCannotBeNull Property
BufferNotLargeEnough Property
CancelNeeds50 Property
CancelNotSupported Property
CBMultiTableNotSupported Property
CBNoKeyColumn Property
ChaosNotSupported Property
CommandTextNotInitialized Property
ConnectionAlreadyOpen Property
ConnectionBroken Property
ConnectionMustBeOpen Property
ConnectionNotOpen Property
ConnectionNotSet Property
CouldNotFindColumnName Property
CountCannotBeNegative Property
CSNoSetLength Property
Culture Property
DataNotInSupportedFormat Property
DataReaderOpen Property
DefaultEncodingNotFound Property
DistributedTxnNotSupported Property
ErrorCreatingSocket Property
FatalErrorDuringExecute Property
FatalErrorDuringRead Property
FatalErrorReadingResult Property
FromAndLengthTooBig Property
FromIndexMustBeValid Property
GetHostEntryFailed Property
HardProcQuery Property
ImproperValueFormat Property
IncorrectTransmission Property
IndexAndLengthTooBig Property
IndexMustBeValid Property
InvalidColumnOrdinal Property
InvalidConnectionStringValue Property
InvalidProcName Property
InvalidValueForBoolean Property
KeywordNoNull Property
KeywordNotSupported Property
keywords Property
MoreThanOneOPRow Property
MultipleConnectionsInTransactionNotSupported Property
NamedPipeNoSeek Property
NamedPipeNoSetLength Property
NextResultIsClosed Property
NoBodiesAndTypeNotSet Property
NoNestedTransactions Property
NoServerSSLSupport Property
ObjectDisposed Property
OffsetCannotBeNegative Property
OffsetMustBeValid Property
ParameterAlreadyDefined Property
ParameterCannotBeNegative Property
ParameterCannotBeNull Property
ParameterIsInvalid Property
ParameterMustBeDefined Property
ParameterNotFoundDuringPrepare Property
PasswordMustHaveLegalChars Property
PerfMonCategoryHelp Property
PerfMonCategoryName Property
PerfMonHardProcHelp Property
PerfMonHardProcName Property
PerfMonSoftProcHelp Property
PerfMonSoftProcName Property
ProcAndFuncSameName Property
QueryTooLarge Property
ReadFromStreamFailed Property
ReadingPriorColumnUsingSeqAccess Property
ResourceManager Property
RoutineNotFound Property
ServerTooOld Property
SocketNoSeek Property
SoftProcQuery Property
SPNotSupported Property
StreamAlreadyClosed Property
StreamNoRead Property
StreamNoWrite Property
Timeout Property
TimeoutGettingConnection Property
TraceCloseConnection Property
TraceErrorMoreThanMaxValueConnections Property
TraceFetchError Property
TraceOpenConnection Property
TraceOpenResultError Property
TraceQueryDone Property
TraceQueryNormalized Property
TraceQueryOpened Property
TraceResult Property
TraceResultClosed Property
TraceSetDatabase Property
TraceStatementClosed Property
TraceStatementExecuted Property
TraceStatementPrepared Property
TraceUAWarningBadIndex Property
TraceUAWarningFieldConversion Property
TraceUAWarningNoIndex Property
TraceUAWarningSkippedColumns Property
TraceUAWarningSkippedRows Property
TraceWarning Property
UnableToConnectToHost Property
UnableToDeriveParameters Property
UnableToEnumerateUDF Property
UnableToExecuteSP Property
UnableToParseFK Property
UnableToRetrieveParameters Property
UnableToRetrieveSProcData Property
UnableToStartSecondAsyncOp Property
UnixSocketsNotSupported Property
ValueNotSupportedForGuid Property
WriteToStreamFailed Property
WrongParameterName Property
MySql.Data.Types Namespace
MySqlConversionException Class
MySqlConversionException Members
MySqlConversionException Constructor
MySqlConversionException Methods
MySqlConversionException Properties
MySqlDateTime Structure
MySqlDateTime Members
MySqlDateTime Constructor
MySqlDateTime Constructor (MySqlDateTime)
MySqlDateTime Constructor (DateTime)
MySqlDateTime Constructor (String)
MySqlDateTime Constructor (Int32, Int32, Int32, Int32, Int32, Int32)
MySqlDateTime Methods
Explicit Operator
GetDateTime Method
ToString Method
MySqlDateTime Properties
Day Property
Hour Property
IsNull Property
IsValidDateTime Property
Millisecond Property
Minute Property
Month Property
Second Property
Value Property
Year Property
MySqlDecimal Structure
MySqlDecimal Members
MySqlDecimal Methods
ToDouble Method
ToString Method
MySqlDecimal Properties
IsNull Property
Precision Property
Scale Property
Value Property
MySql.Web.Common Namespace
SchemaManager Class
SchemaManager Members
SchemaManager Properties
Version Property
MySql.Web.Profile Namespace
MySQLProfileProvider Class
MySQLProfileProvider Members
MySQLProfileProvider Constructor
MySQLProfileProvider Methods
DeleteInactiveProfiles Method
DeleteProfiles Method
DeleteProfiles Method (String[])
DeleteProfiles Method (ProfileInfoCollection)
FindInactiveProfilesByUserName Method
FindProfilesByUserName Method
GetAllInactiveProfiles Method
GetAllProfiles Method
GetNumberOfInactiveProfiles Method
GetPropertyValues Method
Initialize Method
SetPropertyValues Method
MySQLProfileProvider Properties
ApplicationName Property
MySql.Web.Properties Namespace
Resources Class
Resources Members
Resources Methods
Resources Properties
CannotDeleteAPopulatedRole Property
CannotRetrieveHashedPasswords Property
CannotUnencodeHashedPwd Property
ChangePasswordCanceled Property
Culture Property
ErrorInitOfMembershipProvider Property
ErrorInitOfRoleProvider Property
ErrorInitProfileProvider Property
ErrorResettingPassword Property
IllegalRoleName Property
IllegalUserName Property
IncorrectPasswordAnswer Property
InvalidCharactersInUserName Property
MissingOrWrongSchema Property
MonoDoesNotSupportHash Property
NewPasswordValidationFailed Property
NotEnoughNonAlphaNumericInPwd Property
PasswordAnswerInvalid Property
PasswordNotLongEnough Property
PasswordQuestionInvalid Property
PasswordRequiredForReset Property
PasswordResetCanceledNotValid Property
PasswordResetNotEnabled Property
PasswordRetrievalNotEnabled Property
ProfileUpdateFailed Property
ResourceManager Property
RoleNameAlreadyExists Property
RoleNameNotFound Property
schema1 Property
schema2 Property
schema3 Property
schema4 Property
schema5 Property
schema6 Property
UnableToCreateApplication Property
UnableToCreateUser Property
UnableToLockOutUser Property
UnableToRetrieveProfileData Property
UnableToUpdateFailureCount Property
UnsupportedPasswordFormat Property
UserIsAlreadyInRole Property
UserIsLockedOut Property
UsernameNotFound Property
UserNotInRole Property
ValidatePasswordCanceled Property
MySql.Web.Security Namespace
MySQLMembershipProvider Class
MySQLMembershipProvider Members
MySQLMembershipProvider Constructor
MySQLMembershipProvider Methods
ChangePassword Method
ChangePasswordQuestionAndAnswer Method
CreateUser Method
DeleteUser Method
FindUsersByEmail Method
FindUsersByName Method
GetAllUsers Method
GetNumberOfUsersOnline Method
GetPassword Method
GetUser Method
GetUser Method (Object, Boolean)
GetUser Method (String, Boolean)
GetUserNameByEmail Method
Initialize Method
ResetPassword Method
UnlockUser Method
UpdateUser Method
ValidateUser Method
MySQLMembershipProvider Properties
ApplicationName Property
EnablePasswordReset Property
EnablePasswordRetrieval Property
MaxInvalidPasswordAttempts Property
MinRequiredNonAlphanumericCharacters Property
MinRequiredPasswordLength Property
PasswordAttemptWindow Property
PasswordFormat Property
PasswordStrengthRegularExpression Property
RequiresQuestionAndAnswer Property
RequiresUniqueEmail Property
WriteExceptionsToEventLog Property
MySQLMembershipProvider Events
MySQLRoleProvider Class
MySQLRoleProvider Members
MySQLRoleProvider Constructor
MySQLRoleProvider Methods
AddUsersToRoles Method
CreateRole Method
DeleteRole Method
FindUsersInRole Method
GetAllRoles Method
GetRolesForUser Method
GetUsersInRole Method
Initialize Method
IsUserInRole Method
RemoveUsersFromRoles Method
RoleExists Method
MySQLRoleProvider Properties
ApplicationName Property
WriteExceptionsToEventLog Property
MySql.Web.SessionState Namespace
MySqlSessionStateStore Class
MySqlSessionStateStore Members
MySqlSessionStateStore Constructor
MySqlSessionStateStore Methods
CreateNewStoreData Method
CreateUninitializedItem Method
Dispose Method
EndRequest Method
GetItem Method
GetItemExclusive Method
Initialize Method
InitializeRequest Method
ReleaseItemExclusive Method
RemoveItem Method
ResetItemTimeout Method
SetAndReleaseItemExclusive Method
SetItemExpireCallback Method
MySqlSessionStateStore Properties
ApplicationName Property
WriteExceptionsToEventLog Property

MySQL Connector/Net

MySQL Connector/Net

Table of contents

Get in touch