在好例子网,分享、交流、成长!
您当前所在位置:首页C# 开发实例C#数据库操作 → MySQL Connector-Net Developer Guide(2014.04)

MySQL Connector-Net Developer Guide(2014.04)

C#数据库操作

下载此实例
  • 开发语言:C#
  • 实例大小:4.29M
  • 下载次数:5
  • 浏览次数:54
  • 发布时间:2022-11-27
  • 实例类别:C#数据库操作
  • 发 布 人:ZSPINGGG
  • 文件格式:.pdf
  • 所需积分:2
 相关标签: Connect develop MySql GUIDE 2014

实例介绍

【实例简介】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

实例下载地址

MySQL Connector-Net Developer Guide(2014.04)

不能下载?内容有错? 点击这里报错 + 投诉 + 提问

好例子网口号:伸出你的我的手 — 分享

网友评论

发表评论

(您的评论需要经过审核才能显示)

查看所有0条评论>>

小贴士

感谢您为本站写下的评论,您的评论对其它用户来说具有重要的参考价值,所以请认真填写。

  • 类似“顶”、“沙发”之类没有营养的文字,对勤劳贡献的楼主来说是令人沮丧的反馈信息。
  • 相信您也不想看到一排文字/表情墙,所以请不要反馈意义不大的重复字符,也请尽量不要纯表情的回复。
  • 提问之前请再仔细看一遍楼主的说明,或许是您遗漏了。
  • 请勿到处挖坑绊人、招贴广告。既占空间让人厌烦,又没人会搭理,于人于己都无利。
;
报警