Consider the following query:
context.Catalogs.Any(c => c.CatalogName.Equals(testCase, StringComparison.OrdinalIgnoreCase));
If the DBContext is pointing at a real database then this query evaluates correctly (that is, true if it finds a string match irrespective to case).
If I create the DBContext using the Effort EntitiyConnectionFactory then the query does NOT evaluate correctly.
The following works for both:
context.Catalogs.Any(c => c.CatalogName.ToLower() == testCase.ToLower());
Have I found a bug in Effort? I have a complete test solution for this that I can provide for you if you'd like. Please let me know. Thanks - love this framework and I hope you stick with it!