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.


Reply via email to