Connector/Net 5.2 Release Notes
------------------------------------
Welcome to the release notes for Connector/Net 5.2
There are a number of new features in this release and most of those new features do
not come with any change in existing behavior. However there are a couple of changes
that users should be aware of. These changes will be documented in the final GA
documentation. Please see the changelog for a complete list of new features or bug fixes
found in this release.
Use Old Syntax is now obsolete
==============================
We've had significant feedback from users that they want to use @ to mark their parameters
instead of using the ? character. very early versions of the provider did use the @ character but
we changed that to ? when we realized that MySQL user variables start with @. Take the
following SQL as an example:
SET @myusevar=4;
SELECT * FROM mytable WHERE id=@id AND var=@myusevar;
In this SQL @myusevar is a MySQL controlled user variable and @id is intended to be a user-supplied
parameter. The problem is that the provider cannot tell the difference. As we wanted to
throw exceptions when parameters are missing upon query execution, we decided to
use a different parameter marker character and use the Old Syntax configuration option for
applications that were already using @.
Since then we've come to realize that users don't use MySQL user variables very often
and not using @ makes porting applications from SQL Server to MySQL harder than it needs to be.
Therefore, we have decided to move back to suggesting users use the @ character to mark your
parameters and we have marked the Use Old Syntax configuration option as obsolete. If you use
that option in your connection string, it will have zero effect and a warning message will
be logged. Since we realize that many applications are using ?, we intend to support both
characters for the foreseeable future.
There are side effects that users should be aware of. Here is a bullet list of those effects.
- Attempting to add a parameter with the same base name as an existing parameter will throw
a duplicate parameter exception. (i.e. Adding ?id when @id is already in the collection)
- MySqlParameterCollection.IndexOf will return -1 unless the name matches exactly.
(i.e. calling IndexOf("@id") will return -1 even if ?id is in the collection)
- Mixing and matching parameters works though it is not recommended. You can define your SQL using
@ (SELECT * FROM mytable WHERE id=@id) but then use ? in your paramters.
- There is a new connection string option named 'Allow User Variables'. The default value is false.
With the default value, the provider doesn't expect to see any user variables in the SQL therefore
if it sees @<name> in the SQL it will assume there should be a parameter with the same base name
and throw an exception if one is not there. If you intend to use user variables, you have two
options. First, continue to use ? for your parameters (not recommended) or
set Allow User Variables to true. With this set to true, the provider will not throw an exception
if a parameter appears to be missing.
TinyInt conversion to Bool is now configurable
==============================================
This change was added to 5.1.5 and pulled forward into this release. By default, columns
of type TINYINT(1) are still converted to boolean however that can be disabled
with a new connection string option. Setting 'Treat Tiny As Boolean' to false will
return those columns as integer instead of boolean.
Using the new provider schema
=============================
This release includes a completely revamped set of web providers along with a completely
rewritten provider schema. We will either deliver the SQL scripts in the RTM release
or we will deliver a tool that will allow you to upgrade existing servers to the new
schema. For this release. the only way to upgrade a given server to the new schema is to
add a configuration option for one of your providers. The option is 'autogenerateschema'.
By setting this to true, the provider will silently upgrade the server to the new schema.
Please note that there is no reversing of this procedure so please just do this on test
setups and not on your production systems.
Procedure Parameter schema view has changed
===========================================
With this release we are now supporting using the procedure parameters information
schema view that is available when running against a 6.0 server or later. The benefits
of this is that you no longer need elevated privileges to pull this collection.
Our provider will use the old code when running against a 5.x server so we modified
this code to return a collection that matches the 6.0 collection. This means that we
dropped columns such as IS_RESULT (just check for ordinal position = 0) and
ROUTINE_TYPE.
Known Issues
==============
We discovered during our final testing that the Create menu options are
not working in the server explorer integration. These are options such as
Create Table, Create Stored Procedure, and Create View. We apologize for this
inconvenience and will have this working for the beta.
We hope you enjoy this release and encourage you to test this release with your applications
and let us know any problems you find.
没有合适的资源?快使用搜索试试~ 我知道了~
温馨提示
.net连接mysql的例子以及源代码 Connector/Net 5.2 Ability to clear a single connection pool or all connection pools. DDEX provider now works under Visual Studio 2008 Batched commands are now supported with MySqlDataAdapter Added MySqlScript class for executing SQL scripts Added MySqlBulkLoader class for easily loading large amounts of data Changed to recommending @ as parameter marker BINARY(16) columns are now treated as Guid objects Added profile provider and improved provider schema
资源推荐
资源详情
资源评论
收起资源包目录
mysql-connector-net-5.2.2-noinstall.zip (55个子文件)
COPYING 19KB
bin
MySql.Data.dll 284KB
EXCEPTIONS 5KB
Docs
MySql.Data.chm 1.13MB
Samples
Pocket PC
Tester
Form1.cs 6KB
FailDetails.resx 6KB
Properties
Resources.Designer.cs 2KB
Resources.resx 5KB
red.png 256B
green.png 267B
white.png 203B
AssemblyInfo.cs 1KB
Program.cs 374B
Tester.csproj 5KB
FailDetails.Designer.cs 4KB
Form1.Designer.cs 5KB
Form1.resx 8KB
FailDetails.cs 1KB
MySql.Data.Tests.CF.dll.config 181B
MobileExplorer
MobileExplorer.sln 1KB
MobileExplorer.suo 8KB
Form1.cs 17KB
NewServerDialog.cs 5KB
NewServerDialog.resx 12KB
MobileExplorer.csdproj 7KB
Form1.resx 25KB
AssemblyInfo.cs 2KB
TableEditor
VB
AssemblyInfo.vb 2KB
Form1.vb 11KB
TableEditor.build 1KB
TableEditor.vbproj 4KB
Form1.resx 13KB
CS
Form1.cs 11KB
TableEditor.build 1KB
TableEditor.csproj 4KB
App.ico 1KB
Form1.resx 13KB
AssemblyInfo.cs 3KB
Profiling
cs
Form1.cs 5KB
Properties
Resources.Designer.cs 3KB
Settings.settings 249B
Resources.resx 5KB
Settings.Designer.cs 1KB
AssemblyInfo.cs 1KB
Program.cs 476B
Form1.Designer.cs 12KB
Form1.resx 6KB
Profiling.csproj 3KB
Async
cs
Form1.cs 9KB
App.ico 1KB
Form1.resx 16KB
Async.csproj 4KB
AssemblyInfo.cs 2KB
CHANGES 32KB
Release Notes.txt 5KB
共 55 条
- 1
资源评论
- whbindg22011-09-26用了还行,不过不知道咋回事就是MYSQL插入数据的时候出错,有些在MSSQL中可支持的中文字符在MYSQL里不支持。
- vv7706728332014-02-27不是很好用啊 !
- leisunzyj2013-09-17还不错,已解决
- hzw20072014-06-18.net连接mysql源代码
- asdfw2efd2014-03-30不是很好用啊 !
hold5986
- 粉丝: 2
- 资源: 4
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功