Have I got this right ?

R

Roey

Well-known member
Joined
Oct 10, 2002
Messages
238
Location
Canada
My impressions of VB.Net application

Select * From Customers
Select * From States
Select * From Countries

Load via three dataadapters into a single dataset, multiple tables.

Create data relations between the Primary and Foreign keys in the dataset tables.

Populate form with the appropriate data using databinding where possible. Control via CurrencyManager, and BindingContext.

Save changes to form and transmit only changes to Dataadapter

Use the CommandBuilder to create the appropriatte SQL statements such as INSERT.


QUESTIONS

1. What about data traffic (transferring large tables to app) ?
2. No more complex SQL statements ?
3. How efficient is CommandBuilder ?
4. IS MY UNDERSTANDING OF .NET OUT TO LUNCH ???????
 
2. I was thinking along the lines of SQL statements using Joins in order to link tables.

3. Is it advisable to create ones own Insert, Modify, and Delete commands
 
And what is the best method for retreiving and writing data. 1. Simple SQL commands referencing a single table, and then multiple tables with data relations contained in a dataset.

2. SQL commands referencing multiple tables using the Join command and then a single table within the dataset.


Thanks for the help so far
 
We are having multiple table in a dataset (up to 15 so far, I think) with more or less complex SELECT commands and quite simple INSERT / UPDATE / DELETE commands.

It works ok.

Also, we have a baseclass DatasetDA which contains functions to return the "standard" commands for each table. The "real" Datasets inherit from DatasetDA and may (or may not) override the "standard" SELECTS.

To extremely high on the performance scale, but the best we could get regarding "ease of maintenance".
 
Back
Top