Language Integrated Query (LINQ), Leren programmeren in LINQ Options

[DEADmike]

Wow, programmeren in LINQ doe je niet zomaar even!
Daarom heb ik besloten om mij hier wat meer in te verdiepen.

In dit topic zal ik nuttige resources (en code voorbeelden) verzamelen.


Online Resources:
- http://weblogs.asp.net/zeeshanhirani/default.aspx

[DEADmike]

LINQ to SQL

LINQ to SQL - 5 Minute Overview:

LINQ to SQL allows .NET developers to write “queries” in their .NET language of choice to retrieve and manipulate data from a SQL Server database. In a general sense, LINQ to SQL allows us to create SQL queries in our preferred .NET language syntax and work with a strongly types collection of objects as a return result. We can make changes to these objects then save changes back to the database.

To get an idea of the syntax for LINQ to SQL, we will be using the following SQL database schema. It is a simple software registration and helpdesk. It is populated with sample data and has foreign-key relationships defined where appropriate.

http://www.hookedonlinq.com/LINQtoSQL5MinuteOverview.ashx

Nuttig artikel!

Using LINQ to SQL (Part 1):

LINQ to SQL is an O/RM (object relational mapping) implementation that ships in the .NET Framework "Orcas" release, and which allows you to model a relational database using .NET classes. You can then query the database using LINQ, as well as update/insert/delete data from it.

LINQ to SQL fully supports transactions, views, and stored procedures. It also provides an easy way to integrate data validation and business logic rules into your data model.

http://weblogs.asp.net/scottgu/archive/200...sql-part-1.aspx


More resources:
- http://davidhayden.com/blog/dave/archive/2...erDatabase.aspx
- http://blogs.msdn.com/charlie/archive/2006...d-distinct.aspx