LINQ Learning
Learn how to use the LINQ (Language-Integrated Query) .NET Framework extensions.
Recent Articles
A LINQ to Entities Starting PointLINQ to Entities LINQ to Entities provides Language-Integrated Query (LINQ) support that enables developers to write queries against the Entity Framework conceptual model using Visual Basic or... [read more]
LINQ to SQL Tutorials & Learning ResourcesLINQ to SQL 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... [read more]
LINQ to WMI Tutorials & ResourcesLINQ to WMI Project Originally created by Emile Bosch, and was later updated by Eden Ridgway. “The LINQ to WMI project provides three libraries: LinqToWmi.ClassGeneratorLinqToWmi.CoreLinqToWmi.Tes... [read more]
LINQ to XML Tutorials & ResourcesThe following is a range of LINQ to XML tutorials and resources. A short summary has been included from the beginning of each. LINQ to XML LINQ to XML provides an in-memory XML programming interf... [read more] |
Most Popular This Month
Updating an Entity Without Saving the Data back to the DatabaseI have created a new query like the following var pressData = from press in dataContext.Releases select new { Heading = press.Heading, Description = press.Desc, DatePublished = press.PublishDate.ToStr... [read more]
LINQ to SQL Tutorials & Learning ResourcesLINQ to SQL 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... [read more]
Windows 8 SamplesIf you are playing with the Windows 8 developer preview as I have been since the Build conference, you may have noticed a lack of documentation causing you to hunt and peck through the Object Browser ... [read more]
LINQ to XML Tutorials & ResourcesThe following is a range of LINQ to XML tutorials and resources. A short summary has been included from the beginning of each. LINQ to XML LINQ to XML provides an in-memory XML programming interf... [read more]
A LINQ to Entities Starting PointLINQ to Entities LINQ to Entities provides Language-Integrated Query (LINQ) support that enables developers to write queries against the Entity Framework conceptual model using Visual Basic or... [read more]
Does anyone know how to reproduce an NVL() function in linqSo I need to do a query where I need a bunch of NVL’s but I need to do these in linq (if it helps the db backend is BD2 and we are using subsonic) I searched the web for “NVL linq” and didn’t ... [read more]
LINQ to WMI Tutorials & ResourcesLINQ to WMI Project Originally created by Emile Bosch, and was later updated by Eden Ridgway. “The LINQ to WMI project provides three libraries: LinqToWmi.ClassGeneratorLinqToWmi.CoreLinqToWmi.Tes... [read more]
LINQ to CSV : Getting data the way you wantGetting data from CSV is one of the mostly used business in applications/tools development. Here how we can do it in LINQ, You have a table called Emp with the below details, CREATE TABLE [dbo] ... [read more]
Linq projection that flattens a list into a deliminated stringI am trying to concat and comma deliminated (or space) a list and project it. I have some sample code below. public class Friend { public string Name { get; set; } }public class Person { public int Pe... [read more]
.Net and Hadoop - What to know / learn and what is available?Information My question is regarding BigData in .Net. BigData is used to store and query huge ammounts of data (Facebook, Google, Twitter, …). Examples of BigData are MapReduce, Hadoop, Dryad, … M... [read more] |
Recent News & Resources
Limit JSON Results
Short of writing a loop, what is the best way, preferably using jQuery, to limit the results of a json object/array? For example, if I have: var mydata = [ {id:"1",invdate:"2010-05... [read more]
.Net and Hadoop - What to know / learn and what is available?
Information My question is regarding BigData in .Net. BigData is used to store and query huge ammounts of data (Facebook, Google, Twitter, …). Examples of BigData are MapReduce, ... [read more]
JQuery Autocomplete within MVC doesnt completely function?
I have a auto complete box set up. however when a user types in the box a list of every single item appears. Not relating to antyhing the user is typeing in. What am i doing wrong?... [read more]
Difference between the implementation of var in Javascript and C#
I would like to ask a theoritical question. If I have, for example, the following code in Page_load: cars = new carsModel.carsEntities();var mftQuery = from mft in cars.Manufacture... [read more]
GroupBy then Take in LINQ to Entities?
Let’s say I have the following items: ID Category Name1 Fruit Banana 2 Car Mescedes 3 Fruit Blackberry 4 Fruit Mango 5 Car Lexus 6 Fruit Melon 7 Car BMW 8 Car Toyota I want to gr... [read more]
making Linq case sensitive
I am using vs 2010 with linq to sql and sql server 2008. how would i made this case sensitive var Groups = from gp in _db.Groups where gp.vcr_GroupName == GroupName select gp; here... [read more]
Problem applying Where and Take in LinQ
I have a List<MediaRef> and i want to apply Take and Where condition on it but it is not working i wonder what is the issue. My query is List<MediaRef> objmed = new Lis... [read more]
Cross table / object update with (Db)LINQ
I wonder if someone can help me translate a MySQL query to a (Db)LINQ statement. I've made a test case for what I want to do, so data and structure are different than what I really... [read more]
in C#, how can i take an image from a URL and convert to System.Data.Linq.Binary
i am using a library that wants a photo in System.Data.Linq.Binary format. RIght now i just have a URL. what is the easiest way in C# to convert this link into the System.Data.Linq... [read more]
Return joined table
i had type this linq query for my domain context but why it would failed to retrieve the data of both table matched student id in tblaptmt ? public IQueryable<StudentViewAppoint... [read more]
linq - get most recent associated record
Assuming I have Customer and Order objects, where one Customer can have many Orders (so the Order class has a CustomerId property), and I want to return a colle... [read more]
Dynamic LINQ. No property or field ‘FieldName' exists in type ‘ClassName'
My LINQ query is as follows Dim Query = From t In New XPQuery(Of xUser)(Xpo.Session.DefaultSession) .Where("Name=John").Select("new (Name as FirstName)") Unfort... [read more]
Lambda expressions - select operator
I would like to know how to write a Linq (using lambda Expression in standard dot notation) query. I have an array of some names, and I would like to retrevie a... [read more]
Sort fields in database with linq
I need to sort query results in the actual database (so I don’t have to sort it everytime when I get some results). Can I do this with linq? Database tables a... [read more]
ADO.Net EF, Class Inheritance LINQ-SQL Query Syntax?
I have the following ADO.Net Entities: What I want to be able to do is Select a group of Games depending on the LoanedTo ID. I.E Get all the games where LoanedT... [read more]