Relational modeling and CRUD

I’m experimenting with support for relational modeling for #liveDB based on generics. Here’s a peek at how this is progressing.

Entities

Entities of type E are stored in an EntitySet, which wraps a SortedSet, a new collection class in .NET 4 implemented as a balanced binary tree with O(log N) read and write operations. Entities need to be orderable within the sorted set, which can be achieved using a key property implementing IComparable or having the entity itself implement IComparable. Here are some example entities with keys defined in three different ways:

The Category entity has a property named Id of type IComparable which by naming convention will be used as a key. The User entity has a property marked with KeyAttribute. Task implements IComparable so Task objects will themselves be used as key and the Id property will be ignored. Task has a foreign key property, CategoryId, but notice that none of the entities have any outbound object references. An entity can be an aggregation but must be an isolated from other entities meaning no inbound or outbound object references. For example, an Order entity can have a collection of OrderLine objects.

This isolation is important for queries. Imagine an N-to-N relationship between Category and Task above, where Category has a collection of Tasks and Task has a collection of Categories. A query for a single task could possibly return every Task and Category in the database! This is a common beginners mistake. Normally, we deal with this issue by returning specific view objects stripped from references. We could for instance have a TaskView class with the categories represented as a list of string.

The model

Next, create a model and derive from RelationalModel, defining entity sets in the constructor:

Not much going on here, really.

CRUD commands and querying

Now start your engine and you’re all set up for basic CRUD using commands of type AddEntityCommand, RemoveEntityCommand and ReplaceEntityCommand. Of course, nothing is stopping you from also creating custom commands. EntitySet implements IEnumerable so query as usual using lambdas or Query<M,R> instances.

Here is the AddEntityCommand in action:

Conclusion

Ok, so this isn’t really relational but it does enable basic CRUD, provided you do your modeling correctly. With CRUD you don’t have to write specific task-oriented commands and you can return entities from queries without having to map to reference-stripped view objects.