Summary

In this chapter we introduced you to the fundamentals of accessing SQL Server from ASP.NET in a manner that is reliable and scalable. By the end of this chapter, you had seen how not only to execute dynamic queries, but also to execute stored procedures from ASP.NET without having to use a DataGrid to display the results. In this chapter we also touched on the middle tier, which we discuss in detail in the Chapter 12.

Questions and Answers

Q1:	What databases are accessible from ASP.NET?
A1:	ASP.NET shares the same accessibility to data that ADO.NET provides. That is, for any data source that ADO.NET can connect to, ASP.NET will provide the same functionality.
Q2:	If everything is in XML, why not just use a parser?
A2:	A parser provides functionality to extract data from elements within a structure. ADO.NET provides functionality to parse data either returned as XML or retrieved in the native format from a database. In addition there are the performance benefits.