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, working smarter with SQL will help you avoid errors and improve performance. Many SQLs are vendor-specific. The following tips apply [...]

Continue Reading →

activex-data-objects

Best Practices of ActiveX Data Object (ADO)

ADO – ActiveX Data Object is a library to manipulate data i.e. retrieving and storing records. Being a Microsoft library ADO offers great ease to help developers with their database queries. ADO is quite flexible and powerful as it doesn’t let the developer bother how the database is implemented. They can straightaway use the database [...]

Continue Reading →

FileSystemWatcher to monitor directory changes in C#

You must have performed certain tasks where you need to determine if the files or directories are created or even modified. One example of this is an import system that pulls flat files into a database. In this instance, a program must monitor a directory for newly created files. When a file is created, the [...]

Continue Reading →

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 but later i figured out that the restriction is not on hash tables. There are few ways which leads people to follow the following [...]

Continue Reading →

11 reasons to use Access and few not to

The truly smart and effective IT professional knows that there are many tools. The key is to know which database engine is the best for the job at hand. Why throw massive resources at a simple need? In other words, you don’t want to pay for a Rolls Royce engine if you’re building a go-cart. [...]

Continue Reading →

How to Store application data securely using encrypted DataSets?

.NET developers are familiar with using serialized DataSets to store local application data; this technique is used extensively in the WinForms development arena. The problems with this method are that anyone with access to the file can easily read the data and possibly even write to the file. The application would pick up the modified [...]

Continue Reading →

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 it as the “brains” of Linq to SQL, why? Because it is. It is responsible for the translation of Linq to T-SQL, [...]

Continue Reading →

Developing 3 tier application in CSharp using LINQ

The ASP.NET application that we will create we be a 3 tier application, consisting of a data access layer (DAL), a business logic layer (BLL) and a presentation layer (PL). We will be using Visual Studio Orcas Beta 1 for this tutorial. Defining our database schema Before we jump into coding some C# or ASP.NET [...]

Continue Reading →

Entities and Key Types in application using Linq

In this part we will look a little more at what entities are, as well as taking a closer look at the key types we can use and their application. Entities? When we talk about entities we are generally talking about a more functional representation of our schema. A perfect view of this is the [...]

Continue Reading →

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 relational data – also known as DLINQ in a previous life, but we won’t go into that…) [...]

Continue Reading →