In today'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.
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.
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.
The major areas that we will address in this brief are as follows:
• Discussing the Data Access Framework (DAL)
• Importing Libraries and Declaring Values
• Managing the Database Connections
• Selecting Records
• Manipulating Data
• Preparing the Select and Execute Methods
• Working with Parameters
• Testing the Data Access Framework
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.
To view this DRM protected ebook on your desktop or laptop you will need to have Adobe Digital Editions installed. It is a free software. We also strongly recommend that you sign up for an AdobeID at the Adobe website. For more details please see FAQ 1&2. To view this ebook on an iPhone, iPad or Android mobile device you will need the BlueFire Reader or Txtr app. These are free, too. For more details see this article.
|Size: ||3.6 MB|
|Publisher: ||Runtime Publishing, LLC|
|Date published: ||Jun 2011|
|Read Aloud: ||not allowed|