You're reading from Visual Studio 2019 Tricks and Techniques A developer's guide to writing better code and maximizing productivity

Product type Paperback

Published in Jan 2021

Publisher Packt

ISBN-13 9781800203525

Length 386 pages

Edition 1st Edition

Languages

Tools

.NET Core

Concepts

Application Development

Authors (2):

Aaron Cure

Paul Schroeder

View More author details

Table of Contents (21) Chapters

Preface

1. Section 1: Visual Studio IDE Productivity Essentials

2. Chapter 1: Flavors of Visual Studio FREE CHAPTER

3. Chapter 2: Keyboard Shortcuts

4. Chapter 3: IDE Tips and Tricks

5. Chapter 4: Working with a Repository

6. Chapter 5: Working with Snippets

7. Chapter 6: Database Explorers

8. Chapter 7: Compiling, Debugging, and Versioning

9. Section 2: Customizing Project Templates and Beyond

10. Chapter 8: Introduction to Project and Item Templates

11. Chapter 9: Creating Your Own Templates

12. Chapter 10: Deploying Custom Templates

13. Section 3: Leveraging Extensions for the Win

14. Chapter 11: Overviewing Visual Studio 2019 Extensions

15. Chapter 12: Overviewing VS Code Extensions

16. Chapter 13: CodeMaid is Your Friend

17. Chapter 14: Be Your Team's Hero with CodeGenHero

18. Chapter 15: Secure Code with Puma Scan

19. Other Books You May Enjoy

Leave a review - let other readers know what you think

Appendix

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