Craig,
I use Nettiers,
www.nettiers.com which creates through code generation and based on ORM and 3 tiers design, typed datasets.
They offer a lot of flexibility, are fast and I'm very pleased with them.
Some code example :
Employee employee=new Employee();
employee.Name="John";
EmployeeProvider.Save(employee);
or
Employee employee=EmployeeProvider.GetByEmployeeID(12); //primary key
employee.Salary=4000;
EmployeeProvider.Save(employee);
or
EmployeeCollection employees=EmployeeProvider.GetByDepartmentID(10); //foreign key
All I need to code, the rest is generated behind the scenes.
>I'm reading about typed data sets and wondering the best way of creating them. Is it:
>
>1. One DataSet.xsd file per table in the database
>2. One DataSet.xsd file for the entire database
>3. Something else
>
>If option 1, how do I handle related tables?