Browse by Tags

Related Posts

  • Re: Return a DataReader - Is this good practice?

    [quote user="ElCapitan"]...Yeh I understand that this is a good way of doing things too but not without its drawbacks. Many hits to a page that constantly calls a couple of hundred 'rows' of business objects will be much heavier on the application surely because all the data is 'in...
    Posted to Architecture (Forum) by SergeyS on 03-24-2008, 12:00 AM
    Filed under: scalability, SQL Server 2005, 3-Layer Architecture, 3tier, 3-Tier Architecture, 3-tier programming, asp .NET 2.0, Basic Architecture Design, Best Practices, bll, Buisness layer, business logic layer, Connection pooling, dal, data access layer, datalogic layer, dataobjects, Dataset, dataset datareader 3-tier mvc, datatable, database object, asp.net2.0, ASP.NET Architecture, sql server, Typed DataSet tableadapter, arcitecture, asp.net 2.0 sql server, datareader, load balancing, Patterns & Practices, N-Tier, Asp.Net 2.0
  • Re: Return a DataReader - Is this good practice?

    [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
  • Mass insert / update External data into Internal SQL Database

    Hola! I'm currently building a site that uses an external database to store all the product details, and an internal database that will act as a cache so that we don't have to keep hitting the external database to retrieve the products every time a customer requests a list. What I need to do is retrieve...
    Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by blackred on 11-15-2006, 12:00 AM
    Filed under: update, DAL, Data, Data Access, DataAdapter Update, Database, DataSet, BLL, Help
  • Re: Strongly typed DataSet connection string

    I think he tells you that he has a layered solution where e.g. UI - is one project BLL is one class library ==> one assembly DAL is another project ==> another assembly
    Posted to Data Access and ObjectDataSource Control (Forum) by salgo60 on 03-27-2007, 12:00 AM
    Filed under: ASP.NET, DataSet, Web.Config, BLL
Page 1 of 1 (4 items)