Release notes for re-motion version 1.13.58

List of Issues

New Features

Performance

Details

[COMMONS-2666] Support for AllResultOperator

Component/s: Data.Linq
Issue Type: New Feature
Resolution: Fixed
Status: Closed


Support for queries of the following form: Cooks.All (c => c.IsStarredCook)

The SQL generated for this query contains a NOT EXISTS clause and a WHERE clause with an inversion of the condition in the All clause. (NOT EXISTS (SELECT ... FROM ... WHERE NOT ([t0].[IsStarredCook] = 1)))

[COMMONS-2614] Support for queries using persistent mixed properties

Component/s: Data.Linq Data.Linq for re-store Mixins
Issue Type: New Feature
Resolution: Fixed
Status: Closed


(no description)

[COMMONS-1100] Support for Sum, Average, Min, and Max result operators

Component/s: Data.Linq
Issue Type: New Feature
Resolution: Fixed
Status: Closed


(no description)

[COMMONS-2443] Optimize implicit joins: use foreign key instead of join if possible

Component/s: Data.Linq
Issue Type: Performance
Resolution: Fixed
Status: Closed


In queries such as the following, avoid creating a join if the foreign key is already available:

from k in Kitchens where k.Cook == null select k

If the KitchenTable contains the foreign key, this should avoid creating a join and yield SQL similar to the following:

SELECT [t0].*
FROM [KitchenTable] [t0]
WHERE [t0].[CookID] IS NULL

[COMMONS-2231] Backend: SqlGeneratorVisitor should not iterate over the same field descriptors multiple times when passing them to SqlGenerationData

Component/s: Data.Linq
Issue Type: Performance
Resolution: Won't Fix yet
Status: Closed


(no description)