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.
We hope you enjoy this release and encourage you to test this release with your applications
and let us know any problems you find.
没有合适的资源?快使用搜索试试~ 我知道了~
各版本Mysql.Data.dll官方整理下载
共268个文件
dll:98个
cs:26个
html:21个
5星 · 超过95%的资源 需积分: 46 938 下载量 142 浏览量
2016-03-09
11:23:46
上传
评论 3
收藏 38.17MB ZIP 举报
温馨提示
各版本Mysql.Data.dll官方整理,从版本1.0到版本6.9.8,包含各版本帮助文档和Samples,方便开发。
资源推荐
资源详情
资源评论
收起资源包目录
各版本Mysql.Data.dll官方整理下载 (268个子文件)
TableEditor.build 1KB
TableEditor.build 1KB
TableEditor.build 1KB
TableEditor.build 1KB
TableEditor.build 1KB
TableEditor.build 1KB
CHANGES 56KB
CHANGES 52KB
CHANGES 44KB
CHANGES 42KB
CHANGES 31KB
CHANGES 22KB
CHANGES 22KB
CHANGES 17KB
CHANGES 15KB
CHANGES 12KB
CHANGES 12KB
CHANGES 10KB
CHANGES 7KB
CHANGES 5KB
MySql.Data.chm 2.9MB
MySql.Data.chm 2.89MB
MySql.Data.chm 2.84MB
MySql.Data.chm 2.82MB
MySql.Data.chm 2.78MB
MySql.Data.chm 2.73MB
ConnectorNET.chm 2.66MB
MySql.Data.chm 2.53MB
ConnectorNET.chm 2.42MB
ConnectorNET.chm 2.35MB
MySql.Data.chm 1.34MB
MySql.Data.chm 1.04MB
MySql.Data.chm 655KB
MySql.Data.Tests.CF.dll.config 181B
COPYING 19KB
COPYING 19KB
COPYING 19KB
COPYING 19KB
COPYING 19KB
COPYING 18KB
COPYING 18KB
COPYING 18KB
COPYING 18KB
COPYING 18KB
COPYING 18KB
COPYING 18KB
COPYING 18KB
COPYING 18KB
Form1.cs 17KB
Form1.Designer.cs 12KB
Form1.cs 11KB
Form1.cs 11KB
Form1.cs 11KB
Form1.cs 9KB
Form1.cs 9KB
Form1.cs 6KB
Form1.cs 5KB
NewServerDialog.cs 5KB
Form1.Designer.cs 5KB
FailDetails.Designer.cs 4KB
AssemblyInfo.cs 3KB
AssemblyInfo.cs 3KB
AssemblyInfo.cs 3KB
Resources.Designer.cs 3KB
Resources.Designer.cs 2KB
AssemblyInfo.cs 2KB
AssemblyInfo.cs 2KB
AssemblyInfo.cs 2KB
FailDetails.cs 1KB
AssemblyInfo.cs 1KB
AssemblyInfo.cs 1KB
Settings.Designer.cs 1KB
Program.cs 476B
Program.cs 374B
MobileExplorer.csdproj 7KB
TableEditor.csproj 5KB
Tester.csproj 5KB
TableEditor.csproj 4KB
TableEditor.csproj 4KB
Async.csproj 4KB
Async.csproj 4KB
Profiling.csproj 3KB
mysql.visualstudio.dll 717KB
mysql.visualstudio.dll 711KB
mysql.visualstudio.dll 680KB
mysql.visualstudio.dll 676KB
mysql.visualstudio.dll 656KB
mysql.visualstudio.dll 646KB
mysql.visualstudio.dll 645KB
mysql.visualstudio.dll 644KB
mysql.visualstudio.dll 638KB
mysql.visualstudio.dll 484KB
mysql.visualstudio.dll 483KB
MySql.Data.dll 447KB
MySql.Data.dll 447KB
MySql.Data.dll 447KB
MySql.Data.dll 447KB
MySql.Data.dll 434KB
MySql.Data.dll 433KB
MySql.Data.dll 433KB
共 268 条
- 1
- 2
- 3
I-Awakening
- 粉丝: 65
- 资源: 4
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功
- 1
- 2
- 3
- 4
- 5
- 6
前往页