HOUR 15. ADO.NET and SQL Server

Hour 16 shows you how to use VB.NET to design SQL Server stored procedures. Before you can understand the content of Hour 16, “Using VB to Design SQL Server Stored Procedures” you must first learn a little bit about ADO.NET. In this hour you’ll learn:

The history of data access

The basics of ADO.NET

How to use ADO.NET to modify data

The History of Data Access

To get a sense of the benefits of ADO.NET, let’s begin with a little history. Microsoft’s first data access methodology was Data Access Objects (DAO). Microsoft introduced DAO in the early ‘90s. Microsoft developed DAO to access JET data. As more and more companies began accessing SQL Server, Oracle, and other client/server databases, the shortcomings ...

Get Sams Teach Yourself Microsoft SQL Server 2005 Express in 24 Hours 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.