There is a new bug on the version 6.10 not found on version 5.70.
If you have a Master/Detail table and you use the LoadWith, the correct values are not grabbed.
Something like this will throw an exception:
Code: Select all
var dictionary = new Dictionary();
foreach (var m in context.Masters.LoadWith(n => n.Detail))
dictionary.Add(m.Id, m);
As an example, this is the query generated by Devart
Code: Select all
SELECT t1.ID, t1.NAME, t1.KIND_ID, t2.ID AS ID1, t2.STATUS_ID, t2.VALUE, t2.ORDER_SEQUENCE
FROM PUMA_STATUS_DEFINITION t1
LEFT OUTER JOIN PUMA_STATUS_VALUE_DEFINITION t2 ON t1.ID = t2.STATUS_ID
-- Context: Devart.Data.Oracle.Linq.Provider.OracleDataProvider Model: ao Build: 2.20.11.0