OpenGiving
OpenGiving
So how do you query in the text-based Where clause of an LINQ to Entity query? This question drove me up the wall! I’m used to the CONVERT function, or just passing a string, or with a full-on LINQ query, using a DateTime object. With an EntityDataSource, though, you specify the where clause using the Where property which is a string. First, I couldn’t even figure out how to refer to a column. “IsCancelled” (my column name) didn’t work. The Visual Studio expression editor did not help one bit. Finally, I came across some samples. You need to prefix...