Драйверы DevArt MySql EF6: для столбцов с нулевым значением BIT (1) строки с нулевым значением всегда оцениваются как истинные для 'COLUMN_NAME ?? ложный'

В качестве временного временного решения мы решили использовать перехватчик EF6 в mysql, чтобы обнаруживать и исправлять операторы sql на лету, нацеленные на логические столбцы (к счастью, большинство, если не все наши логические столбцы имеют постфикс _YN, который помогает отличная сделка):

using System.Data;
using System.Data.Common;
using System.Data.Entity.Infrastructure.Interception;
using System.Text.RegularExpressions;

namespace Some.Namespace
{
    //to future maintainers     the devart mysql drivers for ef6 ver8.10.1086.0 suffer from what appears to be a very annoying b.ug which cause nullable bit(1) columns set to null
    //to future maintainers     to always be materialized to true when we evaluate them like so
    //to future maintainers
    //to future maintainers                                                  x.SOME_BOOLEAN_COLUMN ?? false
    //to future maintainers
    //to future maintainers     this is obviously flat out wrong and to remedy this issue we intercept the offending sql snippets and hotfix them like so
    //to future maintainers    
    //to future maintainers                before => CASE WHEN Extent1.NFS_SUBFILTER_YN    IS NULL THEN 1 ELSE             Extent1.NFS_SUBFILTER_YN            END
    //to future maintainers                after  => CASE WHEN Extent1.NFS_SUBFILTER_YN    IS NULL THEN 1 ELSE     CAST(Extent1.NFS_SUBFILTER_YN AS SIGNED)    END
    //to future maintainers
    public sealed class MySqlHotFixerCommandInterceptor : IDbCommandInterceptor
    {
        //beforeexecution
        public void ScalarExecuting(DbCommand command, DbCommandInterceptionContext<object> interceptionContext) => LogWarningBeforeExecutionIfSynchronousExecutionIsFound(command, interceptionContext);
        public void ReaderExecuting(DbCommand command, DbCommandInterceptionContext<DbDataReader> interceptionContext) => LogWarningBeforeExecutionIfSynchronousExecutionIsFound(command, interceptionContext);
        public void NonQueryExecuting(DbCommand command, DbCommandInterceptionContext<int> interceptionContext) => LogWarningBeforeExecutionIfSynchronousExecutionIsFound(command, interceptionContext);

        //afterexecution
        public void ScalarExecuted(DbCommand command, DbCommandInterceptionContext<object> interceptionContext) {}
        public void ReaderExecuted(DbCommand command, DbCommandInterceptionContext<DbDataReader> interceptionContext) {}
        public void NonQueryExecuted(DbCommand command, DbCommandInterceptionContext<int> interceptionContext) {}

        static private void LogWarningBeforeExecutionIfSynchronousExecutionIsFound<TResult>(IDbCommand command, DbCommandInterceptionContext<TResult> interceptionContext)
        {
            if (interceptionContext.Exception != null)
                return;

            command.CommandText = FaultySwitchCaseSpotter1.Replace(command.CommandText, "CAST($3 AS SIGNED)");
            command.CommandText = FaultySwitchCaseSpotter2.Replace(command.CommandText, "CAST($3 AS SIGNED)");
        }

        private static readonly Regex FaultySwitchCaseSpotter1 = new Regex(@"(?<=CASE\s+WHEN\s+(`?[a-zA-Z0-9_]+?`?[.])?`?[a-zA-Z0-9_]+?`?\s+IS\s+NULL\s+THEN\s+(0|1)\s+ELSE\s+)((`?[a-zA-Z0-9_]+?`?[.])?`?[a-zA-Z0-9_]+?`?)(?=\s*END)", RegexOptions.IgnoreCase);
        private static readonly Regex FaultySwitchCaseSpotter2 = new Regex(@"(?<=CASE\s+WHEN\s+(`?[a-zA-Z0-9_]+?`?[.])?`?[a-zA-Z0-9_]+?_YN`?\s+IS\s+NULL\s+THEN\s+(\d+|.[a-zA-Z0-9_]+?|`?[a-zA-Z0-9_]+?`?[.]`?[a-zA-Z0-9_]+?`?)\s+ELSE\s+)((`?[a-zA-Z0-9_]+?`?[.])?`?[a-zA-Z0-9_]+?_YN`?)(?=\s*END)", RegexOptions.IgnoreCase);
    }
}

Также необходимо настроить web.config / app.config, например:

<configuration>

  <entityFramework>
    <defaultConnectionFactory type = "System.Data.Entity.Infrastructure.SqlConnectionFactory, EntityFramework">
       [...]
    </defaultConnectionFactory>

    <providers>
       [...]
    </providers>

    <interceptors>
      <!-- keep first -->
      <interceptor type = "Some.Namespace.MySqlHotFixerCommandInterceptor, Organotiki.Infrastructure.Core">
      </interceptor>
      [...]
    </interceptors>
  </entityFramework>
</configuration>