Click here to Skip to main content
12,399,179 members (54,989 online)
Rate this:
 
Please Sign up or sign in to vote.
See more: ASP.NET SQL-Server
Hi,
I previously accessing database from my asp.net 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?

Thankyou
ypki
Posted 21-Jan-13 19:12pm
Comments
shabari7 22-Jan-13 2:27am
   
google => linq2sql vs ado.net
Rate this: bad
 
good
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.
  Permalink  
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 2

Hi,

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.
Smile | :)
  Permalink  

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


Advertise | Privacy | Mobile
Web02 | 2.8.160721.1 | Last Updated 22 Jan 2013
Copyright © CodeProject, 1999-2016
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