LINQ

Sorted by: Newest

Professional ADO.NET 3.5 with LINQ and the Entity Fr

By joeydavilacom on | From joeydavila.com

Language Integrated Query (LINQ), as well as the C# 3.0 and VB 9.0 language extensions to support it, is the most import single new feature of Visual Studio 2008 and the .NET Framework 3.x. LINQ is Ms first attempt to define a universal query language for a diverse set of in-memory collections of generic objects, entities persisted in relational database tables, and element and attributes of XML documents or fragments, as well as a wide variety of other data types, such as RSS and Atom...Read Full Story

Transfer selected rows form gridview1 to gridview2 using LINQ to SQL

By ksmithaiea on | From sitepoint.com

I would like to transfer the selected rows from gridview1 to gridview2, but I am able to do only the primary key column into the second grid. How to modify the code to have all columns displayed/ is there a better way to do it? The code: protected void Button1_Click(object sender, EventArgs e) { DataClassesDataContext context = new DataClassesDataContext(); var f = from z in context.Availabilities join p in context.Items on z.ItemID equals p.ItemID join x in context.CDs on...Read Full Story

Linq to sql-insert into multiple tables (cannot implicitly convert type 'CustomerAddr

By ksmithaiea on | From sitepoint.com

Hello, I am new to .net. So plz help resolve my errors. I have two tables Customer and CustomerAddrress. The Customer ID in the Customer table is the primary key and the CustomerID in the CustomerAddress is a foreign key to the Customer table. I have to insert value into these tabes with one submit click. The CustomerID value from the Customer table should be fetched and then this should be used in CustomerAddress table.. I am using asp along with LInq to Sql. My code is as follows...Read Full Story

How to do Select All(*) in linq to sql

By niranjankala on | From developmentsolutionsjunction.blogspot.com

Using Simple Linq. from row in context.TableA select row; Using Linq Lembda expression context.TableA.Select(row=>row);Read Full Story

LINQ statement returns rownumber / Line Number Into Linq Query Results

By niranjankala on | From developmentsolutionsjunction.blogspot.com

Scenario: data: First Second Third I like to display it as: 1. First 2. Second 3. Third Solutions: var list = new List<string>{ "First","Second","third" }; var query = (from s in list select s) .Select((obj, index) => index + ". " + obj); foreach (string s in query) Console.WriteLine(s); 2. static void Main(string[] args) { string[] nums = {"One","Two", "Three"}; int X = 0; var q = (from a in nums select new {ID = IncrementX(ref X), num = a}); foreach (var a in q) { Console.WriteLine (a.ID...Read Full Story

News

Linq Tutorial Six Published

In this tutorial I've looked at Aggregation Operators usch as Min(), Max(), Count(), Average() and the quite powerful Aggregate(). It also looks at projection with Select() and SelectMany(). These transform sequences, and there's an example of flattening of a two dimension structure but all have examples....Read Full Post

From z.about.com ()

Related news:

Hilton Flamingo Timeshare Owners Urged to Vote in Easements for the New Linq... (api.bing.com)

Parallelism in .NET – PLINQ (asp.net)

Adding search functionality in a GridView in an ASP.Net application (weblogs.asp.net)

More perspectives...

Las Vegas: Huge Linq retail-entertainment project breaks ground

There's a four-course menu for $39, or you can order a la carte. Selections include wild-boar sausage scramble, smoked-salmon omelet, and veal and eggs. There are also Bloody Marys ($25) and bottomless champagne ($15). Hours are 10:30 a.m. to 3 ...

From api.bing.com ()

More perspectives...

C# MVC3 Razor Entity Framework & LINQ Custom Membership Provider with Custom...

This C# project demonstrates how to create an MVC3 Razor Entity Framework & LINQ Custom Membership Provider with Custom Role Provider. Perhaps you are working with a legacy database or you prefer working with a database that uses numeric identity keys instead of Guids. The example UserProfile table in this project uses an integer UserId as the primary key and various other fields that aren't in the default ASP.NET User table. Use the Log On...

From weblogs.asp.net ()

More perspectives...

Visual Expression Builder for Dynamic Linq

Let your users create their own Linq filters with this MVVM WPF tool you can include in your application

From codeproject.com ()

More perspectives...

Overview

Language Integrated Query (LINQ, pronounced "link") is a Microsoft .NET Framework component that adds native data querying capabilities to .NET languages using a syntax reminiscent of SQL. Many of the concepts that LINQ has introduced were originally tested in Microsoft's Cω research project. LINQ was released as a part of .NET Framework 3.5 on November 19, 2007.

LINQ defines a set of query operators that can be used to query, project and filter data in arrays, enumerable classes, XML, relational database, and third party data sources. While it allows any data source to be queried, it requires that the data be encapsulated as objects. So, if the data source does not natively store data as objects, the data must be mapped to the object domain. Queries written using the query operators are executed either by the LINQ query processing engine or, via an extension mechanism, handed over to LINQ providers which either implement a separate query processing engine or translate to a different format to be executed on a separate data store (such as on a database server as SQL queries). The results of a query are returned as a collection of in-memory objects that can be enumerated. -- source www.wikipedia.org