[Mono-list] ADO and mono

Hector Geraldino hector@clubdelphi.com
Wed, 20 Oct 2004 01:03:48 -0500


Yeah, something like that.

Think that DataSet is some sort of friendly-tables wich lives in the same
building. No matter where they has come from, no matter if they're related
or not to each other (in practice, they should), but they could live
together in the same DataSet. The dataset could generate an schema with all
those tables, their relationship (the datarelation you've defined into the
dataset), and also when you insert/delete records from/to these tables, if
they're related or have any rule (like primary key, unique field, foreign
key etc) the DataSet could throw different exceptions accordly to the
operation.  And, all this, from a disconnected environment.

Got it ?

----- Original Message -----
From: "Eric Damron" <edamron@spamcop.net>
To: "mono-list" <mono-list@lists.ximian.com>
Sent: Tuesday, October 19, 2004 10:11 PM
Subject: Re: [Mono-list] ADO and mono


> Thanks Hector.
>
> It's still a bit confusing.  So what you're saying is that a single
> dataset can contain the result of more than one query?  Each query
> result in its own table?  Did I get it right?
>
> My head hurts...
>
> Hector Geraldino wrote:
>
> >Hi,
> >
> >Maybe a single query can only return a single database, but in a Dataset
you
> >can hold more than one table (a collection of datatables).  Look at the
> >DataSet.Tables.Add() method to see how it works.
> >
> >You migth ask "why have more than one datatable in a dataset", and if you
> >visit the topic about relationships between tables, you'll find that you
can
> >create a complete (pseudo-complete) RDBMS with a great characteristic:
it's
> >absolutely disconnected.
> >
> >hectorG
> >----- Original Message -----
> >From: "Eric Damron" <edamron@spamcop.net>
> >To: "mono-list" <mono-list@lists.ximian.com>
> >Sent: Tuesday, October 19, 2004 7:48 PM
> >Subject: Re: [Mono-list] ADO and mono
> >
> >
> >
> >
> >>Thanks for the reply Morten.  I guess what confused me was that the
> >>author used the same name for the recordset return table as the table he
> >>was querying.
> >>
> >>I'm still a little confused because the next thing he does is:
> >>
> >>DataTable dataTable = ds.Tables[0];
> >>
> >>If a single recordset table is returned isn't the [0] redundant?  How
> >>can one return more than a single recordset table?
> >>
> >>Thanks
> >>_______________________________________________
> >>Mono-list maillist  -  Mono-list@lists.ximian.com
> >>http://lists.ximian.com/mailman/listinfo/mono-list
> >>
> >>
> >
> >
> >
> >
>
> _______________________________________________
> Mono-list maillist  -  Mono-list@lists.ximian.com
> http://lists.ximian.com/mailman/listinfo/mono-list