Chapter 36. Accessing databases
This chapter covers
- Using the .NET Framework to connect to a database
- Querying databases with PowerShell
- Adding, deleting, and modifying databases with PowerShell
- Running stored procedures with PowerShell
It’s not uncommon to need to access something that’s in some kind of a database, so that’s what we’ll show you in this chapter. Now, as with many other chapters, we need to set some boundaries for what we’re going to cover (and not cover). This chapter won’t teach you the SQL query language, nor will it teach you how to create, maintain, or manage a database. This chapter is about using PowerShell to access the data that’s in a database and nothing more. We also assume you already have the necessary database ...