Add relationships between tables c# VS2005 Server Explorer

[morleyc]

Hi, i've started a c# project using MS compact SQL as a datasource. I
am able to add tables in the server explorer and columns in these
tables, but how can i add relationships between tables (define a
column as a foreign key), such that when i add the tables as a
datasource the relationship is already defined on the schema viwer? Do
i need an external tool to do this?

Sorry for being slightly off topic but i want to try and catch the
experts here rather than in generic visual studio newsgroup.

Cheers,

Chris

[Nicholas Paldino [.NET/C# MVP]]

Chris,

I believe that you can set relationships on the properties of the table
itself (there is a page for indexes, another for relationships, etc, etc).
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

<mo*****@gmail.comwrote in message
news:11*********************@o5g2000hsb.googlegrou ps.com...

Hi, i've started a c# project using MS compact SQL as a datasource. I
am able to add tables in the server explorer and columns in these
tables, but how can i add relationships between tables (define a
column as a foreign key), such that when i add the tables as a
datasource the relationship is already defined on the schema viwer? Do
i need an external tool to do this?

Sorry for being slightly off topic but i want to try and catch the
experts here rather than in generic visual studio newsgroup.

Cheers,

Chris

[morleyc]

I believe that you can set relationships on the properties of the table

itself (there is a page for indexes, another for relationships, etc, etc).

thanks for the reply, i cant see any of that under the table
properties dialog. i have since found microsoft.public.sqlserver.ce
and will try this, however would still be interested to hear from any
users here (i was recommended to use ms compact sql by a fellow
developer from this newsgroup).

Cheers,

Chris