I after using the "old" API for 2 years now, i've jumped into this new "Data Model" Api and i must confess it's really nice to work with.
However, there are time that a SQL query would be a lot easier instead of trying to do it in Linq.
For example, when you need to fetch products according to several criteria that can be optional.
My question is: is there a simple way of using the new Data Model and being able to query it using SQL like in "OA Classic"
IObjectScope scope = ObjectScopeProvider1.GetNewObjectScope();
var query = @
"select * from employees as x where x.employeeId = 1"
var result = scope.GetSqlQuery(query,
(i mean, besides using stored procedures..)