Sign In Start Free Trial
Account

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Visual Studio 2019 Tricks and Techniques
  • Toc
  • feedback
Visual Studio 2019 Tricks and Techniques

Visual Studio 2019 Tricks and Techniques

By : Aaron Cure, Schroeder
4.2 (9)
close
Visual Studio 2019 Tricks and Techniques

Visual Studio 2019 Tricks and Techniques

4.2 (9)
By: Aaron Cure, Schroeder

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)
close
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...

bookmark search playlist download font-size

Change the font size

margin-width

Change margin width

day-mode

Change background colour

Close icon Search
Country selected

Close icon Your notes and bookmarks

Delete Bookmark

Modal Close icon
Are you sure you want to delete it?
Cancel
Yes, Delete