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

Get PowerShell in Depth now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.