Cannot execute Nhibernate query

Question

I get the following Nhiberante error, but have no idea why:

could not execute query [ select attachment0_.AttachmentId as Attachme1_9_, attachment0_.Name as Name9_, attachment0_.IconUrl as IconUrl9_, attachment0_.UserId as UserId9_, attachment0_.AttachmentTypeId as Attachme6_9_, attachment0_.IsDeleted as IsDeleted9_, attachment0_.ArrivalTime as ArrivalT8_9_, attachment0_.LocationId as LocationId9_ from Attachment_Attachment attachment0_ where attachment0_.DYNAMIC_TYPE='Attachment' and 1=0 ] [SQL: select attachment0_.AttachmentId as Attachme1_9_, attachment0_.Name as Name9_, attachment0_.IconUrl as IconUrl9_, attachment0_.UserId as UserId9_, attachment0_.AttachmentTypeId as Attachme6_9_, attachment0_.IsDeleted as IsDeleted9_, attachment0_.ArrivalTime as ArrivalT8_9_, attachment0_.LocationId as LocationId9_ from Attachment_Attachment attachment0_ where attachment0_.DYNAMIC_TYPE='Attachment' and 1=0]

Update:

inner exception:

Failed to convert parameter value from a WhereSelectListIterator`2 to a Guid.

My query:

x => locationsIds.Contains(x.LocationId)

Failed to convert parameter value from a WhereSelectListIterator`2 to a Guid. — Elad Benda
– Elad Benda, Commented Mar 28, 2012 at 20:25
What type is locationsIds? Also, I'm sure not nHibernate can handle this type of query, essentially a WHERE [field] in [LIST] where list is a variable. — Rich
– Rich, Commented Mar 28, 2012 at 21:10
@ Rich ids are guid. How can I verify what is applicable linq by NH? — Elad Benda
– Elad Benda, Commented Mar 29, 2012 at 15:55

Victor Grigoriu · Accepted Answer · 2013-05-10 12:55:54Z

3

locationsIds is probably an IEnumerable returned by a call to Where. The simplest solution is to explicitly convert it to a list:

var idsList = locationIds.ToList();
x => idsList.Contains(x.LocationId);

answered May 10, 2013 at 12:55

Victor Grigoriu

4795 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Claudio Redi · Accepted Answer · 2012-03-23 22:02:52Z

1

Check the InnerException. I'm sure it will point you to the correct place.

answered Mar 23, 2012 at 22:02

Claudio Redi

68.6k15 gold badges138 silver badges161 bronze badges

1 Comment

Elad Benda Over a year ago

Failed to convert parameter value from a WhereSelectListIterator`2 to a Guid. Any idea?

Halvard · Accepted Answer · 2016-10-13 12:28:14Z

0

I know this specific question have been answered here, but I have also had this exception (with different column names) and the reason it failed was that I had used the wrong database. I had added a new table to one database, but when I ran the code I had configured it to use another database. Once I used the correct database the error disappeared.

I hope this helps someone!

answered Oct 13, 2016 at 12:28

Halvard

4,0017 gold badges42 silver badges54 bronze badges

Collectives™ on Stack Overflow

Cannot execute Nhibernate query

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related