LINQ to SQL and ADO.NET Data Services: Working Together
page 1 of 5
Published: 10 Jun 2009
In this article, Sergey examines the relationship between LINQ, SQL and ADO.NET data services with the help of a sample project. He begins by demonstrating the procedures used to detect key fields in a data model and to update data including the steps required to implement the IUpdatable interface.
by Sergey Zwezdin
Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 27559/ 66


The LINQ to SQL platform works faster than the ADO.NET Entity Framework. It occurs because LINQ to SQL has no difficult mappings which exist in ADO.NET Entity Framework. However, many examples, which are shown in ADO.NET Data Services, are based on ADO.NET Entity Framework. It is logical, that in the loaded applications, the power of ADO.NET Entity Framework is not important; however, a speed criterion is very important. ADO.NET Data Services platform does not impose constraints on data access technology and also allows construction of web service on the basis of LINQ to SQL.

However, in practice, while using ADO.NET Data Services together with LINQ to SQL, some questions may appear. The goal of this article is to clear up such questions and to use ADO.NET Data Services and LINQ to SQL correctly.

There are two problems which appear while using LINQ to SQL as a data access platform for service of ADO.NET Data Services: detection of key fields in data model and updating of data.

View Entire Article

User Comments

Title: Mr   
Name: Nafees Khan
Date: 2012-12-05 11:36:01 PM
I need to linq simple example......
Title: Mr   
Name: Ravi Bhushan Singh(Patna)
Date: 2010-09-19 9:49:15 PM
i need to code of linq
Title: IT   
Name: Shedeep
Date: 2010-08-24 1:39:59 AM
I need to learn more code
Title: IT   
Name: chhon
Date: 2010-04-22 3:56:02 AM
I need to learn more any code such
Title: santhanakumar   
Name: kumar
Date: 2010-02-16 8:50:03 AM
yes,i want see u some of the document in development
Title: LINQ to SQL and ADO.NET Data Services: Working Together   
Name: Jagdeep Mankotia
Date: 2010-02-02 4:00:21 AM
Very good article helpful.

Covered almost all the important things.

== Jagdeep Mankotia
Title: Excellent Article   
Name: Damian
Date: 2010-01-18 2:19:21 AM
Excellent article and clear example of how to write a nice generic IUpdatable Interface. Thanks very much, just what I needed, (I was stuck)
Title: Good Article   
Name: Hamid Raza Saleemi
Date: 2009-06-16 8:51:58 PM
Good and conceptual article for Linq and addressing the lot of core issues

Community Advice: ASP | SQL | XML | Regular Expressions | Windows

©Copyright 1998-2024  |  Page Processed at 2024-06-15 4:42:49 AM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search