I think the intended SQL looks like
from t_versions ver
join (select id_file, max(t_version) as z from t_versions group by id_file) as x
on (x.id_file = ver.id_file and x.z = ver.version);
The IN statement is not usable, as it is limited to single values, not tuples.
Unfortunately, there is no LINQ that DataAccess translates into this SQL, and you will need to express this functionality via SQL directly.
OpenAccess ORM is now Telerik Data Access
. For more information on the new names, please, check out the Telerik Product Map