How VS2008 DataSet generated works?

[Marco Castro]

Hello,

I'm new in .Net world and there is so many info that I'm lost. DataSet is
creted by Visual Studio 2008 to handle a FireBird database. Where can I find
documentation about how to use theses classes in a better way?

What is the most efective way to use it: load table by table from the
database and DataSet handles it or is better create a composite query leaving
the work to the database and DataSet gets the relationship already done?

Thanks,

Marco Castro

 

[William Vaughn [MVP]]

There are a number of books that discuss the TableAdapter but most (like
mine) discuss it in conjunction with SQL Server. However, most of the
concepts are the same or at least similar enough. I also discuss application
architecture as well. For lots of reasons, you generally do NOT want to load
entire tables into client memory unless you are working with a toy database
(one that has one user and a very low number of rows). Generally, you have
two choices. Use the TableAdapter Fill method(s) to directly populate the
DataTable objects imbedded in the TableAdapter generated code or use the
DataReader and return the rows one-by-one--placing them in an array or other
structure. I discuss the implications of using a JOIN product as well as
using single-table queries. Both have their advantages and disadvantages.



--
__________________________________________________________________________
William R. Vaughn
President and Founder Beta V Corporation
Author, Mentor, Dad, Grandpa
Microsoft MVP
(425) 556-9205 (Pacific time)
Hitchhiker’s Guide to Visual Studio and SQL Server (7th Edition)
____________________________________________________________________________________________

 

[Cor Ligthert[MVP]]

What is the most efective way to use it: load table by table from the

database and DataSet handles it or is better create a composite query
leaving
the work to the database and DataSet gets the relationship already done?

In whatever way you do it, you are selecting and reading resultsets.

The Fill does a lot for you to set those to datatables, but not everything

By using the mappings the tables become related to each other.

http://msdn.microsoft.com/en-us/library/ms810286.aspx

Cor