When to use an extension method with lambda over LINQtoObjects to filter a collection? * Cinema Guy 12:23 Add Comment Edit Question I am prototyping some C# 3 collection filters and came across this. I have a collection of products: public class MyProduct { ... Read More
How much database performance overhead when using LINQ? * Cinema Guy 07:39 Add Comment Edit Question How much database performance overhead is involved with using C# and LINQ compared to custom optimized queries loaded with mostly l... Read More
LINQ on the .NET 2.0 Runtime * Cinema Guy 05:03 Add Comment Edit Question Can a LINQ enabled app run on a machine that only has the .NET 2.0 runtime installed? In theory, LINQ is nothing more than syn... Read More
How do I most elegantly express left join with aggregate SQL as LINQ query * Cinema Guy 14:22 Add Comment Edit Question SQL: SELECT u.id, u.name, isnull(MAX(h.dateCol), '1900-01-01') dateColWithDefault FROM universe u LEFT JOIN his... Read More
Paging a collection with LINQ * Cinema Guy 06:20 Add Comment Edit Question How do you page through a collection in LINQ given that you have a startIndex and a count ? Answer A few months back I wrote a b... Read More
How do I get a distinct, ordered list of names from a DataTable using LINQ? * Cinema Guy 06:14 Add Comment Edit Question Let's say I have a DataTable with a Name column. I want to have a collection of the unique names ordered alphabetically. The ... Read More
Filling a DataSet or DataTable from a LINQ query result set * Cinema Guy 21:59 Add Comment Edit Question How do you expose a LINQ query as an ASMX web service? Usually, from the business tier, I can return a typed DataSet or DataTabl... Read More