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.
(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>
Copmponent "Bundle" has a mapping seperatly in another xml document, I
realized that, when I change the "Bundle" class to another unmapped
class, it works. Problem is about component with mapped classes as
"Bundle". What is the solution, any idea?
--
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.
