In industry, most applications can’t be built without having interaction with a database. Databases serve the purpose of data storage so the data can be retrieved later via either a SQL query or a database application. Almost every software application running interacts with either one or multiple databases. Therefore, the front end needs a mechanism to connect with databases, and ADO.NET serves that purpose. Most of the .NET applications that require database functionality are dependent on ADO.NET. In this chapter, we’ll cover the following:
- Understanding ADO.NET
- The motivation behind ADO.NET
- Moving from ADO to ADO.NET
- Understanding ADO.NET architecture
- Understanding the SQL Server data provider ...