Monthly Archives: December 2007

Microsoft Architecture and related Reference Posters

Posted on December 18, 2007 by Jag

.NET Framework 3.5 Common Namespaces and Types http://download.microsoft.com/download/4/a/3/4a3c7c55-84ab-4588-84a4-f96424a7d82d/NET35_Namespaces_Poster_LORES.pdf   Microsoft® Silverlight™ 1.1 Alpha Developer Reference http://www.microsoft.com/downloads/details.aspx?FamilyID=811D8AD6-8D48-4684-B08C-686462D58A56&displaylang=en   Visual C# 2008 Keybinding Reference http://www.microsoft.com/downloads/details.aspx?familyid=e5f902a8-5bb5-4cc6-907e-472809749973&displaylang=en   Visual Basic 2008 Keybinding Reference http://www.microsoft.com/downloads/details.aspx?familyid=255b8cf1-f6bd-4b55-bb42-dd1a69315833&displaylang=en   Visual C++ 2008 Keybinding Reference http://www.microsoft.com/downloads/details.aspx?FamilyID=4411BBFC-0E3C-42B3-BD05-AF1D292C986F&displaylang=en   Visual C++ … Continue reading →

Posted in Misc | Leave a comment

Working efficiently with multiple T-SQL stored procedure parameter values

Posted on December 18, 2007 by Jag

Sending multiple values in the form of array to a SQL Server stored procedure is very common among database developers.  We can send the values in either of the two methods as following:   ·          Comma separated values (in a … Continue reading →

Posted in SQL Server 2005 | Tagged | 83 Comments

Part 4: Learning LINQ from SQL using Visual Basic 2008 – Sub Queries

Posted on December 16, 2007 by Jag

The source code for all of the following LINQ queries can be downloaded here:     http://cid-41050f68f010a662.skydrive.live.com/embedrowdetail.aspx/Public/SourceFilesForBlog/LINQ/01-LINQ-SubQueries/Solution1.zip   A simple sub-query representation using LINQ (with aggregation in sub-query): The following SQL SELECT SELECT ename FROM emp         WHERE sal = (SELECT … Continue reading →

Posted in LINQ/EF | Tagged , | Leave a comment