Select Page
This entry has been published on 2012-09-07 and may be out of date.

Last Updated on 2012-09-07.

Problem:

If you use SQL Select queries which contain multiple databases (in 1 query), the DataSet Designer and VS often crash.

Solution:

  • Try to use “`” before and after the database name in the SQL query, e.g. select meow from `mydbname`.`mytablename` `myshortname`
  • Don’t use the database name in the query, if it is already in the ConnectionString. Use it only for “foreign” databases.
  • Test the szenario without primary-key cols or indices.
  • Create the table, e.g. with a simple query that always works, to get the right columns. Then overwrite this query in the partial class of the DataSet, or in the Designer code, with your more complex query.
  • Try MySql.Data for .Net 2.0 and 4.0.
  • Create a new DataSet.

Using some of these tips, you should be able to create the DataTable and DataTablerAdapter in the DataSet.