Problem creating a database diagram in Visual C# 2010 Express

Question

Even creating a table called "People" previously, when creating a new database diagram in Visual C# 2010 Express, there is no table option for me to work on, not even the "People" table I created myself. What may be happening?

Thanks in advance,

Answer 1

Creating a new SQL Server database

To add a new database for the project click on the Project->Add new item menu.

Select Service-based Database from the list of available templates.

Type "Basedata" in the name area, click "Add".

The database configuration help will open, but no object will be available as this is a new database.

Click "Finish" to create the database and dataset and add them to the project.

Creating new tables in the database

To add new tables to the database open the "Server Explorer/Database Explorer" by selecting "Server Explorer/Database Explorer" from the "View" menu".

Expand the "Sampledatabase.mdf" node below the "Data Connections" node. Right-click on "Tables" and "Add New Table". The table designer will open.

Creating a new database diagram

Under "Server Explorer", right-click on "Database Diagrams" or any diagram in the folder.

Important

You can use the database diagram designer to update database in SQL Server 2005, SQL Server 2008, and SQL Server 2008 R2. However, SQL Server 2012 does not support this feature.

Choose "Add New Diagram" from the shortcut menu. The day "Add Table" will appear. Select the desired tables in the table list and click "Add.

Tables are shown graphically in the new database diagram.

You can continue adding or deleting tables, modifying existing tables, changing relationships until the new diagram is complete.

Sources:

https://msdn.microsoft.com/en-us/library/ms233763(v=vs.100). aspx

https://msdn.microsoft.com/en-us/library/ms171978.aspx