MySQL Connector/Net Developer Guide
iv
5.14 Handling Date and Time Information in Connector/Net ...................................................... 104
5.14.1 Fractional Seconds ............................................................................................... 104
5.14.2 Problems when Using Invalid Dates ...................................................................... 105
5.14.3 Restricting Invalid Dates ....................................................................................... 105
5.14.4 Handling Invalid Dates ......................................................................................... 105
5.14.5 Handling NULL Dates ........................................................................................... 106
5.15 Using the MySqlBulkLoader Class ................................................................................... 106
5.16 Using the MySQL Connector/Net Trace Source Object ..................................................... 108
5.16.1 Viewing MySQL Trace Information ........................................................................ 109
5.16.2 Building Custom Listeners .................................................................................... 111
5.17 Binary/Nonbinary Issues .................................................................................................. 113
5.18 Character Set Considerations for Connector/Net ............................................................... 113
5.19 Using Connector/Net with Crystal Reports ........................................................................ 114
5.19.1 Creating a Data Source ........................................................................................ 114
5.19.2 Creating the Report .............................................................................................. 115
5.19.3 Displaying the Report ........................................................................................... 116
5.20 ASP.NET Provider Model ................................................................................................ 119
5.21 Working with Partial Trust / Medium Trust ........................................................................ 121
5.21.1 Evolution of Partial Trust Support Across Connector/Net Versions ........................... 121
5.21.2 Configuring Partial Trust with Connector/Net Library Installed in GAC ...................... 122
5.21.3 Configuring Partial Trust with Connector/Net Library Not Installed in GAC ................ 124
6 Connector/Net Connection String Options Reference .................................................................... 127
7 Connector/Net Support for Windows Store .................................................................................... 135
8 EF5 Support ................................................................................................................................ 137
9 EF6 Support ................................................................................................................................ 141
10 Connector/Net API Reference .................................................................................................... 147
10.1 MySql.Data.MySqlClient Namespace ............................................................................... 147
10.1.1 MySql.Data.MySqlClientHierarchy ......................................................................... 149
10.1.2 BaseCommandInterceptor Class ........................................................................... 149
10.1.3 BaseExceptionInterceptor Class ............................................................................ 149
10.1.4 MySqlCommand Class ......................................................................................... 150
10.1.5 MySqlCommandBuilder Class ............................................................................... 158
10.1.6 MySqlConnection Class ........................................................................................ 165
10.1.7 MySqlDataAdapter Class ...................................................................................... 173
10.1.8 MySqlDataReader Class ....................................................................................... 180
10.1.9 MySqlDbType Enumeration .................................................................................. 199
10.1.10 MySqlError Class ............................................................................................... 201
10.1.11 MySqlErrorCode Enumeration ............................................................................. 204
10.1.12 MySqlException Class ........................................................................................ 205
10.1.13 MySqlHelper Class ............................................................................................. 206
10.1.14 MySqlInfoMessageEventArgs Class .................................................................... 217
10.1.15 MySqlInfoMessageEventHandler Delegate ........................................................... 219
10.1.16 MySqlParameter Class ....................................................................................... 220
10.1.17 MySqlParameterCollection Class ......................................................................... 230
10.1.18 MySqlRowUpdatedEventArgs Class .................................................................... 244
10.1.19 MySqlRowUpdatedEventHandler Delegate ........................................................... 246
10.1.20 MySqlRowUpdatingEventArgs Class .................................................................... 247
10.1.21 MySqlRowUpdatingEventHandler Delegate .......................................................... 249
10.1.22 MySqlTransaction Class ..................................................................................... 250
10.2 MySql.Data.Types Namespace ........................................................................................ 252
10.2.1 MySql.Data.TypesHierarchy .................................................................................. 253
10.2.2 MySqlConversionException Class ......................................................................... 253
10.2.3 MySqlDateTime Structure ..................................................................................... 255
10.3 MySql.Data.MySqlClient.Memcached Namespace ............................................................ 260
