After upgrading from 5.0.2 to 5.6, I’ve had a few of my queries fail because of the way that OrmLite is translating the linq expression.
db.From(Of Table) .Where(Function(t) t.IsDeleted = False And t.IsActive = False)
but now after upgrading it has to be “AndAlso” otherwise I get an “Incorrect syntax” error
The same problem happens in C# when you use & instead of &&
I get the error
System.Data.SqlClient.SqlException: 'Incorrect syntax near '&'.'
It’s easy enough to fix in our code, but it’s going to be a little hard to find all of the places where we should have AndAlso instead of And or && instead of & in all of the different queries.
I was wondering if that was an intentional change to the way it parses the linq statements or not?