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

Managing databases in Visual Studio 2019 for Windows

The Windows offering is by far the most impressive out-of-the-box, as it includes SQL Server Data Tools (SSDT). This is a pretty full-featured database explorer for SQL Server, with many of the features that a typical development task requires. There are also options for other databases, such as SQLite and MySQL, provided by third-party add-ins.

SSDT has a number of things that can be useful to us, such as Azure SQL Database and Azure SQL Data Warehouse database management. Let's talk about one of the most commonly used tools, SQL Server Object Explorer.

Working with SQL Server Object Explorer

SQL Server Object Explorer is the primary interface to the database from within Visual Studio 2019 for Windows. From this window, we can create, manage, drop, or alter the database. We can manage table creation and deletion and even add data. Let's take a look at some of the capabilities.

If the SQL Server Object Explorer...