Hi there,
We are trying to architect an application which is three tiered app. The DAL layer will be using Data Transfer Objects (business entities) are defined in the C#. The SQLServer spits the resultset which is in huge number (may be 5000 rows of data for every call to WCF)
Once the resultset comes to WCF we are tryign to massage that data to a business entity and trying to convert them to serailized binary formatted data. There seems to be a big performance hit for the application in this process. We are also sending the DataContracts to presentation layer thro another callback mechanism from WCF. There the data is not massaged it sends out as binary formatted data (serialized objects). There is a fat client (winforms) which handles the object and does deserialization to get the dataset that they display to the client. Is there any way we can use LLBLGen framework to get the resultset from SQL Server and map that to business entity without any code in DAL/WCF side. If so what will be the performance gain. If you can point me to a case study or any supporting data, it will help me to make a choice for LLBLGen at the earliest.
Thanks
John