Wednesday, March 28, 2012

The NOT IN clause in LINQ to SQL

Just what the Doctor ordered.
Programmers used to write SQL queries often want to know a LINQ syntax equivalent to the SELECT NOT IN clause in SQL. Marco Russo : The NOT IN clause in LINQ to SQL
Still can't completely wrap my mind around the LINQ dynamic sometimes, so glad we have Google and people who still blog about solutions.

Thursday, March 15, 2012

C# – Keep user settings between versions

Unless you’re using the ClickOnce deployment method for your applications, user settings are usually not transferred when updating to a new version of a C# desktop application. There’s in fact a quick and simple way to always keep the settings between versions.
The trick is to call the .upgrade() method your app settings object. The system will look for previous versions of your application in the App Data directory and copy the user settings to the new version automatically.

Thanks NGPixel, *bawk* *bawk*.