linq

TwitterFacebook
Get flash to fully experience Pearltrees
regex

[There is a follow-up article to this which makes search properties strongly-typed.] I’ve received several questions recently about dynamically composing LINQ queries. Those of us who come from a SQL background and are familiar with embedding queries in strings have had it easy when it comes to composing query logic, although it has always come with a price: those queries are not strongly checked for syntax errors, the existence of members, or type agreement, and there is always SQL injection to be cautious of. Still, faced with a scenario such as the need to customize the sort order of a query window in an application, sometimes it’s necessary to give up a little validation, or at least push it to a different part of the application. Imagine an administrative view where a user selects a list, selects the fields to order by, in which direction (ascending or descending), and can reorder which fields are ordered first, second, and so on. http://dvanderboom.wordpress.com/2008/12/19/dynamically-composing-linq-orderby-clauses/

Dynamically Composing LINQ OrderBy Clauses « Critical Developmen

LINQ to Active Directory (formerly known as LINQ to LDAP) is her

http://community.bartdesmet.net/blogs/bart/archive/2007/11/25/linq-to-active-directory-formerly-known-as-linq-to-ldap-is-here.aspx Sunday, November 25, 2007 11:23 PM bart Within a few seconds from now I'll hit the "Publish This Project" button in CodePlex. Back in the early Orcas ages (beta 1 and before) I cooked up this pretty simple example showing how to create custom LINQ query providers . As a matter of fact, it was the result of a blog series back in April entitled "The IQueryable tales". Here are the pointers but keep in mind things have changed in the meantime: More specifically, the API to write custom LINQ query providers has changed a bit.
Introduction I'm a big believer in practical examples. So, soon enough, I'll get to one, hold on. http://www.codeproject.com/Articles/28580/LINQ-and-Dynamic-Predicate-Construction-at-Runtime

LINQ and Dynamic Predicate Construction at Run-time. Free source

LINQ has revolutionised the way we do data access. Being able to fluently describe queries in C# means that you never have to write a single line of SQL again. Of course LINQ isn't the only game in town. NHibernate has a rich API for describing queries as do most mature ORM tools. But to be a player in the .NET ORM game you simply have to provide a LINQ IQueryable API. It's been really nice to see the NHibernate-to-LINQ project take off and apparently LLBLGen Pro has an excellent LINQ implementation too.

The Queryable Domain Property Problem

http://mikehadlow.blogspot.com/2008/08/queryable-domain-property-problem.html

10 Tips to Improve your LINQ to SQL Application Performance | Si

Hey there, back again. In my first post about LINQ I tried to provide a brief(okay, bit detailed) introduction for those who want to get involved with LINQ to SQL. In that post I promised to write about a basic integration of WCF and LINQ to SQL working together, but this is not that post. 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. http://www.sidarok.com/web/blog/content/2008/05/02/10-tips-to-improve-your-linq-to-sql-application-performance.html
http://www.hookedonlinq.com/MainPage.ashx

Main Page - Hooked on LINQ

Welcome to Hooked on LINQ . This website aims to be the premier community resource for LINQ (Language Integrated Query) for Microsoft®'s .NET. You can read more about this site here. I hope you find this site useful and bookmark it as your landing place for LINQ related information. If you have ideas or feedback about making this site better, then please add them to this page , or Email me . Edit
Dynamically Composing Expression Predicates Suppose you want to write a LINQ to SQL or Entity Framework query that implements a keyword-style search. In other words, a query that returns rows whose description contains some or all of a given set of keywords. We can proceed as follows: IQueryable<Product> SearchProducts (params string[] keywords) { IQueryable<Product> query = dataContext.Products; foreach (string keyword in keywords) { string temp = keyword; query = query.Where (p => p.Description.Contains (temp)); } return query; } http://www.albahari.com/nutshell/predicatebuilder.aspx

C# 3.0 in a Nutshell - PredicateBuilder

LINQ provider basics

http://dotnetslackers.com/articles/csharp/LINQProviderBasics.aspx Learn how to create custom LINQ providers. Introduction LINQ (Language Integrated Query) works as a middle tier between data store and the language environment. From a developer's point of view, it is just a new pattern for querying data from multiple data structures directly in the IDE.

Improving Performance With LINQ

( Jul 31 2007 - 07:50:04 PM by Timothy Khouri ) - [ print article ] While the title of this article may seem misleading, you actually can achieve incredible performance gains by updating your web application to use LINQ. This article will dispell some common myths about LINQ and demonstrate how LINQ can practically increase performance. The examples in this article will be using LINQ to SQL, but the principles apply to LINQ to Entities as well. http://www.singingeels.com/Articles/Improving_Performance_With_LINQ.aspx