O'Reilly logo

Sams Teach Yourself Microsoft SQL Server 2005 Express in 24 Hours by Alison Balter

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required