Top "Data-access-layer" questions

Data access layer is a layer of a computer program which provides simplified access to data stored in persistent storage of some kind, such as an entity-relational database.

What is the difference between DAO and DAL?

Having studied Java at school I am quite familiar with the DAO-pattern(Data access object). However at work I use .…

dao data-access-layer data-access-object
Ways of unit testing data access layer

I have be trying to look for an effective way in unit testing my data access layer in C#. I'm …

c# unit-testing testing persistence data-access-layer
What is the best way to improve performance of NHibernate?

I have an application that uses NHibernate as its ORM and sometimes it experiences performance issues due to how the …

.net performance nhibernate orm data-access-layer
Why is DataTable faster than DataReader

So we have had a heated debate at work as to which DataAccess route to take: DataTable or DataReader. DISCLAIMER …

.net data-access-layer sqldatareader
Where do you put SQL Statements in your c# projects?

I will likely be responsible for porting a vb6 application to c#. This application is a windows app that interacts …

c# sql winforms orm data-access-layer
BLL, DAL, OBJ and 3 layer architecture

My question is about 3 layer architecture. My project is briefly something like the below, however what annoyed me is after …

c# architecture data-access-layer layer bll
How do I design a Data Access Layer appropriately?

I have the following Data Access Layer (DAL). I was wondering if it's set up correctly, or if I need …

c# .net design-patterns architecture data-access-layer
Best "pattern" for Data Access Layer to Business Object

I'm trying to figure out the cleanest way to do this. Currently I have a customer object: public class Customer { …

c# asp.net design-patterns data-access-layer
What is the difference between Database Abstraction Layer & Data Access Layer?

I am actually stuck in 3-tier structure. I surfed the internet and found two terminologies "Database Abstraction Layer" & "Data …

data-access-layer 3-tier dbal doctrine-dbal
How do I use Dapper to get the return value of stored proc?

I'm using Dapper in asp.net mvc 4 project .net f/w 4.6.1 using sql server 2016 express <packages> <package …

c# sql-server asp.net-mvc dapper data-access-layer