Thank you for your answer, it works for the problem I posted. I tried to continue my evaluation by modifying my query to include an inner join and I saw that GetOqlQuery supports another format for its queries (which is fine as it use mapped classes). I have 3 other questions :
1) I have a legacy DLL that returns a select statement when a user performs a search and I need to be able to execute the following query :
I tried a similar query with another table that has only one primary key (with GetSqlQuery) and it worked. Is there a way to make this type of query works with my Position table (that has 2 primary keys) ?
2) I have a legacy database that I cannot change that has the following schema :
OpenAccess was not able to find the relation between StringNumber and MediumStrings and when I tried to add it manually I saw that I needed to use both PK columns in MediumStrings for the relation between StringNumber and MediumStrings. I modified the relation from MediumStrings to StringNumber to be a "one to many" and it worked but I still want to know if it is possible to create a relation without using all the PK columns or using a column that is not a PK).
3) For reporting/performance reasons I create views, is it possible to map them in OpenAccess?
Thanks !