Click here to Skip to main content
Click here to Skip to main content
Search within:



 
Comments & Discussions

Performance comparisons LinQ to SQL,ADO,C#

By , 25 May 2008
 
source_file_and_sample_application.zip
Source File and Sample Application
Data
ADODataSetQuery.xml
ADOInsert.xml
ADOInsertDirect.xml
ADORead.xml
csharpObjects1.xml
csharpxmlReading.xml
InsertSP.sql
LinQInsert.xml
LinQInsertDirect.xml
LinQObjects1.xml
LinQObjects2.xml
LinQQueryDataset.xml
LinQRead.xml
LinQXmlRead.xml
RetrieveUsingADO
RetrieveUsingADO
bin
Debug
RetrieveUsingADO.exe
RetrieveUsingADO.pdb
RetrieveUsingADO.vshost.exe
RetrieveUsingADO.vshost.exe.manifest
Release
RetrieveUsingADO.exe
RetrieveUsingADO.pdb
RetrieveUsingADO.vshost.exe
RetrieveUsingADO.vshost.exe.manifest
obj
Debug
RetrieveUsingADO.csproj.FileListAbsolute.txt
RetrieveUsingADO.exe
RetrieveUsingADO.pdb
TempPE
Release
RetrieveUsingADO.csproj.FileListAbsolute.txt
RetrieveUsingADO.exe
RetrieveUsingADO.pdb
TempPE
Program.cs
Properties
AssemblyInfo.cs
RetrieveUsingADO.csproj
RetrieveUsingADO.sln
RetrieveUsingADO.suo
RetriveUsingLinQ
RetriveUsingLinQ
app.config
bin
Debug
RetriveUsingLinQ.exe
RetriveUsingLinQ.exe.config
RetriveUsingLinQ.pdb
RetriveUsingLinQ.vshost.exe
RetriveUsingLinQ.vshost.exe.config
RetriveUsingLinQ.vshost.exe.manifest
Release
RetriveUsingLinQ.exe
RetriveUsingLinQ.exe.config
RetriveUsingLinQ.pdb
RetriveUsingLinQ.vshost.exe
RetriveUsingLinQ.vshost.exe.config
RetriveUsingLinQ.vshost.exe.manifest
obj
Debug
Interop.Microsoft.Office.Core.dll
RetriveUsingLinQ.csproj.FileListAbsolute.txt
RetriveUsingLinQ.csproj.ResolveComReference.cache
RetriveUsingLinQ.exe
RetriveUsingLinQ.pdb
TempPE
RetriveUsingLinQfromSQL.designer.cs.dll
Release
Interop.Microsoft.Office.Core.dll
RetriveUsingLinQ.csproj.FileListAbsolute.txt
RetriveUsingLinQ.csproj.ResolveComReference.cache
RetriveUsingLinQ.exe
RetriveUsingLinQ.pdb
TempPE
RetriveUsingLinQfromSQL.designer.cs.dll
Program.cs
Properties
AssemblyInfo.cs
Settings.Designer.cs
Settings.settings
RetriveUsingLinQ.csproj
RetriveUsingLinQ.sln
RetriveUsingLinQ.suo
RetriveUsingLinQfromSQL.dbml
RetriveUsingLinQfromSQL.dbml.layout
RetriveUsingLinQfromSQL.designer.cs
 
<?xml version="1.0" encoding="utf-8" ?>
<configuration>
    <configSections>
    </configSections>
    <connectionStrings>
        <add name="RetriveUsingLinQ.Properties.Settings.AdventureWorksConnectionString"
            connectionString="Data Source=B4-2F-333-F2Z9\SQL2005;Initial Catalog=AdventureWorks;Integrated Security=True"
            providerName="System.Data.SqlClient" />
    </connectionStrings>
</configuration>

By viewing downloads associated with this article you agree to the Terms of use and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

About the Author

 KshitijPandey
Unknown
Member
No Biography provided

About Article
To compare existing approaches of accessing data (arrays,tables etc) with the new ones release with c#3.0 and LinQ.
Type Article
Licence CPOL
First Posted 25 May 2008
Views 36,081
Downloads 293
Bookmarked 33 times

, +
Top News

The Next Version of Android - Some of What's Coming

Get the Insider News free each morning.
Related Videos
84 Construct 2 - comparison operators
MVC 3: Creating an Entity Framework Model Part 1
Performance Comparisons LINQ to SQL / ADO / C#
How to improve your LINQ query performance by 5 X times?
See the SQL Generated by LINQ
Linq to SQL Performance Considerations - Part 2
Dynamite: High Performace Dynamic Sorting Using Expressions
A Generic IEqualityComparer for Linq Distinct()
Building an embedded database engine in C#
Learn SQL to LINQ (Visual Representation)
Increase the performance of your LINQ application with a few .NET tricks
.NET Best Practice No: 3:- Using performance counters to gather performance data
LINQ to SQL Performance Considerations
Entity Framework Performance
AutoComplete TextBox with SubString search, similar to SQL Like or Contains
A Look at LINQ
Cache IQueryable for Better LINQ-to-SQL Performance
Improving Entity Framework Query Performance Using Graph-Based Querying
Optimizing LINQ Queries using DataLoadOptions
LINQ to SQL Database Synchronizer
LINQ and Dynamic Predicate Construction at Runtime
LINQ vs ADO.Net - A Practical Overview
Permalink | Advertise | Privacy | Mobile
Web01 | 2.6.130523.1 | Last Updated 26 May 2008
Article Copyright 2008 by KshitijPandey
Everything else Copyright © CodeProject, 1999-2013
Terms of Use
Layout: fixed | fluid