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…
Tag: .Net
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 qu…
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.Wholesale Houston Texans Jersey Cheap Jerseys free shipping Cheap Jerseys f…
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 …
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? I…
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 tha…
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 …
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 …
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 …
Introduction to Language Integrated Query: LINQ
Language Integrated Query (LINQ, pronounced "link") is a Microsoft .NET Framework component that adds native data querying capabilities to .NET languages using a syntax reminiscent of SQL. LINQ was re…