Using Typed Datasets in asp.net 2.0

microsoft.public.dotnet.framework.adonet

11 Apr 2006 12:30 PM

amit

I am having a play with typed datasets in ASP.Net 2.0

I am using the builder to create my data layer.

I have the following tables.

[EmployeeType], [Departments], [Location], and [Groups]

The first three tables above have a one to many relation ship to
[Groups] via mapping tables [EmpType2Group], [Dept2Group] and
[Loc2Group] so each record of the first three tables can be linked to
many groups and each of the first three tables can also be linked to
the same group.

I have stored procedures that will return the groupsByLocation,
groupsByDepartments etc.

Now I have created datasets for each of the tables (empType, dept, loc
and groups) with their appropriate table adapters and get methods.

My question is, where do I add the methods GetGroupByLocation, etc? I
cant add them to the Location dataset as the schema doesn't have a
group field, and I cant add them to the Group dataset (which is were I
would imagine it to go) because there is no locationID field in the
schema.

Any ideas?

Cheers

Amit