Category Archives: MySQL

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… »

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… »