Hello guys!
We have a web application which has some methods defined by user and
executed by Codedom (CSharpCodeProvider) between our code. Our customer has
programmers that can adpts business rules over the project and execute some
queries on the scope of execution. We have a simple query like below
execution on Codedom:
var employeeTeam = Session.Query<EmployeeTeam>()
.Where(x => x.StartEffective <= competency.FinalDate
&& // competency.FinalDate is a DateTime
employeesIds.Contains(x.EmployeeId)) //
employeeIds is a List<long>
.OrderByDescending(x => x.StartEffective)
.Select(x => new
{
x.EmployeeId,
x.StartEffective,
x.Team
}).ToList();
It successfully runs once, but when executed in the second time (or third,
fourth and so son) it throws an invalid cast exception like:
Fatal Error:System.InvalidCastException: Cannot convert type
'System.Linq.EnumerableQuery`1[<>f__AnonymousType0`3[System.Int64,System.DateTime,Team]]'
to
'System.Collections.Generic.IEnumerable`1[<>f__AnonymousType0`3[System.Int64,System.DateTime,Team]]'.
in NHibernate.Linq.DefaultQueryProvider.Execute[TResult](Expression
expression)
Rest of the stack trace supressed for bravety.
The query is always executed in database before the error. It returns no
records, but it's ok. If we rebuild the solution and run again, the query
is executed in first time again, and then start throwing the exception each
other time I run it. Other queries runs everytime without any problems. We
have no idea of what causes the error.
Its important to say that this code is running in an CSharpCodeProvider
environment, but we don't know if it can make a difference. We also tried
everything, for sample, removing Where(), OrderBy(), changing the Select()
return, etc... but no progress.
We think the problem is with Anonnymous objects return because if we do a
DTO to return a result, it executes ok. If we just return a single value
using .Select(x => x.EmployeeId), it executes ok too. We do not want to
force the user defined a DTO for each custom query they can do.
We just realize that if I add the following property to the annon object,
the query works everytime:
Rnd = (new Random().Next(1, 999))
(it's a terrible solution but it worked)
So, a cache issue maybe?
Thank you.
--
______________________________________
Felipe B Oriani
[email protected]
--
You received this message because you are subscribed to the Google Groups
"nhusers" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/nhusers.
For more options, visit https://groups.google.com/d/optout.
