I've grown up through the route of setting up all your referential integrity in the database first (usually use MS-Access relationships feature and enforce constraints as appropriate) and letting the RDBMS handle all of that.

Now with VB.NET, I've noticed you can do all this via creating a dataset.

I'm just a bit confused now....where should the referential integrity rules be placed: in the DBase or in the VB.NET application ? If I can still leave it in the DBase, should I be even mucking around with setting relationships and constraints through the dataset ?