MySQL Connector/NET开发指南：安装配置与应用开发详解

需积分: 9 195 浏览量更新于2024-07-17 收藏 1.27MB PDF 举报

MySQL Connector/NET Developer Guide 是一份详尽的手册，旨在指导.NET开发者如何安装、配置和利用 MySQL Connector/NET 这一工具，以便于他们的应用程序与 MySQL 服务器进行有效的通信，并开发数据库应用。这份文档详细地介绍了如何设置这个连接器，包括其在不同版本（如社区版7.0和商业版7.0）中的使用方法以及许可证信息。首先，安装和配置部分将涵盖所需步骤，包括下载适当的二进制文件、依赖项管理、以及与操作系统和.NET框架兼容性的重要注意事项。指南可能还会涉及如何通过NuGet包管理器轻松集成到.NET项目中，确保应用程序能够无缝地与MySQL服务器进行数据交互。接下来，用户可以找到关于数据库连接、执行SQL查询、事务处理、存储过程调用等核心功能的详细介绍。这部分内容会涉及示例代码和最佳实践，帮助开发者理解如何在.NET环境中编写高效且安全的数据库操作代码。对于每个版本的 Connector/NET，文档会列出显著更改的日志，这些更新可能涉及到性能优化、新特性添加或已知问题的修复，这对于跟踪技术演进和维护兼容性至关重要。此外，手册还强调了法律方面的信息，包括版权许可条款。MySQL Connector/NET包含第三方软件，可能受到不同的开源或商业许可证约束。用户手册会提供关于社区版（如8.0系列）和商业版的许可证详细信息，以确保开发者了解并遵守相关规定。最后，指南推荐开发者在遇到使用问题时访问MySQL论坛，与其他MySQL用户交流，获取技术支持和解决方案。这表明MySQL提供了丰富的社区支持，以帮助开发者解决在开发过程中遇到的任何疑问。 MySQL Connector/NET Developer Guide 是一个全面的资源，不仅提供技术指导，还关注许可证和社区支持，确保.NET开发者能顺利构建基于MySQL的应用程序。

Installing Connector/NET from the Source Code

There is no installer available for installing the MySQL Connector/NET component on your Unix

installation. Before installing, ensure that you have a working Mono project installation. To test whether

your system has Mono installed, enter:

shell> mono --version

The version of the Mono JIT compiler is displayed.

To compile C# source code, make sure a Mono C# compiler is installed.

Note

There are three Mono C# compilers available: mcs, which accesses the 1.0-profile

libraries, gmcs, which accesses the 2.0-profile libraries, and dmcs, which accesses

the 4.0-profile libraries.

To install Connector/NET on Unix/Mono:

1. Download the mysql-connector-net-version-noinstall.zip and extract the contents to a

directory of your choice, for example: ~/connector-net/.

2. In the directory where you unzipped the connector to, change into the bin subdirectory. Ensure the file

MySql.Data.dll is present. This filename is case-sensitive.

3. You must register the Connector/NET component, MySql.Data, in the Global Assembly Cache (GAC).

In the current directory enter the gacutil command:

root-shell> gacutil /i MySql.Data.dll

This will register MySql.Data into the GAC. You can check this by listing the contents of /usr/lib/

mono/gac, where you will find MySql.Data if the registration has been successful.

You are now ready to compile your application. You must ensure that when you compile your application

you include the Connector/NET component using the -r: command-line option. For example:

shell> gmcs -r:System.dll -r:System.Data.dll -r:MySql.Data.dll HelloWorld.cs

The referenced assemblies depend on the requirements of the application, but applications using

Connector/NET must provide -r:MySql.Data at a minimum.

You can further check your installation by running the compiled program, for example:

shell> mono HelloWorld.exe

3.3 Installing Connector/NET from the Source Code

Source packages of MySQL Connector/NET are available for download from https://dev.mysql.com/

downloads/connector/net/.

The file contains the following folders:

• Documentation: Files to build the documentation into the compiled HTML (CHM) format.

• EntityFramework: Source files and test cases.

Chapter 4 Connector/NET Tutorials

Table of Contents

4.1 Tutorial: An Introduction to Connector/NET Programming ............................................................. 13

4.1.1 The MySqlConnection Object ........................................................................................... 13

4.1.2 The MySqlCommand Object ............................................................................................. 14

4.1.3 Working with Decoupled Data .......................................................................................... 17

4.1.4 Working with Parameters ................................................................................................. 20

4.1.5 Working with Stored Procedures ....................................................................................... 21

4.2 Tutorial: Connector/NET ASP.NET Membership and Role Provider ............................................... 23

4.3 Tutorial: Connector/NET ASP.NET Profile Provider ...................................................................... 26

4.4 Tutorial: Web Parts Personalization Provider ............................................................................... 28

4.5 Tutorial: Simple Membership Web Provider ................................................................................. 33

4.6 Tutorial: Using an Entity Framework Entity as a Windows Forms Data Source ............................... 37

4.7 Tutorial: Data Binding in ASP.NET Using LINQ on Entities ........................................................... 45

4.8 Tutorial: Generating MySQL DDL from an Entity Framework Model ............................................... 48

4.9 Tutorial: Basic CRUD Operations with Connector/NET ................................................................. 49

4.10 Tutorial: Configuring SSL with Connector/NET ........................................................................... 52

4.10.1 Using PEM Certificates in Connector/NET ....................................................................... 53

4.10.2 Using PFX Certificates in Connector/NET ....................................................................... 54

4.11 Tutorial: Using MySqlScript ....................................................................................................... 55

The following MySQL Connector/NET tutorials illustrate how to develop MySQL programs using

technologies such as Visual Studio, C#, ASP.NET, and the .NET, .NET Core, and Mono frameworks. Work

through the first tutorial to verify that you have the right software components installed and configured, then

choose other tutorials to try depending on the features you intend to use in your applications.

4.1 Tutorial: An Introduction to Connector/NET Programming

This section provides a gentle introduction to programming with MySQL Connector/NET. The code

example is written in C#, and is designed to work on both Microsoft .NET Framework and Mono.

This tutorial is designed to get you up and running with Connector/NET as quickly as possible, it does not

go into detail on any particular topic. However, the following sections of this manual describe each of the

topics introduced in this tutorial in more detail. In this tutorial you are encouraged to type in and run the

code, modifying it as required for your setup.

This tutorial assumes you have MySQL and Connector/NET already installed. It also assumes that you

have installed the world database sample, which can be downloaded from the MySQL Documentation

page. You can also find details on how to install the database on the same page.

Note

Before compiling the code example, make sure that you have added References to

your project as required. The References required are System, System.Data and

MySql.Data.

4.1.1 The MySqlConnection Object

For your MySQL Connector/NET application to connect to a MySQL database, it must establish a

connection by using a MySqlConnection object.

The MySqlCommand Object

The MySqlConnection constructor takes a connection string as one of its parameters. The connection

string provides necessary information to make the connection to the MySQL database. The connection

string is discussed more fully in Section 5.1, “Connecting to MySQL Using Connector/NET”. For a list

of supported connection string options, see Chapter 6, Connector/NET 6.10 Connection-String Options

Reference.

The following code shows how to create a connection object/

using System;

using System.Data;

using MySql.Data;

using MySql.Data.MySqlClient;

public class Tutorial1

{

public static void Main()

{

string connStr = "server=localhost;user=root;database=world;port=3306;password=******";

MySqlConnection conn = new MySqlConnection(connStr);

try

{

Console.WriteLine("Connecting to MySQL...");

conn.Open();

// Perform database operations

}

catch (Exception ex)

{

Console.WriteLine(ex.ToString());

}

conn.Close();

Console.WriteLine("Done.");

}

When the MySqlConnection constructor is invoked, it returns a connection object, which is used for

subsequent database operations. Open the connection before any other operations take place. Before the

application exits, close the connection to the database by calling Close on the connection object.

Sometimes an attempt to perform an Open on a connection object can fail, generating an exception that

can be handled using standard exception handling code.

In this section you have learned how to create a connection to a MySQL database, and open and close the

corresponding connection object.

4.1.2 The MySqlCommand Object

When a connection has been established with the MySQL database, the next step is do carry out the

desired database operations. This can be achieved through the use of the MySqlCommand object.

You will see how to create a MySqlCommand object. After it has been created, there are three main

methods of interest that you can call:

• ExecuteReader to query the database. Results are usually returned in a MySqlDataReader object,

created by ExecuteReader.

• ExecuteNonQuery to insert, update, and delete data.

• ExecuteScalar to return a single value.

剩余169页未读，继续阅读

qq13174115

粉丝: 1
资源: 29

MySQL Connector/NET开发指南：安装配置与应用开发详解

mysql-connector-net-8.0.13

mysql_refman-5.6-en.a4.pdf

connector-j-8.0-en.pdf

connector-en.pdf

卡士妥精巧连接器iCASTEL-Brochure-Smart-connector_EN.pdf

MySQL5.5使用手册---refman-5.5-en.pdf

Schematic_NanoPi_NEO2-V1.1-1711.pdf

PL-600微软MCP ET.pdf

上海安浦鸣志-集成式步进伺服-SSM产品-STM 17 英文-STM17S 用户手册.pdf

simatic-st70n-complete-english-2020.pdf

最新资源