|
LINQ Equivalent Of Where IN
Working with LINQ to SQL I came across a need of writing a LINQ query equivalent of T-SQL “Where IN” clause. This is what T-SQL query looks like.
SELECT CustomerID, CompanyName, ContactName, ContactTitle, Address,
City, Region, PostalCode, Country, Phone, Fax
FROM [...]
Use Screen Space Efficiently On Windows Vista With Virtual Desktop Manager
Virtual Desktop Manager is tool which lets you create virtual desktops. You can run different applications in different virtual desktops which reduces clutter. Once you get used to working with it you start loving it. I have been using it for a while now and I cannot do without it anymore. You can download Virtual [...]
MSDN Forums Client July CTP Now Available
Since MSDN forums started they have captured substantial share of online forums related to Microsoft technologies. I remember having a discussion with one of the softies about newsgroups and how MSDN forums will eventually replace them (in MS world of course). And now you can interact with Microsoft forums using a client application which is [...]
Visual Studio Book I Am So Looking Forward To
If there is one book I am looking forward to, it is Microsoft Visual Studio Tips by Sara Ford . I am a regular reader of Sara’s blog and I have learned a lot about Visual Studio by reading her blog. Her tips are simple, lightweight but above all very++ useful.
I expect her book to [...]
Windows 7 Conversation Begins
Two senior engineering managers for Windows 7, Jon DeVaan and Steven Sinofsky have started a blog called Engineering Windows 7. I am sure that this will be one of the most watched blogs till other Windows 7 related blogs/sites appear. Reading their first post I get an impression that their blog is an attempt to [...]
Bulk Copy Data Using SQLBulkCopy Class
SQLBulkCopy class in ADO.NET can be used to do bulk copy operations from a .Net application. There are two ways data can be bulk copied using this class. You can either do a single bulk copy or a multiple bulk copy operation. In this post I will show you how to perform a single bulk [...]
Find Duplicates Using LINQ
How can we find duplicate occurrences of values in a collection? I will demonstrate this here using a collection of cities. City class looks like this:
public class City
{
public string Name { get; set; }
public string Country { get; set; }
}
Cities collection is initialised with this code:
List<City> cities [...]
Windows 7 Privacy Statement Is Coming Soon
No I am not spreading a rumour. This is as per a Microsoft site.
Different Flavors Of LINQ
You may have noticed from my blog posts lately that these days I am spending considerable time working with LINQ. Although I mainly concentrate on LINQ To Objects and LINQ To XML, I often wander around and play with other flavors of LINQ as well. Today, just out of curiosity I wanted to see how [...]
MSDN Library For Visual Studio And .NET 3.5 SP1
While working, you will always find two things running on my machine. One is without any doubt Visual Studio and second is MSDN Library. Since this morning after installing Visual Studio 2008 SP1 I’ve been trying to get my hands on the latest MSDN Library. Thanks to Iftekhar who pointed me to the latest [...]
Tutorial Reading A Text File Using LINQ
Introduction
At times us developers have to deal with delimited text files in our applications. Such files have been around since yonks and I often come across data import/export tasks where delimited files are used. Till now the common way in .NET has been to read each line and then extract data using some sort of [...]
Creative Commons Add-in For Microsoft Office 2007
Microsoft provides a Creative Commons addin for Microsoft Office 2007. This addin allows authors to embed CC licenses into Excel, Word and PowerPoint. After installing the addin you will see a new tab on the Ribbon.
Technorati Tags: Microsoft Office
Get Updates By Email
Popular Post
Tag Cloud
Code Snippets
- Get Current Windows User In C#
- Get Width And Height Of Image In C#
- Get Windows Registry Size With WMI And C#
- Reverse Array Elements Using C#
- Convert Hexadecimal To Number In C#
- Get Free Disk Space Using T-SQL
- SQL Server 2008 – Get All Indexes In A Database
- Get Name Of Current Executing Assembly In C#
- Get CD Or DVD Drive Information Using WMI And C#
- Get Last Row From Table Using LINQ To SQL

