Here's some code I wrote to extend LINQ with random operations like selecting a random item from a list and shuffling a list.

Language-Integrated Query (LINQ) includes several projection operators but none that allow multiple items to be created from each item in a sequence. This article describes a custom operator that allows several selections to be made per item.

Future queries are an unobtrusive and easy to use way of batching database queries into a lazy loaded data structures. Future queries were originally a feature of NHibernate, and have since been ported to other ORMs. To batch queries together, simply call the ToFuture extension method on your IQuery...

A discussion on when and if LINQ query results should be materialized, and a way to cache the results lazily to prevent multiple enumerations of the source.

Create an abstract application that will perform CRUD operations on XML using LINQ to XML

Following my post last year about modifying LINQ to SQL command text (evil, as it calls private methods through reflection) here’s an equally evil, but faster version that pre-compiles most of its work through an expression tree.

Last year I posted an article about modifying LINQ to SQL (L2S) command text. Here’s an update that properly handles sub-queries.

One of the greatest benefits of LINQ to SQL and LINQ to Entities are navigation properties that allow queries across several tables, without the need to use explicit joins. The resulting code is much more readable, and the SQL generated by both Linq queries is identical.

Writing a recursive method in C# is easy, but it’s not immediately obvious how to do the same in a LINQ expression tree. Here's how.

This amazing small tool allows to query SQLSERVER or MYSQL databases using LINQ or simple SQL, doesn't require installation, and works like a charm, really useful if you're trying to learn LINQ. It's just 4MB

Performing simple string equality tests is often not enough when application user convenience is key. Often only a fragment of a string is known to the user, or many of them. Sometimes there is a need to search for a fragment in multiple columns. Which options does OpenAccess and LINQ provide to pe...

Before some time I have written a blog post about the SkipWhile operator and a reader of my blog asked me that we can do the same thing with Where also but there is a difference between this two. So In this post I am going to explain you difference between those two. Where operator filters a list...

In this post I am going to explain TakeWhile Operator in details. TakeWhile is one of partitioning operator available in Linq. It will take sequence until condition becomes false.

I have been playing around linq and I have found great method call SkipWhile method. SkipWhile methods skips particular element which matches condition in predicate this can be use full in condition where we need to skip elements on particular condition. So let’s take some example. I have written...