NET2: Bug in TableAdapter Query Code Generator

[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

 

[Frans Bouma [C# MVP]]

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

--

 

[Mark Olbert]

Already done. I just wanted to post it here to save some hair-pulling for others.

- Mark