Bug #36599 TableAdapter wizard do not create UPDATE and DELETE querys
Submitted: 8 May 2008 16:58 Modified: 12 Jun 2008 8:30
Reporter: Ulf J Email Updates:
Status: No Feedback Impact on me:
None 
Category:Connector / NET Severity:S3 (Non-critical)
Version:5.2.1 OS:Windows (Vista SP1)
Assigned to: CPU Architecture:Any

[8 May 2008 16:58] Ulf J
Description:
When adding a TableAdapter(in a dataset file .xsd) in Visual Studio 2008 using the wizard or draging the table from the "Server Explorer" the table/datset will be created but only with a SELECT and INSERT query, not with a UPDATE and DELETE query.

To sum up:
The table generated from the wizard is ok, but in the poperties window for the DataTable is the update and delete query missing/(None). 

How to repeat:
The wizard steps:
The connection string looks like this:

1: server=localhost;user id=test;Password=test1234;persist security  info=True;database=dbtest;port=3307;ignore prepare=False

2: Use SQL statments

3: SELECT * FROM tbl_test

4: Advanced options: All checked

All cheked
5: Fill a DataTable: Method namne: Fill
   Return a DataTable: Method name: GetData
   Create Insert,Update and delete..
[12 May 2008 8:30] Tonci Grgin
Hi Ulf and thanks for your report.

This is a known problem which should have been addressed in 5.2.2 so please try and inform me of result.

This is actually a duplicate of bug#35852 but as it's in NoFb we can continue discussion here.
[12 Jun 2008 23:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".