Simple LINQ to SQL in C#

This article provides an introduction to employing LINQ to SQL within a Windows Forms application; the article will address the incorporation of LINQ to SQL into a win forms project, how to use LINQ to SQL to select, insert, update, and delete data, and how to use LINQ to SQL to execute stored procedures.  Select query examples will demonstrate ordering, filtering, aggregation, returning typed lists, returning single objects and values, and how to query across entity sets (which are essentially related tables associated by foreign keys).

Figure 1:  Application Main Form
The demonstration project included with the article is a simple win forms application; this example contains a datagridview control and a menu; the menu is used to execute each example query contained in the demonstration.
The application provides the following functionality:

• Return Full Tables
• Return Typed Lists
• Return Single Typed Values
• Insert Data
• Update Data
• Delete Data
• Execute Stored Procedures
• Select Filtered Lists
• Select Ordered Lists
• Perform Aggregate Functions

There is a great deal more that one can do with LINQ to SQL that is not contained in this demonstration however, the demonstration was geared towards the mechanics of performing the most typical types of queries that might be required within a data driven application.
LINQ to SQL Statements
This section will discuss some of the common techniques used in LINQ to SQL statement construction.  In a nutshell, LINQ to SQL provides the developer with the means to conduct queries against a relational database through a LINQ to SQL database model and related data context.  

http://www.c-sharpcorner.com/UploadFile/scottlysle/L2SinCS06022008035847AM/L2SinCS.aspx

Introducing LINQ

Introducing LINQ is the first part of a series of articles on Language Integrated Query (LINQ). This series will cover the core essentials of LINQ and its use with other technologies like ASP.NET, Win Forms and WPF.

This and the forthcoming articles are designed to be a comprehensive tutorial on LINQ, having completed the series you will have a thorough understanding of LINQ and C# 3.0.

All code in the series will use the latest publicly available CTP at the time of writing.

Introducing LINQ Series

Part 1 In this part you will learn how to the query in-memory collections.

Part 2 In this part we will look at querying relational data.

Part 3 In this part we will look a little more at what entities are, as well as taking a closer look at the key types we can use and their application

.

Part 4 In this part of the series we will use LINQ, ASP.NET and ASP.NET AJAX to replicate the to-do list that Scott Guthrie created a while back to show off the features of ASP.NET AJAX.

Part 5 In this part of the series I will explain the DataContext class in depth through a series of examples and explanations.

Read More : http://dotnetslackers.com/articles/csharp/IntroducingLINQ1.aspx

Programming Microsoft LINQ

http://www.microsoft.com/learning/en/us/book.aspx?ID=10827Get comprehensive guidance for using the Microsoft Language Integrated Query (LINQ) Project—with in-depth insights from two experienced developers. Data-rich applications can be difficult to create because of the tremendous differences between query languages used to access data and the programming languages commonly used to write applications. This practical guide covers the intricacies of LINQ, a set of extensions to the Visual C# and Visual Basic programming languages. Instead of traversing different language syntaxes required for accessing data from relational and hierarchical data sources, developers will learn how to write queries natively in Visual C# or Visual Basic—helping reduce complexity and boost productivity.

You can download and read sample chapters from the follwing link


Link: http://programminglinq.com/


View More Detail: http://www.microsoft.com/learning/en/us/book.aspx?ID=10827http://www.microsoft.com/learning/en/us/book.aspx?ID=10827