Book Image

Visual Studio 2019 Tricks and Techniques

By : Paul Schroeder, Aaron Cure
Book Image

Visual Studio 2019 Tricks and Techniques

By: Paul Schroeder, Aaron Cure

Overview of this book

Visual Studio 2019 (VS 2019) and Visual Studio Code (VS Code) are powerful professional development tools that help you to develop applications for any platform with ease. Whether you want to create web, mobile, or desktop applications, Microsoft Visual Studio is your one-stop solution. This book demonstrates some of the most sophisticated capabilities of the tooling and shows you how to use the integrated development environment (IDE) more efficiently to be more productive. You’ll begin by gradually building on concepts, starting with the basics. The introductory chapters cover shortcuts, snippets, and numerous optimization tricks, along with debugging techniques, source control integration, and other important IDE features that will help you make your time more productive. With that groundwork in place, more advanced concepts such as the inner workings of project and item templates are covered. You will also learn how to write quality, secure code more efficiently as well as discover how certain Visual Studio features work 'under the hood'. By the end of this Visual Studio book, you’ll have learned how to write more secure code faster than ever using your knowledge of the extensions and processes that make developing successful solutions more enjoyable and repeatable.
Table of Contents (21 chapters)
1
Section 1: Visual Studio IDE Productivity Essentials
9
Section 2: Customizing Project Templates and Beyond
13
Section 3: Leveraging Extensions for the Win

Chapter 6: Database Explorers

As developers, we frequently connect to backend databases to store values and data from the application. Being able to inspect the database, view data, and make changes to it directly in Visual Studio is very helpful and a huge timesaver over opening a client, connecting to the database, and so on.

In this chapter, we will discuss database explorers for Visual Studio 2019 for Windows and Visual Studio Code (VS Code).

What about Mac?

Currently, there is no database explorer solution for Visual Studio 2019 for Mac. Hopefully, there will be something in an upcoming release, but for now, Microsoft recommends using the Azure Data Studio client on macOS.

In this chapter, we will discuss the following topics:

  • Managing databases in Visual Studio 2019 for Windows
  • Interacting with databases in VS Code

By the end of this chapter, you will be able to create a database, add tables and columns, and even add data to those tables!