So you do have your query written because you copied it from the T-SQL window. You pasted the output of this UI in your original question. It will create a blank table query designer which is simply the user interface on top of a plain SQL query. Right-click Tables and select "Add New Table". These categories will be empty because you haven't created any of them yet, but the category is there. Tables, Views, Stored Procedures, Functions, etc. You view your database file in the "server explorer" view and you should see a treeview with the categories of available objects in your database. Now you want to add a table to the database. This database will appear in your server explorer view. You're creating a database "data" file and "log" file you can use as your database.
So if you see "SQL Server Database" as an item you can add and the file type is ".mdf" then that's going to be the same thing. When you attempt the "Add -> New Item" and want to choose a database file, you're not going to see SQL Server Compact because it was deprecated (discontinued) back in 2013. If you use a modern version of Visual Studio to "create a new asp.net web application" and choose ".net mvc" as the type of web application, you're going to see an "App_Data" folder in the folder structure of the web application. Setting aside the fact that you're using an odd, out-of-date clone of the w3schools website. Like it does not exist at all, but I know it does. Tried multiple times to create a table, no table popping up. So I closed it and opened with administrator rights. So I had to close Visual Studio, and it might be an administrator issue. I read a bit on the internet, and it was said it was apparently slow at refreshing. Anyway, that table exists, but Server Explorer still can't see it. I could still save, and it would load the saving window to choose a destination, again. In fact, it seemed as if the table was not even saved at all. I saved the table, but it didn't appear in server explorer. Anyway, shortly after, I used Server Explorer to create a table. I'm following this tutorial, which althrough it is old, is very informative with MVC: Īnyway, during the tutorial, I had to something, which was to create an SQL Server Database.
0 kommentar(er)
