Click here to Skip to main content
12,957,526 members (60,311 online)
Rate this:
Please Sign up or sign in to vote.
See more:
I previously accessing database from my code using database objects like System.SqlClient, System.Data ..etc..
Now i am accessing database thru .dbml file.I feel this is more easy at development time.
I need to know what is the difference between this two in terms of performance. Which will perform more?

Posted 21-Jan-13 19:12pm
shabari7 22-Jan-13 2:27am
google => linq2sql vs
Rate this: bad
Please Sign up or sign in to vote.

Solution 1

It is not easy to comment on this. It totally depends on your application design.

In general, LINQ2SQL reduces development effort while it may not perform as good as your own data layer.
Rate this: bad
Please Sign up or sign in to vote.

Solution 2


LINQ2SQL is an ORM tool which will help you to implement the domain model concept. So basicall if you are working on large project and you want to implement the domain model in your project then you can think for ORM tools.

P.S Microsoft is not doing any further development on the LINQ2SQL project rather they are more focused on EF(Entity Framework) so if you are intended to learn ORM tools then instead of LINQ2SQL you should look into EF4.

Hope this information will help you.

Happy Programming.

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

    Print Answers RSS
Top Experts
Last 24hrsThis month
OriginalGriff 6,994
CHill60 3,550
Maciej Los 3,312
ppolymorphe 2,170
Jochen Arndt 1,973

Advertise | Privacy | Mobile
Web01 | 2.8.170525.1 | Last Updated 22 Jan 2013
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100