LINQ to SQL Tutorials & Learning Resources
LINQ to SQL
LINQ to SQL is a component of .NET Framework version 3.5 that provides a run-time infrastructure for managing relational data as objects. [...] In LINQ to SQL, the data model of a relational database is mapped to an object model expressed in the programming language of the developer.
LINQ to SQL: .NET Language-Integrated Query for Relational Data
LINQ to SQL provides a runtime infrastructure for managing relational data as objects without losing the ability to query. Your application is free to manipulate the objects while LINQ to SQL stays in the background tracking your changes automatically. (119 printed pages)
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 - 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.
In this article I will show you how you can use LINQ To SQL to perform CRUD operations on a SQL Server database. I will use Northwind database and build an ASP.NET application to demonstrated the capabilities of LINQ To SQL. You can download Northwind database here.
LINQ to SQL (formerly called DLINQ) - Wikipedia
The LINQ to SQL provider allows LINQ to be used to query SQL Server databases, including SQL Server Compact databases. Since SQL Server data may reside on a remote server, and because SQL Server has its own query engine, LINQ to SQL does not use the query engine of LINQ. Instead, it converts a LINQ query to a SQL query that is then sent to SQL Server for processing.
10 Tips to Improve your LINQ to SQL Application Performance
Since LINQ to SQL is a code generator and an ORM and it offers a lot of things, it is normal to be suspicious about performance of it. These are right up to a certain point as LINQ comes with its own penalties. But there are several benchmarks showing that DLINQ brings us up to %93 of the ADO.NET SQL DataReader performance if optimizations are done correctly.
A few short words to say I’ve put together a cheat sheet for LINQ to SQL with one page for C# and another for VB.NET. It shows the syntax for a number of common query operations, manipulations and attributes and can be a very useful quick reference. (Download available from post)
Where LINQ to SQL shines as compared to other ORM tools in the market is the fact that it abstracts away the database structure behind our business objects, it also supports a query language called LINQ. LINQ to SQL solves the mismatch between the object oriented and relational database world. In an application we deal in terms of our domain objects such as customer and orders.
Creating IN Queries With Linq To Sql
Props on this one go to Scott Hanselman who pulled me back from the edge of the cliff last night. I was particularly distraught in getting a MIX demo together where I had to do some queries using LINQ, and I couldn't for the life of me figure out how to fashion an IN query!
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.
Scott Guthrie's Using LINQ to SQL Tutorials
Back when Visual Studio 2008 came out, Scott Guthrie wrote an excellent series of blog posts on using LINQ to SQL. Unfortunately, the various installments are not easy to follow when starting from Part 1 and going onward, so I've decided to gather and organize the links here for myself and for anyone else interested in his tutorial.
Linqer - SQL to LINQ converter
Linqer is a SQL to LINQ converter tool. It helps you to learn LINQ and convert your existing SQL statements.
Linq to Sql Profiler is a real-time visual debugger allowing a development team to gain valuable insight and perspective into their usage of Linq to Sql.
Beginning LinQ To SQL In C#.NET
In this tutorial, I will discuss about basic linq to sql overview, then how to get started very quickly with its usage on our C#.NET based applications(This can be used in both desktop and web applications in the exactly same way).
Grouping and Aggregating When Querying LINQ to SQL in Visual Studio. This is the second article in a series focusing on querying using “LINQ to SQL.” It covers grouping and aggregating data with both SQL and respective LINQ examples in VB.NET and C#.
Creating Model Classes with LINQ to SQL
The goal of this tutorial is to explain one method of creating model classes for an ASP.NET MVC application. In this tutorial, you learn how to build model classes and perform database access by taking advantage of Microsoft LINQ to SQL.
LINQ to SQL (Part 8 - Executing Custom SQL Expressions)
One of the questions a few people have asked me since doing these posts has been "what if I want total control over the SQL expressions used by LINQ to SQL - but I don't want to use SPROCs to-do it?" Today's blog post will cover that - and discuss how you can use custom SQL expressions that you provide to populate your LINQ to SQL data model classes, as well as perform insert, updates, and deletes.
LINQ Learning Guide: LINQ to SQL
LINQ Quick Start
LINQ and Visual Studio 2008's new language features
LINQ Providers
Update on LINQ to SQL and LINQ to Entities Roadmap
Since the release of LINQ to SQL and the Entity Framework, many questions have been raised about the future plans for the technologies and how they will relate to each other long term.
This post has many comments.
LINQ to SQL - MSDN Forums
Questions and discussion about LINQ to SQL. For LINQ to Entities see the “ADO.NET Entity Framework and LINQ to Entities" forum.
"LINQ to SQL provides a runtime infrastructure for managing relational data as objects without losing the ability to query. Your application is free to manipulate the objects while LINQ to SQL stays in the background tracking your changes automatically."
LINQ to SQL: Basic Concepts and Features
In this article, we will cover the basic concepts and features of LINQ to SQL, which include:
- What is ORM
- What is LINQ to SQL
- What is LINQ to Entities
- Comparing LINQ to SQL with LINQ to Objects and LINQ to Entities
- Modeling the Northwind database in LINQ to SQL
- Querying and updating a database with a table
- Deferred execution
- Lazy loading and eager loading
- Joining two tables
- Querying with a view
LINQ to SQL (Part 9 - Using a Custom LINQ Expression with the control)
In today's blog post I'll demonstrate how to use the full query expressiveness of LINQ with the LinqDataSource control, and show how you can use any LINQ to SQL query expression with it.
More:
- LINQ to SQL (.net)
- LINQ to SQL (WordPress Blog Posts)
Submit a review:
Login required.