We get frequent inquiries about how LightSpeed compares with other object relational mapping frameworks that are available. Last year we published our comparison matrix that compared LightSpeed, LINQ to SQL and LINQ to Entities. We’ve now updated the comparison matrix to also include EntitySpaces and Telerik OpenAccess.
First off, this is not an exhaustive feature comparison – there are many small and handy features included in all object relational mappers which didn’t get included (LightSpeed included). For example, while EntitySpaces does not support ASP.NET Dynamic Data, it does include templates to rapidly create a CRUD site should you want one which achieves a similar goal to Dynamic Data. This matrix is designed to give a rough idea of how the products compare.
We have only included LINQ to SQL, LINQ to Entities, EntitySpaces and OpenAccess because of space constraints. Thanks also to Mike from EntitySpaces who helped in clarifying the feature set available with EntitySpaces.
Features are handy, but need to be considered against price. At the time of writing (and please remember prices are always subject to change), the products in our matrix are priced as follows:
LightSpeed – Free Express edition; commercial editions up to $499 USD (not per developer, often the entire price for your whole team)
LINQ to SQL / LINQ to Entities – Included in the .NET Framework and Visual Studio
EntitySpaces – Up to $299 USD per developer (company fee of $499 if you want source)
Telerik OpenAccess – Free for open source databases; commercial licenses up to $599 USD per developer
Pricing is a complex thing and we’ve only included the cheapest and the most expensive editions in the ranges listed but hopefully it helps in the comparison of the object relational mappers available at the moment.
Consider: Frequency of updates
Also consider the frequency of enhancements. Microsoft enhancements to their LINQ-to-X products are tied to .NET framework releases and therefore result in needing to use workarounds for a considerable amount of time. LightSpeed, EntitySpaces and OpenAccess all get updates several times a year, resulting in faster turn around of enhancements. Mindscape has also offered nightly builds of LightSpeed for some time and therefore developers get access to new features as they’re built.
I hope that helps people when deciding on the object relational mapper for their next project. Please leave any comments you have about this comparison as comments on this blog post.