There is a point when we would all love to go back and fix old things we have written. Maybe you learn a new language and wish you could go back and rewrite that old project in it, or how to use a new library that would have improved an old project. Generics and the generic collection objects are like...

Continue reading "Generics and Dictionaries are fast data caches"

Interface Change There is a new public Interface IVistaDBTableList - this is used as an experiment to extending the DDA interface to include strongly typed members. This interface gives you the ability to get back a strongly typed version of the EnumTables through a function called EnumTablesTyped()...

Continue reading "Exposing strongly typed interfaces that are not CLS Compliant"

I have been spending quite a bit of time lately thinking about algorithms. Not always specific concrete ones like sorting items in a list. More in the general sense of how to determine the correct process to create a desired outcome. Easy choices are... easy There are some places where decisions are...

Continue reading "Algorithms – no one size fits all"

Mike and I had an interesting discussion this afternoon about LINQ and how it interprets enumerable rows. Needless to say, some test code had to be written to prove or disprove some theories. Concrete vs Interface Our thought experiment was what if you had an interface to an object and wanted to expose...

Continue reading "LINQ test for custom IEnumerator"

What do you think the coolest feature of VistaDB is today? I get asked this question quite a bit and I never know how to answer. Hmm, we have a lot to choose from. I am going to rattle of a few of my favorites and see what you guys come up with also. Jason's Picks 100% Dot Net - A lot of people don't...

Continue reading "VistaDB Coolest Feature?"

What is the VistaDBContext object? Think of the VistaDBContext as your host container for the CLRProc. It is the part of the engine that is kept per connection and allows the hosted CLRProc to communicate to the Engine through a Pipe object. This is very similar to how it works in SQL Server. Why can...

Continue reading "CLRProcs and VistaDBContext"

Bulk copy from VistaDB to SQL Server Did you know you can use the SqlBulkCopy object to move data from VistaDB to SQL Server? The SqlBulkCopy object allows you to take any IDataReader object to copy. Source and Destination must match The only trick is that the source and destination tables must be setup...

Continue reading "Using SqlBulkCopy to move data from VistaDB to SQL Server"

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"

We have been having a nightmare with our phones (office and cell) for the past few months. Billing problems, lost messages, dropped calls, voice mail that disappears, you name it. Typical day trying to get help Me: This billing is not correct. Cust Svc: That is not this department, call this number....

Continue reading "Good customer service, how often do you say that?"

I saw this one on Dot Net Kicks today. I have seen all of this in different places before, but this blog nicely summarizes all the differences and shows great examples to boot. Code Turkey Test The basic jist is whether your dot net code could run in Turkey. Their date format is different, they have...

Continue reading "Does your code pass the Turkey test?"