Loading data into BLL and DAL from database? RRS feed

  • Question

  • My stored procedure is returning different data sets on 4 specified parameters. Once we pass those four parameters it returns one out put from 13 different outputs with different column names.
    In my DAL how i can use this kind of output where i don't know how many columns are reliving and what data-types are retuning from that particular stored procedure.
    Yeah one thing more We are talking about thousands of rows so we have to implement database side paging as well.
    And also what will be good option in BLL to pass data from DAL to BLL. We have to use these two tiers so in future can be hosted on different machine for application scalability purpose.

    Khurram Nazir
    Tuesday, December 15, 2009 3:10 PM

All replies