Kevin MD Hough

C# 2010 Coding Briefs Data Access

Kevin MD Hough

In today&#39;s high-tech, information driven world, the security of personal data is vital. We have all heard the horror stories of personal data being compromised from companies, both large and small. <br><br>The data access framework that we will develop in Coding Briefs will allow us to create datasets, execute queries, and select data in a secure, managed process. <br><br>This framework will provide a solid foundation for managing secure data access through stored procedures, allowing us to select, insert, update, and delete records from a SQL Server database. We will have access to parameterized queries and will develop an automated process for discovering stored procedure parameters. <br><br>The major areas that we will address in this brief are as follows: <br>-Discussing the Data Access Framework (DAL) <br>-Importing Libraries and Declaring Values <br>-Managing the Database Connections <br>-Selecting Records <br>-Manipulating Data <br>-Preparing the Select and Execute Methods <br>-Working with Parameters <br>-Testing the Data Access Framework <br><br>And, as a bonus, two complete sample applications have been added; one for Windows, and one in ASP .Net, that will test all of the features on the data access framework.