Creating Tables and Relationships
by Mike Snell, Lars Powers
Microsoft Visual Studio 2015 Unleashed, Third Edition
- About This eBook
- Title Page
- Copyright Page
- Contents at a Glance
- Table of Contents
- About the Authors
- Dedication
- Acknowledgments
- We Want to Hear from You!
- Reader Services
- Introduction
- Part I: Introducing Visual Studio 2015
- Chapter 1. A Quick Tour of Visual Studio 2015
- Chapter 2. The Visual Studio IDE
- Chapter 3. The .NET Languages
- What’s New in C# 6.0 and VB 14
- Language Primer
- Language Features
- Infer a Variable’s Data Type Based on Assignment
- Create an Object and Initialize Its Values (Object Initializers)
- Define a Collection and Initialize Its Values
- Creating an Instance of a Nonexistent Class
- Add Methods to Existing Classes (Extension Methods)
- Add Business Logic to Generated Code (Partial Methods)
- Access and Query Data Using the .NET Languages
- Write Simple Unnamed Functions Within Your Code (Lambda Expressions)
- Splitting an Assembly Across Multiple Files
- Working with XML Directly Within Your Code (VB Only)
- Removing Unused Arguments from Event Handlers (VB Only)
- Creating an Automatically Implemented Property
- Dropping the Underscore in VB for Line Continuation
- Working with Dynamic Languages/Objects
- Covariance and Contravariance
- Asynchronous Programming
- The .NET Framework
- Summary
- Part II: An In-Depth Look at the IDE
- Chapter 4. Solutions and Projects
- Chapter 5. Browsers and Explorers
- Chapter 6. Introducing the Editors and Designers
- Part III: Working with the Visual Studio Tools
- Chapter 7. Working with Visual Studio’s Productivity Aids
- Chapter 8. Testing Code
- Chapter 9. Refactoring Code
- Chapter 10. Debugging Code
- Chapter 11. Deploying Code
- Chapter 12. Developing Applications in the Cloud with Windows Azure
- Chapter 13. Working with Databases
- Part IV: Extending Visual Studio
- Part V: Building Web Applications
- Chapter 17. Building Modern Websites with ASP.NET 5
- Chapter 18. Using JavaScript and Client-Side Frameworks
- Chapter 19. Building and Consuming Services with Web API and WCF
- Part VI: Building Windows Client Apps
- Chapter 20. Building Windows Forms Applications
- Chapter 21. Building WPF Applications
- Chapter 22. Developing Office Business Applications
- Part VII: Creating Mobile Apps
- Chapter 23. Developing Windows Store Applications
- Chapter 24. Creating Windows Phone Applications
- Chapter 25. Writing Cross-Platform Mobile Applications with Apache Cordova
- Index
- Code Snippets
Creating Tables and Relationships
The primary entities in any database are its tables. Tables are composed of a structure and data. Server Explorer and the new SQL Server Object Explorer are the Visual Studio instruments used to define or edit the structure or data of any table within a connected database. In fact, using either Explorer, it is possible to create a new SQL Server database instance from scratch. Because the functionality between these Explorer windows is nearly identical, we won’t bother to illustrate every detail here within the context of both Explorers. The SQL Server Object Explorer (launched from the View menu, or by clicking the SQL Server Object Explorer button in the Server Explorer command bar) looks much more like the management console that ships with SQL Server itself and may be preferable to some people. Other than that, it will largely be a matter of preference in terms of which tool you use. For a quick side-by-side comparison of the two windows, see Figure 13.1.
We focus here on using the Server Explorer because most Visual Studio users are already familiar with it.
-
No Comment