Summary


In this chapter, you learned:

  • That ADO.NET is the part of the .NET Framework that enables access to relational databases and other data sources. ADO.NET is designed to provide a simple, flexible framework for data access. It is designed for multitier application architectures and integrates relational data with XML.

  • That the ADO.NET classes are contained in the System.Data namespace. You reviewed the object model of ADO.NET and learned the roles of its major objects, including the connection, command, DataReader, data adapter, DataSet, DataTable, DataRow, and DataColumn objects.

  • That .NET data providers give access to specific data sources, and that ADO.NET can be extended to new data sources by writing .NET data providers for the new data source. You examined the .NET data providers included with ADO.NET for Microsoft SQL Server and OLE DB data sources and learned that these are contained in the the System.Data.SqlClient and System.Data.OleDb namespaces, respectively.

  • How to implement quick read-only access to data via the DataReader object, and how to write an equivalent program for both the SqlClient and OleDb .NET data providers. You learned how to update data and add rows via the DataSet, data adapter, and CommandBuilder objects. You saw how to find rows using the primary key, and also how to delete rows.

  • How to access multiple tables in a DataSet via the DataRelation object and how to generate an XML view of that data. Finally, you looked briefly at how to take advantage of the SQL database language support within ADO.NET, including display of automatically generated SQL commands, direction execution of SQL, and how to call a SQL stored procedure.

As you have seen, creating database code can be quite complex as you start to build more than a simple application. In the next chapter, you look at the tools in VS2005 that create much of this complex code for you and make database development much more fun!




Beginning Visual C# 2005
Beginning Visual C#supAND#174;/sup 2005
ISBN: B000N7ETVG
EAN: N/A
Year: 2005
Pages: 278

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net