Back at PDC 2004 Microsoft announced Longhorn which eventually became Vista. Those who attended PDC in 2004 got an early build of Vista to play with. Microsoft will continue the tradition and will give an early build of Windows 7 at PDC 2008. As of today you can find screenshots of Windows 7 build [...]

After many months I attended SBTUG today. I have always found the presentations at SBTUG to be informative and more importantly entertaining. There are times when I feel like consuming content which is bit light on programming but still related to IT. And SBTUG provides that perfect mix. Today’s presentations were Predicting the Past: Emotional [...]

In my previous post I showed you three different ways to capture the T-SQL query generated by LINQ To SQL. A comment on the post reminded me that I forgot to mention a fourth way i.e. using Linqpad. In Linqpad when you have executed the query you can click on the SQL tab next to [...]

While working with LINQ To SQL there are times when you are interested in looking at the query which will be executed on the database.  This post will cover different ways you can capture the query generated by LINQ To SQL.
SQL Server Profiler
SQL Profile has long been a preferred tool to capture activity on a [...]

As per Beta Exams blog Exam 71-433 TS: Microsoft SQL Server 2008, Database Development is now open to all. you can find more details about it here.

While browsing forums today I came across a question which asked for a solution to download a file from a web server programmatically. The solution is very simple and below is the code which achieves the goal. Here I am downloading a file asynchronously on Button Click.

1: private void buttonDownloadFile_Click(object sender, EventArgs [...]

Microsoft India is running an online event called Virtual TechDays. They are covering some good content on the latest goodies from Microsoft .Net 3.5 SP1, LINQ etc. I am particularly interested in sessions on LINQ and Parallel Extensions.

This code shows you how to find the difference between two DateTime values. The easiest way to do this is to use the TimeSpan class and subtract one DateTime from another.

DateTime firstDate = new DateTime(2008, 8, 1);
DateTime secondDate = DateTime.Now;

TimeSpan timeSpan = secondDate.Subtract(firstDate);

// Get Difference
Console.WriteLine(”Days : ” + timeSpan.Days.ToString());
Console.WriteLine(”Hours : ” + timeSpan.Hours.ToString());
Console.WriteLine(”Minutes : [...]

LINQ To SQL allows us to use a SqlConnection object to connect to a database. The way to use a SqlConnection is to pass it as a parameter to DataContext object. DataContext object has constructor which takes in a IDbConnection and SqlConnection implements this Interface. Here I create a SqlConnection object and use it to [...]

LINQ To SQL or just plain LINQ allows us to do a join on multiple conditions using an elegant technique. In this post I will show you how to perform a Join on multiple conditions. As an example I will take two tables called House and ShoppingMall.

Both these tables have PostCode and CouncilCode as common [...]

Yesterday Large Hardon Collider went RTM at CERN. The Collider will provide insightful information about moments after Big Bang. Now for most of us Big Bang is just a very very big bang and starting of everything including space and time. But if you are not willing to settle at that and if you are [...]

Channel 9 does a “This Week On Channel 9” video every week and this week they paid a visit to One .Net Way. They mentioned my post about Retrieving a list of applications using LINQ in their news video. I am very happy to see One .Net Way mentioned on Channel 9. It feels good [...]