Chapter 31. SQL Commands
This chapter focuses on SQL commands used to communicate directly with a database. In the previous two chapters, we presented an overview of ADO.NET, Data Providers, and the DataSet. In presenting these topics, SQL commands were briefly discussed and intentionally not explained in detail. Now that you have a good understanding of ADO.NET, this chapter explains SQL commands so that it is clear how direct access to a database works in .NET.
There are two goals to this chapter. The first goal is to briefly explain the syntax of the four most common commands in the SQL language. These commands are SELECT, INSERT, UPDATE, and DELETE The second goal is to show how you would invoke these databases commands using the .NET Framework ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access