Developers: Learn a New Programming Language or App Development with Deitel LiveLessons Videos!
s
menu
menu
Login  |  Register  |  Media Kit  |  Press  |  Contact Us  |   Twitter Become a Deitel Fan on Facebook  
Custom Search
Resource Center
Contents

ADO.NET Resource Center
Data Access Layer
A Generic Data Access Layer in ADO.NET
http://www.sql-server-performance.com/articles/asp_ado/Generic_Data_Access_Layer_Part1_p1.aspx
Article: “Implementing a Generic Data Access Layer in ADO.NET (Part 1),” by Joydip Kanjilal. Discusses the implementation of a generic (a provider independent Data Access Layer) in ADO.NET, strategies involved, implementation of the Data Access Layer (DAL) framework, understanding of the ADO.NET library, that classes that constitute the ADO.NET library, interfaces that the classes implement and the data providers available in ADO.NET.
A Generic Data Access Layer in ADO.NET (2)
http://www.sql-server-performance.com/articles/asp_ado/Generic_Data_Access_Layer_Part2_p1.aspx
Article: “Implementing a Generic Data Access Layer in ADO.NET (Part 2),” by Joydip Kanjilal. Discusses how to can implement the DatabaseHelper class (for performing the actual database operations), how the connection to the database is established based on the provider type chosen and the command object created, ADO.NET data providers, and the methods for performing the CRUD (Create, Retrieve, Update, Delete) (including ExecuteScalar, ExecuteReader, ExecuteNonQuery and ExecutedataSet).
A Generic Data Access Layer in ADO.NET (3)
http://www.sql-server-performance.com/articles/asp_ado/Generic_Data_Access_Layer_Part3_p1.aspx
Article: “Implementing a Generic Data Access Layer in ADO.NET (Part 2),” by Joydip Kanjilal. Discusses the other classes and how to use this framework to perform various CRUD (Create, Retrieve, Update, Delete) operations, the DBManager class, the DBManagerBase abstract class, the AddParameter method, and using the DBManager class.
Data Access Code in ASP.NET 2.0 & ADO.NET 2.0
http://msdn2.microsoft.com/en-us/library/ms971499.aspx
Article: "Writing Generic Data Access Code in ASP.NET 2.0 and ADO.NET 2.0," by Shahram Khosravi. Discusses the provider pattern in ADO.NET 2.0, connection strings, data source controls, tabular data source controls, switching from one data source control to another, the insert and delete operations, and hierarchical data source controls.

Discounts on SafariBooksOnline.com subscriptions

foot
Update :: January 19, 2018