Hi,
I use QueryOver<A> and JoinQueryOver<B> and compare Guid property to Guid
value as follow:
Guid guidFeild;
Session.QueryOver<CheckpointToProtectionGroup>()
.JoinQueryOver(row => row.ProtectionGroup)
.Where(row => row.ProtectionGroupIdentifier.GroupGuid ==
guidFeild)
.SingleOrDefault();
I get the following Exception:
[SQL: SELECT tag FROM CheckpointToProtectionGroup cp2pg JOIN
CheckpointStorageObject cp ON cp.id = cp2pg.checkpoint_id JOIN
ProtectionGroupCheckpointStorageObject pg ON pg.id = cp2pg.vpg_id WHERE
cp.CheckpointIdentifierIdentifier = 1111 AND
pg.ProtectionGroupIdentifierGroupGuid
= 11111111-1111-1111-1111-111111111111] --->
System.Data.SqlServerCe.SqlCeException: The conversion is not supported. [
Type to convert from (if known) = uniqueidentifier, Type to convert to (if
known) = numeric ]
It seems that NHibernate can't convert the Guid value to uniqueIdentifier
type.
In output SQL I don't see any parameter assignment like other queries I use
(@p0, @p1)
also, there is not Type assingment - [Type: Guid (0)]
Need you advice,
Haim
--
You received this message because you are subscribed to the Google Groups
"nhusers" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/nhusers/-/4Wc7NzkXxl8J.
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.
