Search icon Close icon
Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Save more on your purchases now! discount-offer-chevron-icon
Savings automatically calculated. No voucher code required.

Change country

Modal Close icon
Country selected Country selected
country flag United States
Country selected
country flag United Kingdom
Country selected
country flag India
Country selected
country flag Germany
Country selected
country flag France
Country selected
country flag Canada
Country selected
country flag Russia
Country selected
country flag Spain
Country selected
country flag Brazil
Country selected
country flag Australia
Country selected
country flag Argentina
Country selected
country flag Austria
Country selected
country flag Belgium
Country selected
country flag Bulgaria
Country selected
country flag Chile
Country selected
country flag Colombia
Country selected
country flag Cyprus
Country selected
country flag Czechia
Country selected
country flag Denmark
Country selected
country flag Ecuador
Country selected
country flag Egypt
Country selected
country flag Estonia
Country selected
country flag Finland
Country selected
country flag Greece
Country selected
country flag Hungary
Country selected
country flag Indonesia
Country selected
country flag Ireland
Country selected
country flag Italy
Country selected
country flag Japan
Country selected
country flag Latvia
Country selected
country flag Lithuania
Country selected
country flag Luxembourg
Country selected
country flag Malaysia
Country selected
country flag Malta
Country selected
country flag Mexico
Country selected
country flag Netherlands
Country selected
country flag New Zealand
Country selected
country flag Norway
Country selected
country flag Philippines
Country selected
country flag Poland
Country selected
country flag Portugal
Country selected
country flag Romania
Country selected
country flag Singapore
Country selected
country flag Slovakia
Country selected
country flag Slovenia
Country selected
country flag South Africa
Country selected
country flag South Korea
Country selected
country flag Sweden
Country selected
country flag Switzerland
Country selected
country flag Taiwan
Country selected
country flag Thailand
Country selected
country flag Turkey
Country selected
country flag Ukraine
Country selected
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Conferences
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
Visual Studio 2019 Tricks and Techniques

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

Arrow left icon
Product type Paperback
Published in Jan 2021
Publisher Packt
ISBN-13 9781800203525
Length 386 pages
Edition 1st Edition
Languages
Tools
Concepts
Arrow right icon
Authors (2):
Arrow left icon
Aaron Cure Aaron Cure
Author Profile Icon Aaron Cure
Aaron Cure
Aaron Cure is an avid developer, instructor, and innovator. During his 10 years in the military as a linguist and a satellite communications repair technician, he learned that his real love was computer programming.nnAfter various throes with PHP, Classic ASP, VB, and a brief encounter with Java/JSP, he found a real passion for the .NET framework. After searching for a "better way" to carry out database storage and retrieval, Aaron stumbled across the NHibernate framework.nnUnsatisfied with the options for interacting with this great framework, he founded the NHibernate Generation project (nhib-gen) on SourceForge to reduce the "barrier to entry" for most developers.nnAaron and his family run a small consulting and web hosting company doing web design and custom software development for various organizations across the country. One of their more interesting projects has been software to control laser cutting machines.nnIn his spare time, he also enjoys developing projects with his daughters, using everything from Lego NXT (using C# and Bluetooth communications) to the Microchip PIC platform (using JAL and USB). He also collects and restores classic farm tractors, engines, and farm equipment, as well as semi trucks and trailers. He and his family display them at tractor shows, parades, schools, and various other community events.
Read more
See other products by Aaron Cure
Paul Schroeder Paul Schroeder
Author Profile Icon Paul Schroeder
Paul Schroeder
LinkedIn
Paul Schroeder is a versatile application developer, speaker, author, and managing director at MSC Technology Consulting. Along with a multi-decade professional IT career, Paul has a bachelor's degree in computer science and an MBA, and has earned an MCSD certification for web development.rnWhether coding or not, Paul enjoys spending time with his marvelous and talented wife, Robin, herself a Xamarin developer/speaker who creates Bluetooth mesh mobile applications.rnDrawn to code generation, Paul is the inspiration behind CodeGenHero™, an innovative Visual Studio extension, covered in Chapter 14, Be Your Team's Hero with CodeGenHero. Follow Paul at PaulBSchroeder.
Read more
See other products by Paul Schroeder
Arrow right icon
View More author details
Toc

Table of Contents (21) Chapters Close

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 Appendix

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!

lock icon The rest of the chapter is locked
arrow left Previous Section
Section 1 of 5
Next Section arrow right
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Sign up now
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Start free trial
Renews at $19.99/month. Cancel anytime

Authors (2)

Left arrow icon
Profile icon Schroeder
Schroeder
Github icon
Paul Schroeder is a versatile application developer, speaker, author, and managing director at MSC Technology Consulting. Along with a multi-decade professional IT career, Paul has a bachelor's degree in computer science and an MBA, and has earned an MCSD certification for web development. Whether coding or not, Paul enjoys spending time with his marvelous and talented wife, Robin, herself a Xamarin developer/speaker who creates Bluetooth mesh mobile applications. Drawn to code generation, Paul is the inspiration behind CodeGenHero™, an innovative Visual Studio extension, covered in Chapter 14, Be Your Team's Hero with CodeGenHero. Follow Paul at PaulBSchroeder.
Read more
See other products by Schroeder
Profile icon Aaron Cure
Aaron Cure
Aaron Cure is an avid developer, instructor, and innovator. During his 10 years in the military as a linguist and a satellite communications repair technician, he learned that his real love was computer programming. After various throes with PHP, Classic ASP, VB, and a brief encounter with Java/JSP, he found a real passion for the .NET framework. After searching for a "better way" to carry out database storage and retrieval, Aaron stumbled across the NHibernate framework. Unsatisfied with the options for interacting with this great framework, he founded the NHibernate Generation project (nhib-gen) on SourceForge to reduce the "barrier to entry" for most developers. Aaron and his family run a small consulting and web hosting company doing web design and custom software development for various organizations across the country. One of their more interesting projects has been software to control laser cutting machines. In his spare time, he also enjoys developing projects with his daughters, using everything from Lego NXT (using C# and Bluetooth communications) to the Microchip PIC platform (using JAL and USB). He also collects and restores classic farm tractors, engines, and farm equipment, as well as semi trucks and trailers. He and his family display them at tractor shows, parades, schools, and various other community events.
Read more
See other products by Aaron Cure
Right arrow icon

Other recommended products

Related to this chapter
Left arrow icon
Roslyn Cookbook
Roslyn Cookbook
Read more
Open-sourcing the C# and Visual Basic compilers is one of the most appreciated things by the .NET community, especially as it exposes rich code analysis APIs to analyze and edit code. If you want to use Roslyn API to write powerful extensions and contribute to the C# developer tool chain, then this book is for you.
Read more
Jul 2017 11h 40m
Mastering Visual Studio 2019
Mastering Visual Studio 2019
Read more
Visual Studio 2019 is the latest IDE from Microsoft for the developers to build stunning Windows, Web and Mobile applications. This comprehensive guide covers the key new features of Visual Studio 2019, and helps you mastering the skills of building, debugging, unit testing and hosting professional applications while collaborating with your team.
Read more
Aug 2019 12h 28m
Mastering Visual Studio 2019
Mastering Visual Studio 2019
Read more
Visual Studio 2019 is the latest IDE from Microsoft for the developers to build stunning Windows, Web and Mobile applications. This comprehensive guide covers the key new features of Visual Studio 2019, and helps you mastering the skills of building, debugging, unit testing and hosting professional applications while collaborating with your team.
Read more
Aug 2019 12h 28m
Mastering Visual Studio 2019
Mastering Visual Studio 2019
Read more
Visual Studio 2019 is the latest IDE from Microsoft for the developers to build stunning Windows, Web and Mobile applications. This comprehensive guide covers the key new features of Visual Studio 2019, and helps you mastering the skills of building, debugging, unit testing and hosting professional applications while collaborating with your team.
Read more
Aug 2019 12h 28m
Mastering Visual Studio 2019
Mastering Visual Studio 2019
Read more
Visual Studio 2019 is the latest IDE from Microsoft for the developers to build stunning Windows, Web and Mobile applications. This comprehensive guide covers the key new features of Visual Studio 2019, and helps you mastering the skills of building, debugging, unit testing and hosting professional applications while collaborating with your team.
Read more
Aug 2019 12h 28m
Mastering Visual Studio 2019
Mastering Visual Studio 2019
Read more
Visual Studio 2019 is the latest IDE from Microsoft for the developers to build stunning Windows, Web and Mobile applications. This comprehensive guide covers the key new features of Visual Studio 2019, and helps you mastering the skills of building, debugging, unit testing and hosting professional applications while collaborating with your team.
Read more
Aug 2019 12h 28m
Mastering Visual Studio 2019
Mastering Visual Studio 2019
Read more
Visual Studio 2019 is the latest IDE from Microsoft for the developers to build stunning Windows, Web and Mobile applications. This comprehensive guide covers the key new features of Visual Studio 2019, and helps you mastering the skills of building, debugging, unit testing and hosting professional applications while collaborating with your team.
Read more
Aug 2019 12h 28m
Mastering Visual Studio 2019
Mastering Visual Studio 2019
Read more
Visual Studio 2019 is the latest IDE from Microsoft for the developers to build stunning Windows, Web and Mobile applications. This comprehensive guide covers the key new features of Visual Studio 2019, and helps you mastering the skills of building, debugging, unit testing and hosting professional applications while collaborating with your team.
Read more
Aug 2019 12h 28m
Mastering Visual Studio 2019
Mastering Visual Studio 2019
Read more
Visual Studio 2019 is the latest IDE from Microsoft for the developers to build stunning Windows, Web and Mobile applications. This comprehensive guide covers the key new features of Visual Studio 2019, and helps you mastering the skills of building, debugging, unit testing and hosting professional applications while collaborating with your team.
Read more
Aug 2019 12h 28m
Mastering Visual Studio 2019
Mastering Visual Studio 2019
Read more
Visual Studio 2019 is the latest IDE from Microsoft for the developers to build stunning Windows, Web and Mobile applications. This comprehensive guide covers the key new features of Visual Studio 2019, and helps you mastering the skills of building, debugging, unit testing and hosting professional applications while collaborating with your team.
Read more
Aug 2019 12h 28m
Mastering Visual Studio 2019
Mastering Visual Studio 2019
Read more
Visual Studio 2019 is the latest IDE from Microsoft for the developers to build stunning Windows, Web and Mobile applications. This comprehensive guide covers the key new features of Visual Studio 2019, and helps you mastering the skills of building, debugging, unit testing and hosting professional applications while collaborating with your team.
Read more
Aug 2019 12h 28m
Mastering Visual Studio 2019
Mastering Visual Studio 2019
Read more
Visual Studio 2019 is the latest IDE from Microsoft for the developers to build stunning Windows, Web and Mobile applications. This comprehensive guide covers the key new features of Visual Studio 2019, and helps you mastering the skills of building, debugging, unit testing and hosting professional applications while collaborating with your team.
Read more
Aug 2019 12h 28m
Right arrow icon

Personalised recommendations for you

Based on your interests and search pattern
Left arrow icon
Pragmatic Microservices with C# and Azure
Pragmatic Microservices with C# and Azure
Read more
This book empowers you with in-depth knowledge of microservices architecture using .NET and Azure. Through hands-on tutorials, you'll be able to build, deploy, and manage scalable applications, gaining crucial skills for modern software development.
Read more
May 2024 16h 56m
Pragmatic Microservices with C# and Azure
Pragmatic Microservices with C# and Azure
Read more
This book empowers you with in-depth knowledge of microservices architecture using .NET and Azure. Through hands-on tutorials, you'll be able to build, deploy, and manage scalable applications, gaining crucial skills for modern software development.
Read more
May 2024 16h 56m
Pragmatic Microservices with C# and Azure
Pragmatic Microservices with C# and Azure
Read more
This book empowers you with in-depth knowledge of microservices architecture using .NET and Azure. Through hands-on tutorials, you'll be able to build, deploy, and manage scalable applications, gaining crucial skills for modern software development.
Read more
May 2024 16h 56m
Pragmatic Microservices with C# and Azure
Pragmatic Microservices with C# and Azure
Read more
This book empowers you with in-depth knowledge of microservices architecture using .NET and Azure. Through hands-on tutorials, you'll be able to build, deploy, and manage scalable applications, gaining crucial skills for modern software development.
Read more
May 2024 16h 56m
Pragmatic Microservices with C# and Azure
Pragmatic Microservices with C# and Azure
Read more
This book empowers you with in-depth knowledge of microservices architecture using .NET and Azure. Through hands-on tutorials, you'll be able to build, deploy, and manage scalable applications, gaining crucial skills for modern software development.
Read more
May 2024 16h 56m
Pragmatic Microservices with C# and Azure
Pragmatic Microservices with C# and Azure
Read more
This book empowers you with in-depth knowledge of microservices architecture using .NET and Azure. Through hands-on tutorials, you'll be able to build, deploy, and manage scalable applications, gaining crucial skills for modern software development.
Read more
May 2024 16h 56m
Pragmatic Microservices with C# and Azure
Pragmatic Microservices with C# and Azure
Read more
This book empowers you with in-depth knowledge of microservices architecture using .NET and Azure. Through hands-on tutorials, you'll be able to build, deploy, and manage scalable applications, gaining crucial skills for modern software development.
Read more
May 2024 16h 56m
Pragmatic Microservices with C# and Azure
Pragmatic Microservices with C# and Azure
Read more
This book empowers you with in-depth knowledge of microservices architecture using .NET and Azure. Through hands-on tutorials, you'll be able to build, deploy, and manage scalable applications, gaining crucial skills for modern software development.
Read more
May 2024 16h 56m
Pragmatic Microservices with C# and Azure
Pragmatic Microservices with C# and Azure
Read more
This book empowers you with in-depth knowledge of microservices architecture using .NET and Azure. Through hands-on tutorials, you'll be able to build, deploy, and manage scalable applications, gaining crucial skills for modern software development.
Read more
May 2024 16h 56m
Pragmatic Microservices with C# and Azure
Pragmatic Microservices with C# and Azure
Read more
This book empowers you with in-depth knowledge of microservices architecture using .NET and Azure. Through hands-on tutorials, you'll be able to build, deploy, and manage scalable applications, gaining crucial skills for modern software development.
Read more
May 2024 16h 56m
Mastering Python Design Patterns
Mastering Python Design Patterns
Read more
Unlock the power of design patterns to build maintainable and scalable software and applications using Python. Authored by Python veterans, this book is your guide to mastering design patterns in Python.
Read more
May 2024 9h 52m
Mastering Python Design Patterns
Mastering Python Design Patterns
Read more
Unlock the power of design patterns to build maintainable and scalable software and applications using Python. Authored by Python veterans, this book is your guide to mastering design patterns in Python.
Read more
May 2024 9h 52m
Right arrow icon