I think that far more of your code, mappings, and the generated SQL will be relevant to resolve this issue.
/Oskar 2009/12/1 alish <[email protected]>: > I am working with oracle and nhibernate. I can select list of an > object from db table (all items in table) as Iquerable, but when I try > to select an item from the list using "linq where clause" it sends > nonsense query to oracle db. And it gets invalid identifier error. > > I can get whole list without any error in query, it happens when I use > where clause. > > What can be the problem, any idea? (Some information about query and > mapping document is as below) > > query : > SELECT this_.ID as ID33_0_, > this_.BUNDLEID.........................Where bundleitem1_.ID = :p0 > > (bundleitem1_.ID is invalid) > > related mapping part : > <component name="BundleItem" > class="PromissoryNotes.Server.Data.Bundle, > PromissoryNotes.Server.Data"> > <property name="Id" column="BUNDLEID" type="decimal"></property> > > -- > > 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. > > > -- 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.
