CodeProject. Upcoming stories. CodeGuru - Microsoft developers related ideas, articles, tips, tricks, comments, downloads, and so much more related to programming in areas including C++, Visual C++, C#, Visual Basic, .NET Framework, and more. Tutorials on Microsoft .NET and Web Technologies. C#, Visual Studio 2010, Silverlight, ASP.NET, WPF, WCF, WF, and Windows 7 Community. .NET Tutorials for Beginners and Intermediate level professionals. Creating a Data Access Layer in .NET - Part 1. By Wayne Plourde If you have been in the software development business for any length of time, I am sure that you have read books and articles extolling the virtues of designing your Web-based or client-server based applications in multiple tiers or layers - distinctly separating code intended for Presentation (User Interface), Business Rules, and Data Access (see Robert Chartier's article on n-tier application architecture - ).
Fig #1 - Basic N-tier Model In this two-part series, I will demonstrate one approach for building a Data Access Layer (DAL) in ADO.NET using the latest whiz-bang tools in Visual Studio .NET (VS .NET). In the end, I hope to establish a simple process that will create a DAL suitable for Web applications and Web services. Here is a summary of the topics we will discuss: Establishing goals for designing a DAL Understanding the importance of establishing development, staging and production platforms.