Chapter 1: Designing a Data Access Strategy


Overview

The first step in working with data is to design a data access strategy. The same strategy should apply to all applications that access data, so it is important that you consider all potential data sources. If you spend the time carefully considering your options before you begin coding your applications, it will be much easier to manage those applications in a consistent way.

Designing an effective data access strategy involves decisions such as determining what network protocol to use and what connection method to utilize. The decisions that you will need to make depend on whether you need to connect to Microsoft SQL Server 2005 through Hypertext Transfer Protocol (HTTP) endpoints or whether a connection needs to be made to HTTP Web services using custom Simple Object Access Protocol (SOAP) methods. You also must consider whether you need to design connections between multiple instances of SQL Server 2005. This chapter will cover all these issues, along with determining which type of data access method to utilize.

Exam objectives in this chapter:

  • Design appropriate data access technologies.

  • Design an appropriate data access object model.




MCITP Self-Paced Training Kit Exam 70-442  .Designing and Optimizing Data Access by Using Microsoft SQL Server 2005
MCITP Self-Paced Training Kit Exam 70-442 .Designing and Optimizing Data Access by Using Microsoft SQL Server 2005
ISBN: 073562383X
EAN: N/A
Year: 2007
Pages: 162

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