LINQ doesn’t have the equivalent of the SQL “IS NULL” operator. e.g.
SELECT * FROM dbTable where dbColumn IS NULL
In LINQ to write a query against nullable column, fashion the query as,
var results = from a in dbTable where a.dbColumn == null select a;
or
string myVar = null;
var myRows = from a in dbTable where a.dbColumn == myVar || (a.dbColumn == null && myVar == null) select a;
Virtual PC Console not displayed
Ran into an issue where my Virtual PC Console would not display even when the program was up and running, turned out that it was an issue with the previous display position that is stored in a configuration file – %APPDATA%\Microsoft\Virtual PC\Options.xml. To fix the problem, exit the Virtual PC Console application and remove this configuration file.
ADO.NET data services does not support SQL Server 2008 DateTimeOffset type… Too bad.
Interesting PDC sessions by Anders Heilberg on c# 4.0.. Liked his comment – new static type called ‘dynamic’.
BizTalk Server 2006 R3 is now BizTalk Server 2009. Microsoft has made the official announcement, with a roadmap on future versions and integration with ‘OSLO’. BizTalk Server 2009 will support the Windows Server 2008 platform. CTP expected about the end of the year.
Local SQL Server expert Kevin Boles is close to starting a new SQL Server User Group here in Huntsville.
Gustav seems to be gathering steam as it heads towards the US southern coastline. Checking the National Weather Service Site for latest news…
Goosh.org – UNIX like command line interface to Google…
Twitter is a great micro-blogging tool, that is growing in popularity by leaps and bounds. At 140 character length per tweet, it forces you to be brief and to the point (which is a good thing). Have chirpr on gadgets bar.
Most people are familiar with codeplex, a popular code repository. Here are some other links to check out, github, sniplr, codeproject.