MySQL Bugs: #30483: DbObjectType = "Unknown"

Bug #30483	DbObjectType = "Unknown"
Submitted:	17 Aug 2007 20:51	Modified:	7 Nov 2007 12:25
Reporter:	mkjhkjh kljhkjhk
Status:	Verified
Category:	Connector/ODBC	Severity:	S3 (Non-critical)
Version:	3.51.21	OS:	Microsoft Windows
Assigned to:	Bugs System	Target Version:	5.1
Triage:	D3 (Medium)

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>