Converting From System.Data.Linq.Binary to String and Back
Sunday 8 November 2009 @ 10:49 am
  Just a quick post in case anyone is wasting 10 minutes figuring out how to do this.  For me, this came up because in encoding) So, in my C# code, here is what you need to convert to the Linq.Binary:Linq.Binary carrierMatrix = new ASCIIEncoding().GetBytes(myString);And, to go back from Linq.Binary:string carrierMatrixString = [...]
Comments (1) - Posted in C#, LINQ, LINQ to SQL  


LINQPad Help For Creating Nasty Group by Query in Native SQL
Monday 28 September 2009 @ 9:51 am
  I often speak very highly of Group By,
Comments (1) - Posted in C#, LINQ, LINQ to SQL, TSQL  


Using LINQ2SQL, Use Group By To Get List of Top Occuring Values
Thursday 3 September 2009 @ 4:05 pm
  So, I’m really enjoying using LINQ and specifically
Comments (0) - Posted in C#, LINQ, LINQ to SQL  


Interesting LINQ side affect, Pass in empty List<int> using Contains and Get Where 0 == 1. Hmm
Sunday 14 June 2009 @ 8:21 am
  We’ve built a data access layer on top of LINQ2SQL for dynamically building the layer we call for data access.  It’s convenient because we pass in a query object as a parameter that has a bunch of nullable variables in it.  Here is kind of what it looks like: [...]
Comments (4) - Posted in C#, LINQ, LINQ to SQL  


Combing LINQPAD with LINQ In Action From Manning
Tuesday 9 June 2009 @ 9:08 am
  Last night, I had the honor of having dinner with three other LINQ in Action.  Jim is a wealth of knowledge as well as very entertaining.  He had an interesting analogy for what using try/catch statements to handle expected issues.  I’ll leave it up to you to post to his twitter account and [...]
Comments (1) - Posted in LINQ, LINQ to SQL  


780 Requests Per Second Verses 110, You Really Need to Compile your LINQ to SQL (LINQ2SQL) Queries
Monday 8 June 2009 @ 10:21 pm
  So, I’ve been on kind of a rant lately about how slow uncompiled LINQ2SQL. So, to put some more substance behind my claims, I’ve written a small test application using Visual Studio 2008 that compares the performance of using LINQ2SQL compiled verses non-compiled on a trivial web page. Here are some [...]

Not Sure If I’ve Said Often Enough.. I LOVE LINQPAD!!!
Thursday 4 June 2009 @ 6:30 am
  I’ve been doing a lot of LINQ2SQL lately and just in case I have not said it loud enough how enthusiastic I am about
Comments (0) - Posted in C#, LINQ, LINQ to SQL  


How Fast are In Memory LINQ Evaluations for Doing Simple Things?
Wednesday 3 June 2009 @ 6:27 pm
  So, I recently blogged about the huge penalty for not compiling your LINQ2SQL.  This problem is so big that it occurred to us that maybe all of LINQ has the problem.  So, time for a simple test.  Below is a very simple program that basically generates a list of Ids.  In one case, [...]

LINQ To SQL Very Slow Performance Without Compile (CompileQuery)
Wednesday 6 May 2009 @ 10:23 am

In this article, it is shown how important it can be to use the CompileQuery class when using LINQ to SQL. Doing a simple query in LINQ to SQL verses ADO.NET is shown to run 37 times slower without taking advantage of the Compile feature in LINQ to SQL. If you are doing the same query over and over in LINQ to SQL, this is a no brainer. I’m surprised I did not know this myself previously.

Performance of LINQ to SQL compiled verses not and ADO.NET