We have 3 developers in my group. 2 of us are encountering an ORA-00904: "TOLOWER": invalid identifier on a linq query. We have similar machines and configurations. We are building a silverlight / asp app that utilizes both the EF 4.0 and direct SQL calls. We haven't made any changes to the code when building on all 3 machines. One other important note, this error only occurs when we debug with cassini. If we publish to IIS, there is no error.
We have encountered this issue repeatedly over the last couple of years. Sometimes, I'd revert any changes on my project, rebuild, then add the changes back in, and the error would go away. Any ideas what is going on?
The query...
Code: Select all
User user = context.Users
.Where(q => q.LOGINID.ToLower() == userName_lower))
.FirstOrDefault();