In this article I want to explain the differences between using the override modifier versus the new modifier on a method. I will also point out a specific reason why it is important to test the way you use published API's in your software via unit tests. Below is some example code for reference during...

Continue reading "Unit Testing Explicitly Hidden Methods"

One of the first things it seems most people do when they get the code to VistaDB is remove the GC.Collect() call we have in the MinimizeMemory code for the Tree class. This class specifically is used to hold portions of the database, indexes, etc in RAM. Periodically it is combed to attempt and minimize...

Continue reading "To Collect or not to Collect"

All VistaDBType objects are really nullable types. Why? Because they come from your database. If your database is set to allow nulls, any of them could be set to a null. This is not the same as the dot net runtimes definition of a nullable type though. In dot net you can set an object to be nullable...

Continue reading "3.3 API Changes and more - Nullable is not null?"

Using statements and memory leaks to databases This question was recently asked in the forum and I see it so often in code samples sent in by users that I thought I would take a little time to discuss using statements and how they help solve memory leaks with database code. I remember when I first started...

Continue reading "The GC does not solve all memory leaks"