How NOT To Optimize LINQ Statements(coderjournal.com)

submitted by zigamorph(3319) 3 years, 8 months ago

About a month ago I was experimenting with different ways to optimize my LINQ queries against the IdeaPipe database, in order to improve the read times. I wanted to improve the read times because our new Facebook Application was being launched and I anticipated an increase in our traffic to the server, which is used to host IdeaPipe and the Facebook Application component. I quickly realized how now to optimize LINQ statements though. read more...

add a comment |category: Linq |Views: 426

tags: LINQ SQL C# another

Using Linq2Objets to perform list conversoin(dimecasts.net)

submitted by vb6stillrocksman(55) 3 years, 8 months ago

A short screencast showing how to use Linq2Objets to perform list conversion. read more...

add a comment |category: Linq |Views: 174

tags: Dimecasts.net LINQ another

Custom LINQ to SQL code generation templates(damieng.com)

submitted by DamienG(1405) 3 years, 8 months ago

Free templates to allow full customization of the DBML to C#/VB.NET code generation phase of LINQ to SQL without additional tool dependencies! read more...

add a comment |category: Linq |Views: 401

tags: LINQ another

LINQ to SQL queries involving strings cause SQL Server procedure cache(blogs.lessthandot.com)

submitted by SQL_Menace(4890) 3 years, 8 months ago

Be careful when using LINQ. If an application is using LINQ to SQL and the queries involve the use of strings that can be highly variable in length, the SQL Server procedure cache will become bloated with one version of the query for every possible string length read more...

add a comment |category: Linq |Views: 177

tags: LINQ Bug SQL Database Performance another

LINQ to Entities, what is not supported?(mosesofegypt.net)

submitted by mosessaur(5424) 3 years, 9 months ago

A look at what LINQ to SQL support and not supported in LINQ to Entities. read more...

add a comment |category: Linq |Views: 342

tags: linqtoentities mosesofegypt.net mosessaur LinqToSql ADO.NET another

Localizing Linq to SQL Entities(sidarok.com)

submitted by sidarok(1715) 3 years, 9 months ago

Sidar shows a possible strategy to localize Linq to SQL entities read more...

add a comment |category: Linq |Views: 303

tags: LINQ Filtering Localization Database C# another

The Dark Side of LINQ(developerzen.com)

submitted by tentacle(115) 3 years, 9 months ago

I’ve been having mixed feeling for quite some time now regarding LINQ. Sure it can make working with data sources a lot easier and it can definately save a lot of code but it also has the potential of creating cryptic complex code... read more...

10 comments |category: Linq |Views: 614

tags: Bullshit LINQ another

LINQ to SQL - Am I Hitting The Database?(singingeels.com)

submitted by wisemx(8074) 3 years, 9 months ago

Like most other developers who have been using LINQ for a while (and in this particular case, LINQ to SQL) - I've unknowingly made a few 'bad queries' that performed great at first, but eventually made some pages crawl. This post isn't necessarily about performance, but if you don't know how to answer that question ("am I hitting the database"), then you'll likely find yourself in a world of problems down the road when you're using LINQ to SQL. read more...

add a comment |category: Linq |Views: 345

tags: LINQ another

Harnessing the Power of Linq2Sqls Delayed Execution(dimecasts.net)

submitted by dwhittaker(13.1k) 3 years, 9 months ago

Short screencasts on harnessing the Power of Linq2Sqls Delayed Execution read more...

add a comment |category: Linq |Views: 125

tags: LINQ another

LINQ Farm: More on the LINQ Aggregate Operators(blogs.msdn.com)

submitted by CharlieCalvert(7875) 3 years, 10 months ago

The LINQ aggregate operators allow you to perform simple math operations over the elements in a sequence. This post is designed to walk you through those operators, and give you an overview of how to use them. read more...

add a comment |category: Linq |Views: 201

tags: LINQ another

LINQ & Lambda, Part 4: Lucene.Net(vijay.screamingpens.com)

submitted by CVertex(325) 3 years, 10 months ago

This post demonstrates how to easily build a Lucene.Net search index from your LINQ to SQL data context and search for items within it using the LINQ to Lucene library. read more...

add a comment |category: Linq |Views: 516

tags: LINQ another

LINQ Farm: More on Set Operators(blogs.msdn.com)

submitted by CharlieCalvert(7875) 3 years, 10 months ago

This is a second post on the LINQ Set operators, the first being published while LINQ was still in beta. As mentioned in the previous post, there are four LINQ set operators: Union, Intersect, Distinct and Except. Like the other 50 LINQ operators, these methods are designed to allow you to query data which supports the IEnumerable<T> interface. Since all LINQ query expressions, and most LINQ queries, return IEnumerable<T>, these operators are designed to allow you to perform set operations on the results of a LINQ query. In this post I give four highly simplified examples of how to use each of the operators, and then end with a more complex example that shows how the operators might be used in a real world setting. read more...

add a comment |category: Linq |Views: 194

tags: LINQ another

Introduction to LinqPad(dimecasts.net)

submitted by dwhittaker(13.1k) 3 years, 10 months ago

Short screencasts that will on the Introduction to LinqPad In this episode we will learn how to use the LinqPad expression evaluator. read more...

add a comment |category: Linq |Views: 165

tags: LINQPad LINQ another

Lambdas(blogs.msdn.com)

submitted by CharlieCalvert(7875) 3 years, 10 months ago

Lambdas are a simple technology with an intimidating name. They sound like they are going to be difficult to understand, but in practice prove to be relatively trivial. Read this post to get an easy to understand overview of a topic is not really so terribly difficult to understand. read more...

add a comment |category: Linq |Views: 553

tags: LINQ another

Performing Subselects with Linq2Sql(dimecasts.net)

submitted by dwhittaker(13.1k) 3 years, 10 months ago

Short screencast on performing Subselects with Linq2Sql read more...

add a comment |category: Linq |Views: 179

tags: LINQ another

Difference between LINQ to SQL and the Entity Framework(dotnethitman.spaces.live.com)

submitted by misbaharefin(845) 3 years, 10 months ago

LINQ to SQL and the Entity Framework have a lot in common, but each have features targeting different scenarios. read more...

add a comment |category: Linq |Views: 489

tags: EntityFramework LINQ another