Category Archives: C#

The .NET BackgroundWorker class and You

Introduction My personal favorite class of the .NET Framework is the BackgroundWorker class. The BackgroundWorker class provides an easy way for a programmer to execute a time-consuming operation on a separate background thread while providing a simple way to communicate progress, completion and other information about the background operation to the thread which started the… Read More: The .NET BackgroundWorker class and You »

Proper Etiquette for using MySQL in C# (Part of 3 of 3) – DbDataReader

Looking back on this series, we have discussed both proper management of database related resources and how to protect and improve the performance of our applications through the use of Parameterized Queries (Prepared Statements). Since the primary reason for accessing a database is to read data from it, it would be a shame if we… Read More: Proper Etiquette for using MySQL in C# (Part of 3… »

Proper Etiquette for using MySQL in C# (Part of 2 of 3) – Parameterized Queries

In the first installment of this three part series I covered why properly managing resources related to database activity is so important. In this second part, I will discuss how using parameterized queries (also known as prepared statements) will improve the performance as well as increase the security of your application. Again the examples are… Read More: Proper Etiquette for using MySQL in C# (Part of 2… »

Bit Processing in C#

As a .NET programmer, how do you check if a bit is set within a byte? How do you set, unset or toggle a bit? How do you get the binary string representation of a byte? Well for most of those questions, the answer is to use the same bit-twiddling methods that C/C++ programmers are… Read More: Bit Processing in C# »

Proper Etiquette for using MySQL in C# (Part of 1 of 3) – IDisposable

Many tutorials describing how to access MySQL databases in C# are typically missing a major point of emphasis or two. Stack Overflow alone is filled with questions where the author violates best practices in their code snippet. In this three part series, I would like to go over some major points of etiquette when using… Read More: Proper Etiquette for using MySQL in C# (Part of 1… »