Bug #30483 DbObjectType = "Unknown"

Description:
Bug related to creating TableAdapters inside MS Visual Studio 2005. The autogenerate of Delete/Insert/Update commands don't work automatically. Somehow it doesn't detect the object as a table. This happens only when using mysql-connector.

-- Using:
MySQL 5.x
mysql-connector-odbc-3.51.19
MS Visual Studio 2005

How to repeat:
Inside a ASP.NET project:

1) Configure a ODBC datasource in windows to connect to MySQL
2) Create a simple web project inside Visual Studio 2005
3) Create a new DataSet
4) Follow the TableAdapter wizard and create a simple SELECT query
5) Open the properties of your new TableAdapter
6) Try to change the property "GenerateDBDirectMethods" to "True" -> you will not be possible.
7) Now open you DataSet code (in the DataSet main screen click "View Code")
8) Change the property DbObjectType from "Unknown" to "Table.
9) Repeat step 6 -> now you'll see that the Delete/Insert/Update methods are populated correctly.

Suggested fix:
When creating the TableAdapter the property "DbObjectType" should be set to "Table".

Hi and thanks for your report. Verified just as described using:
 - MySQL server 5.0.50pb on WinXP Pro SP2 localhost
 - VS 2005 Pro, MyODBC 3.51.21

        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="DataTable1TableAdapter" GeneratorDataComponentClassName="DataTable1TableAdapter" Name="DataTable1" UserDataComponentName="DataTable1TableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ODBC.localhost via TCP/IP.test" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="False" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     bug22400.*
FROM         bug22400</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>

verified with Connector/ODBC 3.51.27 and 5.1.8