MySQL Connector的这种行为很奇怪 [英] This behavior of MySQL Connector is strange
问题描述
我正在使用带有Visual Studio LightSwitch Beta 2的MySQL 6.3.6连接器。
I am using MySQL 6.3.6 Connector with Visual Studio LightSwitch Beta 2.
IDE连接到MySQL数据库,但报告没有表存在,但有一个现有表的数量。哇!
The IDE connects to the MySQL database but reports that no tables exists but there are a number of existing tables. Wow!
这是我通过命令行访问的内容:
Here is what I see accessing via command line:
mysql> show tables;
+ -------------------- +
| Tables_in_testmove |
+ -------------------- +
|员工          |
| from2k8            |
| mypet              |
| otherconnector     |
| testconnector      |
|测试            |
| testonly           |
+ -------------------- +
7行(0.00秒)
mysql> show tables;
+--------------------+
| Tables_in_testmove |
+--------------------+
| employees |
| from2k8 |
| mypet |
| otherconnector |
| testconnector |
| testing |
| testonly |
+--------------------+
7 rows in set (0.00 sec)
推荐答案
这些表是否有整数主键?
Do these table have interger primary keys?
你如果IDE没有为您提供所需的结果,那么使用RIA服务连接到您的MySQL数据库可能会更幸运吗?
You might have more luck using RIA services to connect to your MySQL db, if the IDE is not giving you the results that you need?
Yann
>
这篇关于MySQL Connector的这种行为很奇怪的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!