Re: Accessing Multiple Tables - Brandon Schenz - com.mysql.lists.dotnet

4 messages in com.mysql.lists.dotnetRe: Accessing Multiple Tables

From	Sent On	Attachments
Brian McWilliams	03 Nov 2005 17:41
Brandon Schenz	03 Nov 2005 19:17
Brian McWilliams	03 Nov 2005 20:20
Blue Wave Software	06 Nov 2005 04:15

Subject:	Re: Accessing Multiple Tables
From:	Brandon Schenz (bran...@schenzcustomdesigns.com)
Date:	11/03/2005 07:17:03 PM
List:	com.mysql.lists.dotnet

I'm not sure why you are not able to update data after a join (unless you are attempting to update multiple tables at once).

I would use the unique Adapter, Command and CommandBuilder approach, but load the Data into a DataSet where you can map the relationships, you then have an in memory database.....

On Thu, November 3, 2005 8:41 pm, Brian McWilliams wrote:

Hello all. I have a few questions for those of you out there more experienced with MySQL application design.

My application makes use of a great deal of tables (10 currently, more to come). What is the best way to be able to retrieve these tables? I have tried to do joins before, but have found that I can not update the data after a join has been performed.

Second: Currently with my application, I have declared a single MySQLConnection, and a unique MySQLAdapter, MySQLCommand, and MySQLCommandBuilder for each of the tables that are being retrieved now (they are each being retrieved individually). Is this the correct approach to take or are there better methods?