This week I decided that I wanted to know how to write queries in Linq. I am not talking about the Linq extension methods, which I have used extensively, but the query syntax which uses keywords such as “from” … Read more
Last week’s provided an introduction to SQLite, a useful and lightweight RDBMS which is in fact the most widely deployed database system in the world.
This week we will demonstrate the creation of a database in SQLite. To do … Read more
Most people in software agree that unit testing is a good thing. It is certainly one of the biggest developments in the way we code to occur in the last 20 years. Whether you unit test or not, you probably … Read more
You probably know that database indexes are a means for improving database performance. But surprisingly few people understand the different types of indexes there are, how they work, and how to choose an appropriate index for a specific performance problem … Read more