Paul-
I've actually--somewhat--worked through the issue by setting up
extracts of the data into another store that I have control over and
creating materialized views off of that; then I can create the
necessary FKs and model for NHibernate. I'll ask over on the NHib
users group though to see if anyone has any suggestions.
Thanks!
-dl
On Dec 8, 4:01 am, "Paul Batum" <[EMAIL PROTECTED]> wrote:
> Hi David,
>
> I don't have the necessary nhibernate knowledge to help you. If you can get
> some instruction on how to do it with nhibernate, we can then look at how it
> could be done with fluent nhibernate. I would suggest you ask your question
> on the nhibernate users group.
>
> Paul Batum
>
> On Fri, Dec 5, 2008 at 12:49 AM, David R. Longnecker <[EMAIL PROTECTED]
>
> > wrote:
>
> > Hello!
>
> > I'm attempting to apply NHibernate to one of our Oracle systems to
> > provide read-only access to the data; however, that system is... less
> > than "model" oriented or relational and we do not have a means of
> > changing it (vendor database). Currently, we build most of those
> > relations by hand linking fields together.
>
> > Our ADO.NET & ODP connections based the model off of a base query.
> > Something along the lines of:
>
> > "SELECT (DISTINCT) { whatever } FROM { tables } WHERE EXISTS
> > { exists } ORDER BY { columns }"
>
> > etc.
>
> > Normally, I could create a view or materialized view to match this
> > query and base the fNH model off of that, but not on this system.
>
> > So, question: Can you base a model in fNH (or NH in general) off of a
> > query? If not, any ideas on a good way to handle such an environment?
>
> > Thanks in advance!
>
> > -dl
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Fluent NHibernate" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/fluent-nhibernate?hl=en
-~----------~----~----~----~------~----~------~--~---
