Chapter 10. Adding Standards to Queries

After completing this chapter, you will be able to:

  • Understand why parameters are important in queries

  • Add parameters to standard selection and data update queries

  • Call stored procedures that include both in and out parameters

In ADO.NET, queries pass to external data sources as strings. These strings include not only essential command keywords and syntactical elements but also the data values used to limit and fulfill each query. Building command strings is an art long practiced by developers in many programming languages, but it’s quite different from .NET’s promise of strongly typed data management. Why store values as distinct data types at all if you are eventually going to convert everything to ASCII text? ...

Get Microsoft® ADO.NET 4 Step by Step now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.