Popular Articles
Last viewed:
- Using a Remote Terminal Licensing Server
- Windows Server 2003 Configure RRAS (Routing and Remote Access Service) Site to Site VPN
- Fix for Firefox click() event issue
- Tutorial for Configuring Silverlight 4, Entity Framework and WCF RIA Services in Separate Component Assemblies (DLL’s)
- Connecting to SQL Server, Oracle, and MySQL with Database or Windows Authentication
- SQL Server Log File (AKA LDF file) is huge - reduce size
Recent comments
- Awsome!!
7 hours 6 min ago - C# insert image
21 hours 59 min ago - jkll
3 days 10 hours ago - Thank You
4 days 9 hours ago - Another approach
6 days 10 hours ago - Issue
1 week 26 min ago - thanks
1 week 11 hours ago - Calendar date time
1 week 16 hours ago - Nice Explanation
1 week 20 hours ago - ramya
1 week 3 days ago

You can get speed equivalent to direct
You can get speed equivalent to direct DataReader code when you use a L2S compiled query. Otherwise you are always going to be much slower since you are doing a lot of work on the client to translate the query and generate the materializer. How much slower you are is going to be based on factors that vary depending on the query, the location of the database and the amount of data in the result.