static private void HotfixFaultySqlCommands <TResult>(IDbCommand command, DbCommandInterceptionContext <TResult> interceptionContext) { if (!command.CommandText.TrimStart().StartsWith("SELECT", ignoreCase: true, culture: CultureInfo.InvariantCulture)) { return; } command.CommandText = BooleanColumnSpotter.Replace(command.CommandText, "CAST ($1 AS BIT)"); }
static private void HotfixFaultySqlCommands <TResult>(IDbCommand command, DbCommandInterceptionContext <TResult> interceptionContext) { if ((interceptionContext.DbContexts.FirstOrDefault() as IVNextDbContext)?.DatabaseType != DatabaseTypeEnum.MicrosoftSqlServer) { return; } if (!command.CommandText.TrimStart().StartsWith("SELECT", ignoreCase: true, culture: CultureInfo.InvariantCulture)) { return; } command.CommandText = BooleanColumnSpotter.Replace(command.CommandText, "CAST ($1 AS BIT)"); }