BOOM! That’s the sound of the worlds best .NET ORM getting a major update! :-)
We’re excited to be announcing the immediate availability of the LightSpeed 5 Beta.
We have a big list of addition, changes and bug fixes so for now I’m just going to highlight some key differences in this post. In January we’ll be running a series on the major features when the final version is released.
Compiled queries allow you to speed up querying by having LightSpeed pre-parse the expression and get it ready for sending to the database. This provides a great speed up on repeated queries even if the parameter values change.
Then we got to thinking.
What if common queries (e.g. fetch by Id and others) were always pre-compiled behind the scenes?
What we found was huge: the performance benefits were great. This led us to turning on compiled queries for certain queries by default so you don’t need to use the compiled queries syntax. This resulted in a 60% performance boost. Free performance gain for all LightSpeed users — always a good thing. Especially good since LightSpeed is already blazingly fast!
Note: Posting any sort of performance comparison typically results in howls about how unfair they are or unrealistic but this highlights the speed of LightSpeed’s querying engine for a simple case. Suffice to say, LightSpeed does awesomely in complex scenarios also :-)
Database provider changes
We are working towards allowing end users to implement their own database providers and to allow support for mobile scenarios, to that end we have made some under the hood changes to the provider infrastructure in 5.0 as well as refreshing our supported providers.
Visual Studio 2012 Support
We have had this in the nightly builds most of this year, but it’s worth mentioning again – LightSpeed 5 ships with full designer support for Visual Studio 2012, Visual Studio 2010 and Visual Studio 2008.
Additionally we have dropped the .NET 2.0 only compatibility build of LightSpeed so that LightSpeed can more directly make use of .NET 3.5 features in the core runtime.
Ever improved querying
We have continued iterating our querying support since 4.0 RTM with the core runtime now supporting HAVING expressions and more advanced sub-queries. For LINQ we have improved our handling of more complicated grouping queries and use of sub-queries to support staged query construction using IQueryable. The core runtime now also exposes a RawSql property on the query object to allow arbitrary SQL to be expressed where previously stored procedures or FindBySql would need to be used – this allows joining on an arbitrary SQL statement to handle situations where you need to explicitly control the SQL being emitted.
Whether it’s the ability to get an offending Validation rule when checking an entity is valid, or get more details about your entities using the LightSpeed.Meta framework, you’ll find something to delight you with LightSpeed 5. We look forward to hearing your feedback on the beta and we can’t wait to get LightSpeed 5 final out early in 2013!
The LightSpeed 5 Beta is now available to all active customers, and you can download this from your My Account page now!
Non-customers will have the 5 release in very early 2013 (or you can upgrade from LightSpeed 4 Free Edition and get the beta).