MySQL Connector-Net Developer Guide(2014.04)

【实例截图】

【核心代码】

Table of Contents
Preface and Legal Notices ........................................................................................................... vii
1 Introduction to MySQL Connector/Net ......................................................................................... 1
2 Connector/Net Versions ............................................................................................................. 3
3 Connector/Net Installation .......................................................................................................... 7
3.1 Installing Connector/Net on Windows ............................................................................... 7
3.1.1 Installing Connector/Net Using the Installer ............................................................ 7
3.1.2 Installing Connector/Net Using the Zip Packages ................................................. 12
3.2 Installing Connector/Net on Unix with Mono .................................................................... 13
3.3 Installing Connector/Net from the Source Code .............................................................. 14
4 Connector/Net Visual Studio Integration .................................................................................... 15
4.1 Installing and Configuring .............................................................................................. 15
4.2 Making a Connection .................................................................................................... 17
4.3 The MySQL Toolbar ...................................................................................................... 19
4.4 Using IntelliSense in the SQL Editor .............................................................................. 20
4.5 Editing Tables ............................................................................................................... 20
4.5.1 Column Editor .................................................................................................... 22
4.5.2 Editing Indexes ................................................................................................... 23
4.5.3 Editing Foreign Keys .......................................................................................... 23
4.5.4 Column Properties .............................................................................................. 24
4.5.5 Table Properties ................................................................................................. 25
4.6 Editing Views ................................................................................................................ 27
4.7 Editing Stored Procedures and Functions ....................................................................... 29
4.8 Editing Triggers ............................................................................................................. 31
4.9 Editing User Defined Functions (UDF) ............................................................................ 32
4.10 Debugging Stored Procedures and Functions ............................................................... 33
4.11 Cloning Database Objects ........................................................................................... 42
4.12 Dropping Database Objects ......................................................................................... 42
4.13 Using the ADO.NET Entity Framework ......................................................................... 42
4.14 MySQL Website Configuration Tool .............................................................................. 43
4.15 MySQL SQL Editor ...................................................................................................... 47
4.16 MySQL Data Export Tool ............................................................................................. 49
4.17 DDL T4 Template Macro ............................................................................................. 55
5 Connector/Net Tutorials ............................................................................................................ 57
5.1 Tutorial: An Introduction to Connector/Net Programming ................................................. 57
5.1.1 The MySqlConnection Object .............................................................................. 57
5.1.2 The MySqlCommand Object ............................................................................... 58
5.1.3 Working with Decoupled Data ............................................................................. 60
5.1.4 Working with Parameters .................................................................................... 63
5.1.5 Working with Stored Procedures ......................................................................... 65
5.2 Tutorial: MySQL Connector/Net ASP.NET Membership and Role Provider ........................ 66
5.3 Tutorial: MySQL Connector/Net ASP.NET Session State Provider .................................... 71
5.4 Tutorial: MySQL Connector/Net ASP.NET Profile Provider ............................................... 73
5.5 Tutorial: Using an Entity Framework Entity as a Windows Forms Data Source .................. 75
5.6 Tutorial: Databinding in ASP.NET Using LINQ on Entities ............................................... 87
5.7 Tutorial: Using SSL with MySQL Connector/Net .............................................................. 92
5.8 Tutorial: Using MySqlScript ............................................................................................ 94
5.8.1 Using Delimiters with MySqlScript ....................................................................... 95
5.9 Tutorial: Generating MySQL DDL from an Entity Framework Model .................................. 97
6 Connector/Net Programming ..................................................................................................... 99
6.1 Connecting to MySQL Using Connector/Net ................................................................. 100
6.2 Creating a Connector/Net Connection String ................................................................. 100
6.2.1 Opening a Connection ...................................................................................... 100
6.2.2 Handling Connection Errors .............................................................................. 102
6.2.3 Using GetSchema on a Connection ................................................................... 103
6.3 Using MySqlCommand ................................................................................................ 105
MySQL Connector/Net Developer Guide
iv
6.4 Using Connector/Net with Connection Pooling .............................................................. 106
6.5 Using the Windows Native Authentication Plugin ........................................................... 106
6.6 Writing a Custom Authentication Plugin ........................................................................ 107
6.7 Using Connector/Net with Table Caching ...................................................................... 110
6.8 Using the Connector/Net with Prepared Statements ...................................................... 111
6.8.1 Preparing Statements in Connector/Net ............................................................. 111
6.9 Accessing Stored Procedures with Connector/Net ......................................................... 112
6.9.1 Using Stored Routines from Connector/Net ........................................................ 113
6.10 Handling BLOB Data With Connector/Net ................................................................... 115
6.10.1 Preparing the MySQL Server .......................................................................... 115
6.10.2 Writing a File to the Database ......................................................................... 116
6.10.3 Reading a BLOB from the Database to a File on Disk ....................................... 118
6.11 Using the Connector/Net Interceptor Classes .............................................................. 119
6.12 Handling Date and Time Information in Connector/Net ................................................. 121
6.12.1 Fractional Seconds ......................................................................................... 121
6.12.2 Problems when Using Invalid Dates ................................................................. 121
6.12.3 Restricting Invalid Dates .................................................................................. 121
6.12.4 Handling Invalid Dates .................................................................................... 122
6.12.5 Handling NULL Dates ..................................................................................... 122
6.13 Using the MySqlBulkLoader Class .......................................................................... 123
6.14 Using the MySQL Connector/Net Trace Source Object ................................................ 124
6.14.1 Viewing MySQL Trace Information ................................................................... 125
6.14.2 Building Custom Listeners ............................................................................... 128
6.15 Binary/Nonbinary Issues ............................................................................................ 129
6.16 Character Set Considerations for Connector/Net ......................................................... 130
6.17 Using Connector/Net with Crystal Reports .................................................................. 130
6.17.1 Creating a Data Source .................................................................................. 130
6.17.2 Creating the Report ........................................................................................ 132
6.17.3 Displaying the Report ...................................................................................... 132
6.18 ASP.NET Provider Model ........................................................................................... 135
6.19 Working with Partial Trust / Medium Trust ................................................................... 137
6.19.1 Evolution of Partial Trust Support Across Connector/Net Versions ..................... 137
6.19.2 Configuring Partial Trust with Connector/Net Library Installed in GAC ................. 138
6.19.3 Configuring Partial Trust with Connector/Net Library Not Installed in GAC ........... 139
7 Connector/Net Connection String Options Reference ............................................................... 141
8 Connector/Net Support for Windows Store .............................................................................. 149
9 EF 5 Support ......................................................................................................................... 151
10 EF 6 Support ....................................................................................................................... 155
11 Connector/Net API Reference ............................................................................................... 161
11.1 MySql.Data.MySqlClient Namespace .................................................................. 161
11.1.1 MySql.Data.MySqlClientHierarchy ........................................................ 162
11.1.2 BaseCommandInterceptor .......................................................................... 162
11.1.3 BaseExceptionInterceptor ...................................................................... 163
11.1.4 MySqlCommand Class .................................................................................... 163
11.1.5 MySqlCommandBuilder Class ....................................................................... 229
11.1.6 MySqlException Class ................................................................................ 247
11.1.7 MySqlHelper Class ...................................................................................... 248
11.1.8 MySqlErrorCode Enumeration ...................................................................... 259
11.2 MySql.Data.Types Namespace .............................................................................. 259
11.2.1 MySql.Data.TypesHierarchy .................................................................... 259
11.2.2 MySqlConversionException Class ............................................................. 260
11.2.3 MySqlDateTime Class .................................................................................. 261
12 Connector/Net Support ......................................................................................................... 303
12.1 Connector/Net Community Support ............................................................................ 303
12.2 How to Report Connector/Net Problems or Bugs ......................................................... 303
13 Connector/Net FAQ .............................................................................................................. 305
A Licenses for Third-Party Components ..................................................................................... 307
A.1 ANTLR 3.3 License ..................................................................................................... 307
MySQL Connector/Net Developer Guide
v
A.2 Bouncy Castle 1.7 License .......................................................................................... 308
A.3 RFC 3174 - US Secure Hash Algorithm 1 (SHA1) License ............................................ 308
A.4 zlib License ............................................................................................................. 309
A.5 ZLIB.NET License ....................................................................................................... 309