Hi,
in our application framework we make frequent use of temporary tables, e.g., to pass data to Crystal Reports or things like this.
These use cases are well defined (not just ad-hoc), and for each of these temporary tables, we do have an actual (always empty) table in our schema (which defines the structure). So we can generate entities for those tables, which correspond exactly to the temporary tables we have at runtime.
What would be great is if we could populate an EntityCollection with the data of a temporary table at runtime, with the ability to save the EntityCollection back to the temp table.
Filling the EntityCollection is already possible with projections, but it is cumbersome since all fields have to be defined even though the whole structure of the temp table was generated into the entity already at design time..
In essence, all that's changed between between design time and runtime is the table name. So to me it seems all that's needed to make this possible is to change the PersitenceInfo of the entity in question so that it points to the temporary table.
Is there a way to accomplish this?
Thanks,
andreas