Approach 2

In the custom model package structure, model an extension entity which extends the Curam-shipped entity (if such an extension does not already exist).

In the extension entity, model a stereotyped retrieval operation (read/readmulti/nsread/nsmulti/ns). The retrieval operation is free to return any data that it requires, including data joined from custom database tables, and to use any suitable return struct (i.e. the restrictions in Approach 1 do not apply here)..

In your client code which requires to execute your custom search, invoke the generated DAL code directly. Note that:

• you must not invoke any database write methods directly from your client code;
• derived data which might ordinarily be provided by a service-layer class will not be available; and
• data held on custom side-saddle table will only be available via a separate call to the generated DAL code for that custom side-saddle table.