Log et al - Peter Curd

How to perform an SQL “IN” query in Linq

pcurd — Sat, 20 Oct 2012 22:35:24 +0000

Using Linq to achieve a query that in SQL that uses the “IN” keyword – i.e. to check a value against a range of values – requires use of the .Contains method on a new array of the range of values.

For example, if I need to exclude from reports the following customers:

Internal
Demo
Sample

I would in SQL use something like:

CustomerName NOT IN ('Internal', 'Demo', 'Sample')

In Linq I need something like:

!(new[] {"Internal", "Demo", "Sample"}).Contains(CustomerName))

Appropriately wired into EF or your ORM of choice.

I think this is confusing since it is written backwards to a SQL programmer, so it reads “does this list of things contain the value?” instead of “is the value in this list of things?” as we are used to in SQL.

Twitter Weekly Updates for 2012-01-01

pcurd — Sun, 01 Jan 2012 12:00:00 +0000

Not impressed with Christmas Doctor Who, rubbish story full of "what? Why did they do that?". Makes me less likely to watch the last season. #
For those non Commonwealth citizens reading this: yes, Boxing Day is when the British gave gifts – to our servants. Now it's just a day off! #
Happy New Year all! #

Twitter Weekly Updates for 2011-12-25

pcurd — Sun, 25 Dec 2011 12:00:00 +0000

Merry Christmas all! And to all, a good night! #

Twitter Weekly Updates for 2011-12-18

pcurd — Sun, 18 Dec 2011 12:00:00 +0000

You know you're not going to enjoy a system change when the spec gives you a paper cut. #ouch #

Twitter Weekly Updates for 2011-12-04

pcurd — Sun, 04 Dec 2011 12:00:00 +0000

I just got interviewed for the Reading 107 breakfast show tomorrow. Listen in for my opinions on Christmas Lights on houses! #

Twitter Weekly Updates for 2011-11-13

pcurd — Sun, 13 Nov 2011 12:00:00 +0000

I've just formally accepted a promotion to deputy manager of IT Administration – I am now allowed to wear patterned socks to work. #Whoop #

Twitter Weekly Updates for 2011-10-30

pcurd — Sun, 30 Oct 2011 12:00:00 +0000

I NEED MORE BULLETS! I only scored 4874 in Wonton 51 #Wonton51 #
On route to #londonexpo – apparently people are there already! And I thought I'd be early! #
Entry to #londonexpo in N6! Those with tickets as well as ticket sales. In the queue now! @MCMExpo @londonexpo #
.@QCPGameworks save some stickers for me! #londonexpo #
Past security at #londonexpo now waiting for a wristband I think… Seems to be three layers of queuing – terribly British. I love it. #
I have a wristband and a goodie bag! #londonexpo #
MCM Expo – London Comic Con (@ ExCeL London w/ 14 others) [pic]: http://t.co/tM0m0gmI #

Twitter Weekly Updates for 2011-10-09

pcurd — Sun, 09 Oct 2011 11:00:00 +0000

Read two chapters of #CSharpInDepth by @jonskeet, cut 16 pages of #EF generated SQL to 1 page. Thanks Jon! #AverageDay #
Loosing a visionary who changed everything from the way we talk to each other to how we define successful is tragic. We'll miss #SteveJobs #

Twitter Weekly Updates for 2011-09-18

pcurd — Sun, 18 Sep 2011 11:00:00 +0000

Rumours of my untimely demise are greatly exaggerated. But yes, I do think @NaturalCon pushed me. I don't care if she was in front. #OW #
Royal County of Berkshire Show calls today, running a bit late as my sleep and stomach emptiness disagreed with my alarm clock. #

Twitter Weekly Updates for 2011-09-11

pcurd — Sun, 11 Sep 2011 11:00:00 +0000

RT @Plip: If you work for a charity and need some free tech help I have two days left this year to donate. Anyone want them? @phil_crabtree #
Can anyone recommend a decent command line SFTP client for Windows? #Lazyweb #