Last post Jul 30, 2012 09:36 PM by wavemaster
Jul 14, 2010 05:12 PM|Mike.Demmons|LINK
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?
Jul 15, 2010 04:34 AM|thesavior|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.
Jul 15, 2010 06:48 PM|erik5388|LINK
Jul 20, 2010 07:07 PM|kashyapa|LINK
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.
Jul 20, 2010 07:36 PM|Vimpyboy|LINK
Thanks Lohith, that looks great!
Aug 03, 2010 04:12 PM|capthow|LINK
Another stand alone tool you could try is
You can use SDF Viewer to create, open, edit and query sqlce 4.0 database files as well as working with relationships and indexes.
Jul 30, 2012 09:36 PM|wavemaster|LINK
No, the relationships area is only grayed out when you are in table data. It becomes available when you go back to definition.