LINQ to SQL

Learn more about using LINQ against a Relational database with LINQ to SQL and LINQ to Entities. What are the key scenarios for which each of these technologies was designed?

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.

Microsoft .NET Language Integrated Query (LINQ) provides a common way to work with data in your applications. In this session, we dive into how LINQ provides methods to work with Structured Query Language (SQL) databases, including how to query, insert, and manage data using the LINQ framework.

This webcast extends the SQL and LINQ web cast by showing you how to use the new OR designer to build applications that take advantage of LINQ to SQL.

The Microsoft .NET Language Integrated Query, code-named the "LINQ" project, is a set of extensions to the Microsoft .NET Framework that encompass language-integrated query, set, and transform operations. LINQ extends Microsoft Visual C# and Visual Basic with native language syntax for queries and provides class libraries to take advantage of these capabilities. In this session, we cover some of the basics of LINQ and explore the key LINQ-related components, such as:

• BLINQ—A tool for generating Microsoft ASP.NET Web sites for displaying, creating, and manipulating data based on database schema
• LINQ to SQL (formerly DLINQ)—A specialized API for accessing Structured Query Language (SQL) relational databases
• LINQ to XML (formerly XLINQ)—A lightweight, rational, and simple API for manipulating XML.

This geekSpeak features Microsoft .NET Framework expert and Microsoft Most Valuable Professional (MVP) Bill Jones. Bill takes on your toughest questions about implementing LINQ to SQL in the real world.

Simulcast from Microsoft Tech·Ed 2007. Do you build Microsoft .NET applications? In this session, learn how to use the .NET Framework to build better end-to-end solutions using the DinnerNow.NET sample application. From a Windows Presentation Foundation client to a Windows Modern, applications operate on data in several different forms: relational tables, XML documents, and in-memory objects. Each of these domains can have profound differences in semantics, data types, and capabilities, and much of the complexity in today's applications is the result of these mismatches. Luca Bolognese, LINQ Lead Program Manager, explains how the next release of Microsoft Visual Studio, code name "Orcas," aims to unify the programming models through LINQ capabilities in Microsoft Visual C# and Visual Basic, a strongly typed data access framework, and an innovative application programming interface (API) for manipulating and querying XML.

Recorded at Microsoft Tech·Ed 2007 in Orlando, FL. Database-centric applications have traditionally had to rely on two distinct programming languages: one for the database and one for the application. In this talk, we introduce LINQ to SQL, a component of the LINQ project designed to help integrate relational data and queries with Microsoft Visual C# and Microsoft Visual Basic .NET. LINQ to SQL enables developers to express queries and updates in terms of their local programming language without sacrificing the server-side execution model of current high-performance SQL-based approaches. Using these advances, database queries that previously were stored as opaque strings now benefit from static type checking, CLR metadata, design-time type inference, and, of course, IntelliSense. LINQ to SQL also supports a rich update capability that lets you save changes to an object graph back to the database using optimistic concurrency or transactions.