Entity Framework Core - Knowledge Base (KB)

Is there a way to cast in the `Where` part of an Entity Framework query?

To be clear, I am not referring to performing a ....Cast<T>... on the results of an EF call....I'm trying to implement a partial search on a number field....When creating a SQL script, it is easy to convert a column to another data type:...SELECT Id FROM ...

Why Entity Framework throws invalid cast

No matter what method I use to query for data on I can't get past this one method. It always throws an error:...Specified cast is not valid....Not sure why this one is going nuts on the casting. The column is defined as ...INT(10)... in MySQL, the model i...

How to cast string to class property

I have a model for my database (using efcore to translate between model and database) that contains a string that can be three values....In order to better control the string values going into the db, I created an enum of sorts (which you can't do in C# s...