Have I got this right ?

[Roey]

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 ???????

[Robby]

2. what do you consider complex?

3. not at all.

[Roey]

2. I was thinking along the lines of SQL statements using Joins in order to link tables.

 

3. Is it advisable to create one's own Insert, Modify, and Delete commands

[Robby]

3. yes

[Roey]

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

[Heiko]

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".

[begin_with_A]

2. Use Joins to simplify...

3. I prefer stored procedures,...

 

-A

http://www.autojobapply.com/

[send your resume to thousands of job-openings within minutes!]