Can Reports use Datasetrs in a 3-tier environment

Can Reports use Datasetrs in a 3-tier environment

Old forum URL: forums.lhotka.net/forums/t/6046.aspx


Warren posted on Tuesday, December 23, 2008

My first CSLA application is in user-acceptance phase and includes 15 RDLC reports which use datasets for the datasource. The datasets are populated by a tableadaptors fill methods which call stored procedures.

I found the whole procedural to OOPS and CSLA learning curve a little overwhelming at the beginning and opted to use datasets instead of using business objects for the report datasource.

Currently the application is functioning in a 2 tier environment. Is is possible to upgrade to 3 tier given and retain the use of datasets and sprocs an if so what is the general approach.

Any advice is appreciated.

Thanks

JoeFallon1 replied on Wednesday, December 24, 2008

Yes - I think you can do it.

I have 1 or 2 BOs that simply contain a variable declared as a Dataset (or DataTable). Since either is serializable as of .Net 2.0, you can have the BO contain the dataset, use the CSLA framework to move the object from the client to the server and back and then just use the read only property that exposes the dataset.

Joe

 

Copyright (c) Marimer LLC