From what it seems to me, the only way to accomplish this right now (since the relations button appears to be perpetually greyed out) is with executing the custom query necessary to make it work. Also, I would think that since the button is there, the functionality
is very much on the WebMatrix team's radar.
Marked as answer by Mikesdotnetting on Jul 18, 2010 01:27 PM
This is a tool from a gentleman named Erik. This will allow you to connect to the .SDF file and fire queries against the database. At this moment this is the only tool i know which will provide you some sort of UI to work against the SDF file outside of
the VS.NET IDE.
Mike.Demmons
0 Points
1 Post
Relationships in SQLCE 4
Jul 14, 2010 05:12 PM|LINK
Hello,
I have been experimenting with WebMatrix, specifically the ability to connect to and use SQL CE data.
My question is:
When I am creating a new SQL Compact database with several tables, how do I define relationships between the tables?
The "Relationships" button in WebMatrix is always greyed out. Is that because it is still in Beta? Or am I missing something?
Thanks,
Mike
webmatrix
TheSavior
Member
22 Points
6 Posts
Re: Relationships in SQLCE 4
Jul 15, 2010 04:34 AM|LINK
From what it seems to me, the only way to accomplish this right now (since the relations button appears to be perpetually greyed out) is with executing the custom query necessary to make it work. Also, I would think that since the button is there, the functionality is very much on the WebMatrix team's radar.
Erik5388
Member
81 Points
84 Posts
Re: Relationships in SQLCE 4
Jul 15, 2010 06:48 PM|LINK
zettersten.com
client side dev
canvas/html5/js/css
kashyapa
Member
81 Points
25 Posts
Re: Relationships in SQLCE 4
Jul 20, 2010 07:07 PM|LINK
Hi
Check this out - http://sqlcetoolbox.codeplex.com/
This is a tool from a gentleman named Erik. This will allow you to connect to the .SDF file and fire queries against the database. At this moment this is the only tool i know which will provide you some sort of UI to work against the SDF file outside of the VS.NET IDE.
regards
Lohith
webmatrix SQL Compact
http://about.me/kashyapa
Vimpyboy
Contributor
3212 Points
651 Posts
MVP
Re: Relationships in SQLCE 4
Jul 20, 2010 07:36 PM|LINK
Thanks Lohith, that looks great!
http://weblogs.asp.net/mikaelsoderstrom
http://www.twitter.com/vimpyboy
capthow
Member
4 Points
2 Posts
Re: Relationships in SQLCE 4
Aug 03, 2010 04:12 PM|LINK
Hi,
Another stand alone tool you could try is SDF Viewer.
You can use SDF Viewer to create, open, edit and query sqlce 4.0 database files as well as working with relationships and indexes.
wavemaster
Participant
1350 Points
1161 Posts
Re: Relationships in SQLCE 4
Jul 30, 2012 09:36 PM|LINK
No, the relationships area is only grayed out when you are in table data. It becomes available when you go back to definition.