Tag: Data Access Layer

May 08

How to create SQL Data Access Layer in C# using ADO.NET – Part 2

How to create SQL Data Access Layer in C# using ADO.NET – Part 2 1.   Introduction In my previous post we discussed about the implementation of SQL Data access layer using C#. We created SQLHelper class to create CRUD functions to return ADO.NET objects like DataTable, DataSet, DataReader and Scalar values. Later on we created …

Continue reading »

May 06

How to create SQL Data Access Layer in C# using ADO.NET – Part 1

How to create SQL Data Access Layer in C# using ADO.NET – Part 1 1.   Introduction In my previous post we discussed about the implementation of generic data access layer using factory pattern and using DbProviderFactory. This article would be useful for those developers who use SQL Server as a database and C# as a …

Continue reading »

May 03

Generic Data Access Layer in C# using DbProviderFactories

Generic Data Access Layer in C# using DbProviderFactories 1.   Introduction In my previouspost we discussed about the implementation of generic data access layer using factory pattern. We created common interface functions and overridden into derived classes to access provider specific ADO.NET objects. The problem with that implementation is the code complexity and number of classes.  …

Continue reading »

May 02

Generic Data Access Layer in C# using Factory Pattern

Generic Data Access Layer in C# using Factory Pattern 1.   Introduction A data access layer is an important part of any software application. Typically, a large enterprise(N-Tier) application will have one or more databases to store the data. On the top of these databases the Data Access Layer(DAL) is created. A business layer which contains …

Continue reading »