Need some help in WCF DataContracts and resultset that are fetched from SQL Server

Posts   
 
    
johnpremi
User
Posts: 1
Joined: 04-Feb-2009
# Posted on: 04-Feb-2009 13:38:12   

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

Walaa avatar
Walaa
Support Team
Posts: 14983
Joined: 21-Aug-2005
# Posted on: 04-Feb-2009 17:05:03   

Did you check the WCF project example in the download section of our website?