Tag: ADO.NET

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

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