Devart Forums

Hi, the most annoying problem I have is that every time I change some properties in a dataset created by MySQL DataAdapters it pops up a dialog with the question: "Do you want to regenerate Parameters collection for ". Since I have quite a lot of DataAdapters each with 4 sql statements, I get A LOT of these in a row... Mouseclicking olympics here I come... And I don't even want to regenerate the Parameters collection...

The second issue I have is with the Design Time Command Generator for DataAdapter. The generated sql update and delete statements adds all the UpdatingFields selected to the where clause, the way I see it only KEY FIELDS should be added to the where clause. Please correct! Beside from that I must say I like that you now give the generated parameters a good name: Original_ID f.ex. instead of just p1, p2 etc.

Please correct these problems quick!

Trygve

trygvelo wrote:Hi, the most annoying problem I have is that every time I change some properties in a dataset created by MySQL DataAdapters it pops up a dialog with the question: "Do you want to regenerate Parameters collection for ". Since I have quite a lot of DataAdapters each with 4 sql statements, I get A LOT of these in a row... Mouseclicking olympics here I come... And I don't even want to regenerate the Parameters collection...

We are investigating this problem right now.
You will be notified of the results.

As for DataAdapter Command Generator behavior. It is caused by default CommandBuilder behavior in the .NET Framework 2. We made some modifications in this designer under .NET2 so in the next build it will generate commands same as for .NET1.

trygvelo wrote:Hi, the most annoying problem I have is that every time I change some properties in a dataset created by MySQL DataAdapters it pops up a dialog with the question: "Do you want to regenerate Parameters collection for ". Since I have quite a lot of DataAdapters each with 4 sql statements, I get A LOT of these in a row... Mouseclicking olympics here I come... And I don't even want to regenerate the Parameters collection...

We have improved MySQLDirect .NET in the way you requested. The changes will be included in the next release.