Views, Complex SQL, and Projections

BIZ TMS Aurelius
1

Everything in Aurelius seems to support a single table per entity concept.

Really struggling to figure out how to map our data query needs into entities.

We are rewriting an existing application that uses Oracle/DbExpress.
We have several screens that have read only datasets on them now.

Data can look like the following examples:
Example 1:
TableA.Field1
TableA.Field2
TableB.Field1
TableB.Field2

TableA is a Parent
TableB is Child (Left outer Joined)
So TableA entries will be repeating.

Example2: 

Same as above but contains aggregate data.

TableA.Field1
TableA.Field2
TableB.Field1
TableB.Field2
SUM(TableC.Field3)
COUNT(TableC.Field3)
COUNT(TableD.Field1)

Not TableC and TableD contains millions of rows so pulling this back into memory on the local machine is not an option.

I think that projections can do this, but then I can't map the results to a class that has been defined to accept the results.    Is there way to use the built in functionality to get a project result and automatically put it into a class of my choosing?

Can I using Entity mappings with a view instead of table?





2

The first example is just an association between classes, have you checked those?

Yes you can map views to classes, they will just be read-only. Or you can use projections indeed.
Note that in theory you should not model "queries" into classes. You should just build your conceptual model (classes), then queries will be a consequence of it. Or at least, a second stage of optimization.