logo_sql

Top 12 Smart Tips To Work With SQL

Your users probably don't know a thing about SQL, but you know its value. It's everywhere, it's easy to learn, and SQL solutions are simple to implement. Whether you use SQL a lot or sparingly, workin…

Serialize hash table in C# dynamically

I have realized while working on a problem that .NET Framework does not allow serialization of any object that implements the IDictionary interface. I was very much disappointing with the restriction …

DataContext class in depth : LINQ

In this part of the series I will explain the DataContext class in depth through a series of examples and explanations. Introduction Whenever someone asks me about the DataContext I always refer to …

Querying relational data using Linq

This article is based on a single table schema (don’t worry subsequent parts will see a much more complex database schema!) so that you can get to grips with LINQ to SQL (the name for using LINQ with …