Earlier I wrote a post showing how to write a LINQ query which gets transformed into a T-SQL query with a "Where In" clause. I had a comment on the post by Steve saying that the approach only works with strings. In this post I will show you a similar query which works with Integers.
Let’s [...]

Over last few days I have been off from work and for the first time in many years I have actually stayed away from computing over Christmas break. This has been very good for me. I genuinely feel relaxed, recharged, refreshed and by all means ready to take on another year. I have setup few [...]

I wish all readers of One .Net Way a very Happy New Year. Let 2009 be an year of learning. I know it will be for me.

I had a look at LINQPad few months ago when I wrote about how you can use this tool to view generated LINQ To SQL Queries. There is not doubt that LINQPad comes in as a very handy tool when writing LINQ queries. But writing queries in LINQPad has not been that easy. Until Now!
LINQPad [...]

A question was posted on c-sharpcorner forums asking how you would remove duplicate lines from a text file. It got me thinking about how this problem could be addressed using LINQ. Before I get into the solution, here is the problem statement.
The problem
I am trying to remove duplicate lines from a text file. To [...]

CCC stands for Cloud Computing Consultant. There, I have said it. This is my contribution to acronyms-land. I have also cleverly designed it to minimize RSI which I am sure will be appreciated. You only have to use one key to type the acronym. If you ever come across the term Cloud Computing Consultant [...]

According to Market Share Google Chrome has 1% of browser market share. I am sure I must be a part of that statistics because I have Chrome installed on one of machines, and I think of it as just another browser. Although integrating search into address bar is a clever feature but again it is [...]

Amazon has launched a Microsoft Branded Store where you can browse through all Microsoft Press and other Microsoft related books. I am an Amazon addict and this has just given me one more excuse to spend more time on the site. I’m now waiting for them to sell Microsoft T-shirts and novelty items.

Sometime ago I wrote a post showing how to do dynamic sort with LINQ. That approach worked well with LINQ To Objects. Today I spotted a question on the forums where Levi asked a question about doing dynamic sorts with LINQ To SQL. My earlier approach will work once all the data is retrieved on [...]

For those interested in pursuing certification(s) on .NET Framework 3.5, Microsoft has released a set of exams for various .Net 3.5 technologies. I often get asked about these exams and how to study for them. In this post I will try to answer the first part. This post lists all currently available .Net 3.5 exams [...]

As a programmer I love my enums. I find code written using enums to be more readable than without them. However, there has been and there still is a disconnect between lookup tables in a database and enums in code. One has to restore to some creative trickery to get them working in harmony. Recently [...]

Microsoft Online Services is out of Beta and ready for prime time. List of products offered through online services is impressive. You can either go for BPOS (Business Productivity Online Standard Suite) which includes Exchange Online, SharePoint Online, Office Communications Online and Office Live Meeting. Or you can subscribe for individual products such as CRM, [...]