AutoMap is a Dot Net library used to transform data model objects to and from data transfer objects. It uses a fluent syntax, helping you manage your data conversion efficiently. Personally, I don’t find it any more efficient that rolling your own transformation methods. However, the standardized way in which it is implemented, and the widespread use of this library […]
Tag: Editorials
SqLite and Dot net
Today I was working with an application where I create a SqLite database for an embedded device. I’ve been using the System.Data.SqLite package started on SourceForge years ago. It provides dot net device drivers for SqLite, implementing the Ado.Net interfaces, allowing me to work with a database using traditional Ado.Net code. The library also supports Entity Framework, should you need […]
What’s In A Name?
I’ve had the pleasure (great deal of sarcasm intended) of recently working with a legacy system where the database objects are limited to 8 or less characters. Table names are often numbered. Column names use some abbreviations in an effort to provide the illuminated with some meaning. To work with these databases a person requires a special decoder ring to […]
What Do I Need To Know?
I’ve been thinking about what would be the most essential skills when working with relational databases. I’d probably break it down into two key capabilities, when it comes to developing performant code. I’d start with a good understanding of relational design. It’s important to know the different forms of normalization, and understand when it is best to apply the more […]
Closing the Loop on Locking
When optimizing an OLTP database, one of the key performance issues is to isolate the writes from the reads. We’ve been talking about using Immutable data as a way to keep reads from blocking writes, by reading without locks, etc. Today I want to talk about another method that works rather well. Even if you use database locking, and have […]
More Immutability
Lots of comments were made regarding immutable of data in a database. Everything prompts me to think further on the topic, as well as provide some clarification. AZ Jim’s comment compares immutable data to that of slowing changing dimensions or facts in a data warehouse. While this is very similar in concept to immutable data, the intention is not exactly […]
Immutable Data
Is there such a thing as immutable data in a relational database? Immutable data is not a term usually applied to a database, it is more of an Object oriented term. Immutable objects are those objects where he values (properties) of an object may not be modified after it is instantiated. The properties may only be set through construction. Once […]
LinqJs
Today I was introduced to a library new to me that has been out there for more than 6 years. LinqJs is a library bringing Linq styled syntax to the JavaScript world. At the core, what Linq does for you is to remove all of the iteration logic from your visible code so that the things that you are intending […]
Another Delay
Again I am going to delay providing my optimized group by example using Entity Framework. The reason for the delay is that I want to fully implement the framework behind my example so I can prove out my understanding of the code that I write, and the code it generates when calling the database. So, today I want to drop […]
Disruption
Today I am supposed to be demonstrating how to do aggregation efficiently through the use of Linq syntax. I am unable to complete that editorial today as promised, so am going to take a moment to share a little bit of personal conflict that applies to us all at some time or another. I’ve been writing software for more than […]