Home All Groups Group Topic Archive Search About

NET2: Bug in TableAdapter Query Code Generator

Author
14 Jan 2006 3:55 AM
Mark Olbert
There appears to be a bug in the code which (re)generates the command text for queries returning a table field in .NET 2.

1) Create an sql table
2) Create a TableAdapter for the the table in #1
3) Create a query in the TableAdapter in #2 which returns a single value whose value is a field in the sql table
4) Add a new field to the sql table in #1
5) Configure the TableAdapter in #2 to add the field added in #4
6) Examine in the code for the single value query in #3 (on my system, the single field is replaced by a list of all the fields
defined in the TableAdapter)

- Mark

Author
14 Jan 2006 1:04 PM
Frans Bouma [C# MVP]
Mark Olbert wrote:

> There appears to be a bug in the code which (re)generates the command
> text for queries returning a table field in .NET 2.
>
> 1) Create an sql table
> 2) Create a TableAdapter for the the table in #1
> 3) Create a query in the TableAdapter in #2 which returns a single
> value whose value is a field in the sql table 4) Add a new field to
> the sql table in #1 5) Configure the TableAdapter in #2 to add the
> field added in #4 6) Examine in the code for the single value query
> in #3 (on my system, the single field is replaced by a list of all
> the fields defined in the TableAdapter)

    Please file this at:
    http://msdn.microsoft.com/productfeedback

    it will then be picked up and fixed. :)

        FB

--
------------------------------------------------------------------------
Get LLBLGen Pro, productive O/R mapping for .NET: http://www.llblgen.com
My .NET blog: http://weblogs.asp.net/fbouma
Microsoft MVP (C#)
------------------------------------------------------------------------
Author
14 Jan 2006 3:58 PM
Mark Olbert
Already done. I just wanted to post it here to save some hair-pulling for others.

- Mark

AddThis Social Bookmark Button