Problem creating a database diagram in Visual C # 2010 Express

1

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 with, not even the "People" table that I created myself. What could be happening?

Thank you in advance,

    
asked by anonymous 22.02.2017 / 19:41

1 answer

0

Creating a new SQL Server database

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

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

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

Database configuration help will open, but no objects 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 "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

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

Important

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

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

The tables are shown graphically in the new database diagram.

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

Sources:

link

link

    
22.02.2017 / 20:33