new to linq, should I use Linq wiht SQL or Entities or Object ? plz guide

Hello,

Please guide for a person who is adopting Linq; how Linq should be used. Should I use Linq with entities or objects or with SQL.

Secondly is there speed advantage (fast data access) in any of Linq ways (entities or objects or with SQL) ?

Third and last, is using stored procedures with Linq faster than others ?

Thanks for your attention, time and sharing.

haansi

Re: new to linq, should I use Linq wiht SQL or Entities or Object ? plz guide

hi,

it depends on you data access that

if you want to use OR/M like Entity framework you should use linq to entity ,or if you want to use Linq To SQL (its anothre OR mapping way) or if you are using classic data access you can decide to use linq to object

Re: new to linq, should I use Linq wiht SQL or Entities or Object ? plz guide

One recommendation I have if you decide to use the EntityFramework, is to make sure to use EF with .NET Framework 4.0 in VS.NET 2010, as I have read and heard it is much improved over the version available in .NET Framework 3.5. Below are some of the details on the improvements from the ADO.NET Team Blog:

Whats new with Entity Framework in Visual Studio 2010 RC:

http://blogs.msdn.com/adonet/archive/2010/02/12/what-s-new-with-entity-framework-in-visual-studio-2010-rc.aspx

Here is some information on the performance comparison questions you asked-

Entity Framework and LINQ to SQL Performance (note the follow up comments about the much improved performance of the EF in VS.NET 2010 at the end):

http://toomanylayers.blogspot.com/2009/01/entity-framework-and-linq-to-sql.html

(Linq to SQL) Performance (5 part article):

http://blogs.msdn.com/ricom/archive/2007/06/22/dlinq-linq-to-sql-performance-part-1.aspx

ADO.NET Entity Framework Performance Comparison:

http://blogs.msdn.com/adonet/archive/2008/03/27/ado-net-entity-framework-performance-comparison.aspx

Hope this helps!

Re: new to linq, should I use Linq wiht SQL or Entities or Object ? plz guide

hi again,

at the end I suggest you to do not use entity framework cause of many challenges if you are new in this road.I'm working on EF 4.0 RC yes its more better than 3.5 but already have to many problems.