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.

How do I reference the Sqlite db file in the App_Data folder for my ASP.NET Web Application?

I'm currently storing my sqlite db file in the App_Data folder as per ASP.NET best pattern and practices. …

c# asp.net sqlite data-access-layer appdata
Where is the line between DAL and ORM?

The terms are often thrown around interchangeably, and there's clearly considerable overlap, but just as often it seems implied that …

orm terminology data-access-layer database-design
In-memory DBMS's for unit testing

I am looking for satisfactory options for unit testing my .NET DAL classes; since they're DAL classes, they access the …

.net data-access-layer embedded-database in-memory
DDD vs N-Tier (3-Tier) Architecture

I have been practicing DDD for a while now with the 4 distinct layers: Domain, Presentation, Application, and Infrastructure. Recently, I …

domain-driven-design data-access-layer n-tier-architecture
How to use DTO's between UI, BLL, DAL

I'm trying to write a small app with very strict boundaries between BLL and DAL and am now wondering what …

c# user-interface dns data-access-layer bll
Entity Framework - layered design - Where to put connectionstring?

I am using a layered architecture with the Entity Framework as my datalayer with a bunch of repositories on top …

c# entity-framework data-access-layer n-tier-architecture
What are the pros/cons of choosing between static and instance data access classes in a web app?

I've read several other questions on this topic (here, here, and here), but have yet to see a great answer. …

c# asp.net class-design data-access-layer
ASP.net DAL DatasSet and Table Adapter not in namespace - Northwind Tutorial

I've been attempting to walk through the "Creating a Data Access Layer" tutorial found http://www.asp.net/learn/data-access/…

asp.net data-access-layer data-access northwind typed-dataset
What are the disadvantages of Typed DataSets

I come from a world that favors building your own rather than rely on libraries and frameworks built by others. …

.net ado.net data-access-layer dataset
Extension Methods for Indexers, would they be good?

Extension Methods for Indexers, would they be good ? I was playing around with some code that re-hydrates POCO's. The code …

c# methods data-access-layer indexer