Data access level

Question

how can we create a common data access layer that can be used by any asp.net application using a different data provider or web service?

Can I create a data access layer for an application using webservice?

Answer 1

You can view the repository template. A repository is a facade that represents stored objects, as if they were in a collection in memory. Whichever provider you choose to receive the data is hidden behind the repository interface.

IRepository with LINQ to SQL

Code Design Tutorial

Sample Fredrick Calcet

Answer 2

You have many options! :-)

, (DAL) asp.net -. .

, , , DAL , / .

:

• Linq-to-SQL , SQL Server Linq-to-SQL.
• ( "", "EntityRepository", , EntityReposity.GetByID(int id) EntityRepository.GetByForeignKey( fk)
• (NHibernate, ADO.NET)
• webservice

- .

. - , :

• .NET - 1
• DAL VS 2005 ASP.NET 2.0

Answer 3

www.asp.net:

DataAccess

Answer 4

, . , , , , 3/4.

, , - . , , , CMS. , IQueryable, , # POCO ( CLR).

public interface ICMSRepository {
    IQueryable<ContentSection> GetContentSections();
    void SaveContentSection(ContentSection obj);
}

, LINQ to SQL, POCO . , IQueryable, , . :

public static IQueryable<ContentSection> WithID(this IQueryable<ContentSection> qry, int ID) {
    return from c in qry select c;
}

//Allow you to chain repository and filter to delay SQL execution
ICMSRepository _rep = new SqlCMSRepository();
var sec = _rep.GetContentSections().WithID(1).SingleDefault();

Interface - , .

, ASP.Net, . , , singleton, (XML, , SQL, MySql ..). singleton . .

.

Answer 5

IRepository of T - . GetAll, GetByID, Insert, Delete Submit.
- Repository / .
, IQueriable GetAll, , IRepository, IQueriable. . .

Answer 6

:

IDbConnection IDbCommand IDbDataAdapter IDataReader