DataSet with multiple relations to

[Jonas]

Hi!

I'm using a typed dataset where I have a common address table which is
related to several other tables in the dataset, see below:

Table Incident:
- PK
- FK_incidentAddress - relation to Address.PK
- FK_destinationAddress - relation to Address.PK
....

Table Person:
- PK
- FK_homeAddress - relation to Address.PK
....

Common table Address
- PK
- Street
- City
.....

If I use one Address entity in the dataset, I guess that I'll get problems
as one row in Address can not satisfy all the relations specified. If I
instead create multiple Addresses which I give different names, and the
relate each of them to their parent, I get ConstraintExceptions when trying
to enable constraints in the dataset after merging the child rows. It seems
like it is the rename of a Address table that creates my problem.

Any tips?

Brgds

Jonas

 

[Miha Markic [MVP C#]]

Hi Jonas,

If I use one Address entity in the dataset, I guess that I'll get problems
as one row in Address can not satisfy all the relations specified.

No problems there. The address row doesn't need to satisfy all relations, or
better, it doesn't need to satisfy any relation.
On the other hand, if you put some value into, for example,
FK_incidentAddress, there has to be related row in Address table.

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
www.rthand.com
SLODUG - Slovene Developer Users Group www.codezone-si.info

If I

 

[Jonas]

Hi Miha,

thank you for your very fast response. I tried it, and it worked like a
charm. I guess that I complicated the problem before trying out the simplest
solution :-/

Thanks

Jonas

Hi Jonas,

If I use one Address entity in the dataset, I guess that I'll get
problems as one row in Address can not satisfy all the relations
specified.

No problems there. The address row doesn't need to satisfy all relations,
or better, it doesn't need to satisfy any relation.
On the other hand, if you put some value into, for example,
FK_incidentAddress, there has to be related row in Address table.

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
www.rthand.com
SLODUG - Slovene Developer Users Group www.codezone-si.info

If I

instead create multiple Addresses which I give different names, and the
relate each of them to their parent, I get ConstraintExceptions when
trying to enable constraints in the dataset after merging the child rows.
It seems like it is the rename of a Address table that creates my
problem.

Any tips?

Brgds

Jonas