LightSpeed supports SQL CE 4

Version 3.11 also adds support for user-defined runtime conversions between database and CLR types.

Zoom [+]

Viewing the StoreModel sample in LightSpeed.

LightSpeed is a high performance .NET domain modeling and O/R mapping framework. LightSpeed has first class LINQ support, Visual Studio 2008 and Visual Studio 2010 designer integration and a high performance core framework which means you can create rich domain-driven models more quickly and easily than ever before. 

Updates in V3.11

Additions

• SQL Server Compact 4 CTP data provider
• Queries can traverse through associations
• User defined mappings between database columns and LightSpeed fields
• 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)
• Improved keyboard support in designer
• QueryPropertyAttribute allows property names to be decoupled from field names for querying purposes (e.g. polymorphic columns in single table inheritance)
• Migrations projects can now be in solution folders other than the root
• LINQ support for .ToString() and Convert.ToString()
• Support for composite (&& and ||) expressions in Where Any and All LINQ clauses
• Projections now supported in LINQ join criteria
• LINQ Where clauses can use scoped subqueries
• LINQ support for joining subqueries
• Added LINQ support for DateTime.Date on SQL Server 2008
• Joins support multiple criteria (via join on anonymous type)
• ‘Update by query’ now supports the Query.Identifier property
• Limited support for discriminated derived types in a different assembly from the root type
• Limited support for custom association resolution (for cross-cutting composite keys)
• ValidateUniqueAttribute scope argument now supports composite key members
• EntityFactory.UpdateEntityState added to Testing namespace
• Batch insert support for Amazon SimpleDB
• Designer support for nullable stored procedure arguments
• Designer option to suppress code generation for one-to-one associations

Changes

• Designer warns if you create an association to a concrete table inheritance base class
• Designer warns if an association is redeclared in a derived class
• Designer warns if Convert to Auto Through Entity would be an incompatible change
• VS2010 designer now warns if the project targets the Client Profile
• Updated MySQL provider to version 6.2.3
• Updated PostgreSQL provider to Npgsql version 2.0.10
• Updated SQLite provider to version 1.0.66
• Updated VistaDB provider to version 4.1
• Eager load associations declared on derived types of the queried type
• Hide some validation options in the designer where they don’t make sense for the data type
• User- and provider-defined types are now displayed in alphabetical order in the designer Data Type drop-down
• The results of Count are now aligned with those of Find and Count Distinct in paging scenarios
• Improvements to the DTO guidance sample

Fixes

• Fixed a bug with ordering on group keys that were obtained by traversals
• Fix for an error when using joins and projections and an entity property name was translatable to SQL
• Fixed a spurious designer warning
• Fix for an issue using logical expressions involving nullable properties from Visual Basic
• Fix for issues with .NET Remoting
• Fixed a designer bug which prevented use of the tree to add CLR attributes
• LockVersion is no longer updated on failed saves
• Miscellaneous fixes for class table inheritance
• Auto through entities now get correct identity type when creating new tables from designer
• Designer custom template path now shows even if the .lsmodel file is in a project subfolder
• Fixed an issue with missing projects in a solution
• Visual Basic LINQ Group By fixes
• LINQ .Equals support fixes
• Designer now ignores transient properties when creating new tables
• Aliasing issue in joins
• Fixed an issue with using SqlXxx data types that was causing problems for SQL Server 2008 spatial queries
• Fix for designer DTO error if entities were declared internal
• SimpleDB LINQ projections
• Designer now generates SQL Server Compact blob columns correctly
• SimpleDB inequality comparisons and unique validations
• Empty linked model should not cause compiler error
• VS2010 designer was showing ‘arrows to nowhere’ when using external class references
• Fix for spurious table creation when designer contained an auto through entity with an ambiguously singular/plural name
• Fixed KeyNotFoundException when sorting on the property of an eager-loaded child entity when the association is nullable
• Fix to allow the designer to work with integrated authentication on Oracle
• Fixed an error with client-side boolean literals
• Respect discriminators when joining to a derived class
• 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
• NullReferenceException when selecting a ThroughAssociation member in a LINQ projection
• Multiple joins to the same entity
• Fix for ForeignKeyFieldAttribute not being respect in eager loads
• 'Unresolved identifier' errors in generated SQL

About Mindscape

Mindscape is a software development tools company that produces leading edge components for .NET developers. Mindscape focuses on delivering tools that make developers more productive and aid in creating robust and beautiful applications for their customers.