So now I start to understand. You have an entity that does not map to a table. Instead you write a custom sql to load it from any other table.
I don't have much experience with custom sql queries and can't tell you whats going wrong. But to identify the problem you should take a look at the generated sql. Use some tool like profiler for Sql Server or let NH write the generated sql to a log file. Then you will quickly find out what NH is trying to do when this error happens. I suspect that it tries to update the entity. (It's not immutable and there is not sql for updating.) On 20 Aug., 21:30, mathmax <[email protected]> wrote: > magneto131 is the name of the mysql database (set in the config file). > But Nhibernate shouldn't look at a table called Shipping in this > database since the entity should be loaded via the sql query. > > On 20 août, 08:58, Stefan Steinegger <[email protected]> > wrote: > > > Where does this magneto131 come from? I is certainly not invented by > > NH ... > > > On 12 Aug., 14:13, mathmax <[email protected]> wrote: > > > > > shipping_method as {ship.Id}inverted > > > > I don't understand. What do you mean by inverted ? It's like the > > > example: First the field to the database, then the corresponding > > > property of the entity > > > > > But does the table "magneto131.Shipping" exist? > > > > I create a query to avoid having to create a view or a table on the > > > database. So, no magneto131.Shipping doesn't exist. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "nhusers" 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/nhusers?hl=en -~----------~----~----~----~------~----~------~--~---
