Geek asks and answers

Visual Studio 2012 adds a database and creates the first table with user names

I have Visual Studio 2012 Express and have a C # .net razor project.

I right-clicked on AppData and added the Microsoft SQL database and named it "EspressoCoffees"

Now I see that it is, I went to the Database Explorer and right-click on the tables and clicked add table.

A table designer is created, and I make a few columns, making sure that "Id" remains primary.

  • Where do I call the table? Is there a table properties panel in which I cannot change the name, since it is gray?
  • When I save the table, it makes me choose the location for the file, which file is it? Table or database
  • If I save the SQL file in the data part of the application ... It does not appear under the Tables folder in any way.
+5
source share
3 answers

Just change the table name in the generated T-SQL and click the Refresh button (in the upper left corner of the tab).

enter image description here

+8
source

After you click "Update", close the "Design" tab and click "Update" on the server explorer.

+1
source
  1. Queries
  2. T-SQL. ....
0

More articles:


All Articles