LightSpeed

What's new in LightSpeed 4?

• Improved support for distributed entities via WCF, RIA Services and other distributed scenarios
• Web application enhancements of ASP.NET WebForms and ASP.NET MVC
• RIA Services support
• Metadata capabilities for inspecting LightSpeed type information at runtime
• All new samples and documentation

LightSpeed 3.11 Release Notes

• [Add] SQL Server Compact 4 CTP data provider
• [Add] Queries can traverse through associations
• [Add] User defined mappings between database columns and LightSpeed fields
• [Add] If you do an Update Database and the database does not exist, the designer now offers to create it (SQL Server, MySQL, PostgreSQL and SQL Server Compact only)
• [Add] Improved keyboard support in designer
• [Add] QueryPropertyAttribute allows property names to be decoupled from field names for querying purposes (e.g. polymorphic columns in single table inheritance)
• [Add] Migrations projects can now be in solution folders other than the root
• [Add] LINQ support for .ToString() and Convert.ToString()
• [Add] Support for composite (&& and ||) expressions in Where Any and All LINQ clauses
• [Add] Projections now supported in LINQ join criteria
• [Add] LINQ Where clauses can use scoped subqueries
• [Add] LINQ support for joining subqueries
• [Add] Added LINQ support for DateTime.Date on SQL Server 2008
• [Add] Joins support multiple criteria (via join on anonymous type)
• [Add] ‘Update by query’ now supports the Query.Identifier property
• [Add] Limited support for discriminated derived types in a different assembly from the root type
• [Add] Limited support for custom association resolution (for cross-cutting composite keys)
• [Add] ValidateUniqueAttribute scope argument now supports composite key members
• [Add] EntityFactory.UpdateEntityState added to Testing namespace
• [Add] Batch insert support for Amazon SimpleDB
• [Add] Designer support for nullable stored procedure arguments
• [Add] Designer option to suppress code generation for one-to-one associations
• [Change] Designer warns if you create an association to a concrete table inheritance base class
• [Change] Designer warns if an association is redeclared in a derived class
• [Change] Designer warns if Convert to Auto Through Entity would be an incompatible change
• [Change] VS2010 designer now warns if the project targets the Client Profile
• [Change] Updated MySQL provider to version 6.2.3
• [Change] Updated PostgreSQL provider to Npgsql version 2.0.10
• [Change] Updated SQLite provider to version 1.0.66
• [Change] Updated VistaDB provider to version 4.1
• [Change] Eager load associations declared on derived types of the queried type
• [Change] Hide some validation options in the designer where they don’t make sense for the data type
• [Change] User- and provider-defined types are now displayed in alphabetical order in the designer Data Type drop-down
• [Change] The results of Count are now aligned with those of Find and Count Distinct in paging scenarios
• [Change] Improvements to the DTO guidance sample
• [Fix] Fixed a bug with ordering on group keys that were obtained by traversals
• [Fix] Fix for an error when using joins and projections and an entity property name was translatable to SQL
• [Fix] Fixed a spurious designer warning
• [Fix] Fix for an issue using logical expressions involving nullable properties from Visual Basic
• [Fix] Fix for issues with .NET Remoting
• [Fix] Fixed a designer bug which prevented use of the tree to add CLR attributes
• [Fix] LockVersion is no longer updated on failed saves
• [Fix] Miscellaneous fixes for class table inheritance
• [Fix] Auto through entities now get correct identity type when creating new tables from designer
• [Fix] Designer custom template path now shows even if the .lsmodel file is in a project subfolder
• [Fix] Fixed an issue with missing projects in a solution
• [Fix] Visual Basic LINQ Group By fixes
• [Fix] LINQ .Equals support fixes
• [Fix] Designer now ignores transient properties when creating new tables
• [Fix] Aliasing issue in joins
• [Fix] Fixed an issue with using SqlXxx data types that was causing problems for SQL Server 2008 spatial queries
• [Fix] Fix for designer DTO error if entities were declared internal
• [Fix] SimpleDB LINQ projections
• [Fix] Designer now generates SQL Server Compact blob columns correctly
• [Fix] SimpleDB inequality comparisons and unique validations
• [Fix] Empty linked model should not cause compiler error
• [Fix] VS2010 designer was showing ‘arrows to nowhere’ when using external class references
• [Fix] Fix for spurious table creation when designer contained an auto through entity with an ambiguously singular/plural name
• [Fix] Fixed KeyNotFoundException when sorting on the property of an eager-loaded child entity when the association is nullable
• [Fix] Fix to allow the designer to work with integrated authentication on Oracle
• [Fix] Fixed an error with client-side boolean literals
• [Fix] Respect discriminators when joining to a derived class
• [Fix] Fix for incorrect foreign key being used if an entity has multiple eager-loaded one-to-one associations to different branches of a STI hierarchy
• [Fix] NullReferenceException when selecting a ThroughAssociation member in a LINQ projection
• [Fix] Multiple joins to the same entity
• [Fix] Fix for ForeignKeyFieldAttribute not being respect in eager loads
• [Fix] ‘Unresolved identifier’ errors in generated SQL

LightSpeed O/R mapper is an object relational mapping framework that supports domain driven development and works with both Visual Studio 2008 and Visual Studio 2010.

Mindscape LightSpeed O/R mapper provides querying via a LINQ provider that works seamlessly with SQL Server 2000, 2005, 2008, Oracle 9+, PostgreSQL, MySQL, SQLite, VistaDB, Amazon SimpleDB and DB2.

The Visual Studio designer supports drag and drop design time modeling for all the databases supported by LightSpeed. It includes full schema round tripping meaning that developers can work in a model-first approach or a database-first approach - or even mix and match. The LightSpeed designer will synchronize changes as they are made.

To help manage deployment scenarios, Mindscape LightSpeed includes a visual migrations framework that can be operated directly from within Visual Studio or the command line. This makes managing schema changes a breeze and means developers can be more productive.

LightSpeed O/R mapper also supports:

• Second level caching
• Object property-level change tracking
• Efficient database insert/update batching
• Multiple identity type support
• Single table inheritance, Class table inheritance and Concrete table inheritance
• Domain driven concepts such as ValueObject, Aggregates, etc
• Support for Mono, .NET 2.0, .NET 3.0, .NET 3.5 and .NET 4.0
• Full text search capabilities across all database engines using Lucene (or plug your own provider in)
• Support for database Views and Stored Procedures
• Optimistic concurrency support
• Eager and lazy loading support with tunable eager fetching
• Full support for generics and nullable types
• Support for extended database types (e.g. support SQLGeography when working with SQL Server 2008+)
• Full support for transactions and System.Transactions - Works with ASP.NET Dynamic Data