Best way to interact with .mdb database?

[OpenYourMind]

I've got an MS Access database with around 20 or so tables, all of them
linked by foreign keys with enforced referential integrity. Using
oledbdataadapter, I find that I have to read each table individually into a
dataset, and then build each relation manually, which is quite tedious.
Also, there appear to be some .mdb attributes that do not map directly to an
aspect within the dataset, such as 'indexed (no duplicates)' or 'data
required'.

Basically, I want an object that represents all the rules of my .mdb so that
any violations are caught BEFORE attempting to update the .mdb.

Is there a better method than the oledbdataadapter?

[Miha Markic [MVP C#]]

Hi,

I suggest you to take a look at CodeSmith - template based code generator.
www.codesmithtools.com
You might also take a look at my templates for CodeSmith that build DataSet
schemas and DataAdapters.
http://www.rthand.com/DesktopModules...ID=6&mid=10244
and
http://www.rthand.com/DesktopModules...ID=7&mid=10244

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/
SLODUG - Slovene Developer Users Group www.codezone-si.info

"OpenYourMind" <Op**********@discussions.microsoft.com> wrote in message
news:44**********************************@microsof t.com...

I've got an MS Access database with around 20 or so tables, all of them
linked by foreign keys with enforced referential integrity. Using
oledbdataadapter, I find that I have to read each table individually into
a
dataset, and then build each relation manually, which is quite tedious.
Also, there appear to be some .mdb attributes that do not map directly to
an
aspect within the dataset, such as 'indexed (no duplicates)' or 'data
required'.

Basically, I want an object that represents all the rules of my .mdb so
that
any violations are caught BEFORE attempting to update the .mdb.

Is there a better method than the oledbdataadapter?