Menu
I have Visual Studio 2012 Express and have a razor c#.net project set up.
I have right clicked on AppData and added a Microsoft SQL database and named it "EspressoCoffees"
Now I can see that it is there, I goto the Database Explorer and right click on Tables and click add table.
The table designer comes up and I make a few columns making sure "Id" remains primary key.
478
Right-click on Tables and select Add New Table. The Table Designer opens and shows a grid with one default row, which represents a single column in the table that you're creating. By adding rows to the grid, you'll add columns in the table. Right-click on the CustomerID row, and then select Set Primary Key.
Expand the database in which to create the new database user. Right-click the Security folder, point to New, and select User.... In the Database User - New dialog box, on the General page, select one of the following user types from the User type list: SQL user with login.
Just modify the name of the table in the generated T-SQL and click on the "Update" button (int the top-left corner of the tab).
71
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
