LINQ result to object class very slow

Verify your request with LINQPad: http://www.linqpad.net/[^].

Using that tool, you will have an idea how your request is translated into SQL and the time it takes.

Does the data come from a single table or multiple tables? If it come from multiple tables, the first thing to check would be to see if lot of round-trip are made to the server.

And effectively for large tables, you have to uses paging or virtual loading of the data.

I second the advice to no return 9369 records, use paging. However, I would not use LINQ to access a SQL DB in general, unless your query is incredibly simple. Never use auto generated stuff if you can control it more directly.

Hi all,

Thanks for replying. The paging was a good idea. I searched google for examples and found something that would work:

1. ADO.NET (so no LINQ, is also easier for me because I can re-use the queries in the old ASP project)
2. Result from the query is send back in a dataset.
3. Export the dataset to XML
4. Send back the XML from the webservice to the Silverlight application
5. In the Silverlight application the XML is put in a list with the object class.
6. Add a DataPager to the usercontrol
7. Put the list XML in a PagedCollectionView
8. Bind the PagedCollectionView to the DataPager and datagrid

Done!

Works like a charm. Loading time is now 1 to 2 seconds.

Thanks for bringing this up!