Rajaram Shelar
Rajaram Shelar

Reputation: 7897

Use of Datatables in WCF Service

I have a web applications consuming data access from the WCF services. around 70% of the data comes as list or Collections and remaining from a Datatable. I am experiencing some performance(speed) issue while the loading the screen.

After searching on internet i found datatable slows downs the speed 6 times than the collections. For using Collections I need to have entity class for all those. I want to serialise or make collection of datatables so that they can tranfer little fast thorugh the netwrok. What would be the efficient way to do this. In case of serialization or converting it to collection? Please help me out.

Thanks

Upvotes: 0

Views: 346

Answers (2)

flayn
flayn

Reputation: 5322

Have a look at the DataTableSurrogate, it is also used in the SyncFramework for serializing DataTables.

MSDN Data Table Surrogate

Upvotes: 0

Echilon
Echilon

Reputation: 10264

You could try an Entity Model with POCOs in the Entity Framework 5.

Upvotes: 1

Related Questions