[quote user="ElCapitan"]...The function in the DAL is called by the BLL and the DAL opens a connection, and the command does an ExecuteReader. I understand that it is a good option for retrieving data. Surely though if the dr is returned to the BLL, the connection is still open...[/quote] It's...
Posted to
Architecture
(Forum)
by
SergeyS
on
03-22-2008, 12:00 AM
Filed under: scalability, SQL Server 2005, 3-Layer Architecture, 3tier, 3-Tier Architecture, 3-tier programming, architecture, asp .NET 2.0, Basic Architecture Design, Best Practices, bll, Buisness layer, business logic layer, dal, data access layer, datalogic layer, dataobjects, Dataset, dataset datareader 3-tier mvc, datatable, database driven, database object, asp.net2.0, ASP.NET Architecture, Typed DataSet tableadapter, "system Design", arcitecture, asp.net 2.0 sql server, datareader, N-Tier, Asp.Net 2.0