I can create a table relation very easily with SQL Server Express in Visual Studio 2010 by right clicking and selecting the relationships in the table designer. How do I create a relation between two tables with Visual Studio 2013 in SQL Server Express LocalDB without SQL Server Management Studio? I'm confused about it. May be without T-SQL code. I would like a simple solution.

1

There are 1 best solutions below

0
On

You can install Entity Framework Power Tools Beta from following url:

https://visualstudiogallery.msdn.microsoft.com/72a60b14-1581-4b9b-89f2-846072eff19d

It is a visual studio extension applicable to Visual studio 2013 as well which is your case. Restart Visual Studio after the install. Now right-click the code file in solution explorer which contains the definition of the class inherited from DbContext. In the context menu choose "Entity Framework" -> "View Entity Data Model". From there you should be able to edit the relationships between tables.