This manual covers the C# 2010 Coding Briefs Data Access, published in 2013 by Runtime Publishing, LLC, authored by Kevin MD Hough. It is designed for developers working with C# and SQL Server databases, focusing on secure data access. The content delves into the development of a secure, managed data access framework, executing queries, and performing database operations such as inserting, updating, and deleting records. It also explores the utilization of stored procedures and parameterized queries for enhanced security and efficiency, including automated parameter discovery.
This document serves as a comprehensive guide for understanding the Data Access Framework (DAL), securely managing database connections, and implementing various data manipulation operations. It aims to equip developers with the expertise to work effectively with parameters and stored procedures, and to test and validate their data access framework. The manual addresses the critical need for secure personal data management, making it relevant for professionals in today's information-driven landscape.
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.
Author: Hough, Kevin MD
Publisher: Runtime Publishing, LLC
Illustration: N
Language: ENG
Title: C# 2010 Coding Briefs Data Access
Pages: 00044 (Unencrypted EPUB)
On Sale: 2013-02-21
SKU-13/ISBN: 9780983615125
Category: Computers : Programming Languages - C#
Category: Computers : Database Management - General
Category: Computers : Web - Web Programming
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.
Author: Hough, Kevin MD
Publisher: Runtime Publishing, LLC
Illustration: N
Language: ENG
Title: C# 2010 Coding Briefs Data Access
Pages: 00044 (Unencrypted EPUB)
On Sale: 2013-02-21
SKU-13/ISBN: 9780983615125
Category: Computers : Programming Languages - C#
Category: Computers : Database Management - General
Category: Computers : Web - Web Programming
