Summary

This chapter implemented the foundation for the enterprise application: the data access layer. To support accelerated application development, minimize bugs , and enforce consistency, the chapter created a structured data access framework. Although the framework does place stricter requirements upon the developer, the additional security and maintainability make it worth the cost. This chapter also explored some of the ADO.NET architecture and its two foundation objects, DataProviders and DataSets. Additionally, the chapter laid the foundation for the enterprise application, IssueTracker, by defining its database schema, building its structure within the database, implementing stored procedures, and developing the data access framework. Finally, the chapter reviewed various issues and solutions that relate to typical enterprise application development.

In the next chapter, you will learn about directory services, how they work, and how corporate enterprises use them to manage user accounts. You will also interact with Active Directory, Microsoft's directory service solution, to build out a directory services business service that fits cleanly into the application framework and interacts with application business objects.