ADO.NET Data Access Layer

Data Access Layer

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.

< BACK 1 of 1 NEXT >