Devart Forums

Code: Select all

SELECT 
Var_1.Id,
Var_1.Name,
Var_1.DisplayName,
Var_1.Icon,
Var_1.IsDeleted
FROM MyLanguages Var_1
WHERE (Var_1.IsDeleted = :DynamicFilterParam_1) OR (:DynamicFilterParam_2 IS NOT NULL)

-- DynamicFilterParam_1: 'null' (Type = Boolean, IsNullable = false)
-- DynamicFilterParam_2: 'null' (Type = Boolean, IsNullable = false)

Code: Select all

SELECT 
Extent1.Id,
Extent1.Name,
Extent1.DisplayName,
Extent1.Icon,
Extent1.IsDeleted
FROM MyLanguages Extent1
WHERE (Extent1.IsDeleted = :DynamicFilterParam_000001) OR (:DynamicFilterParam_000002 IS NOT NULL)

Code: Select all

SELECT 
Extent1.Id,
Extent1.Name,
Extent1.DisplayName,
Extent1.Icon,
Extent1.IsDeleted
FROM MyLanguages Extent1
WHERE (Extent1.IsDeleted = :DynamicFilterParam_000001)

Code: Select all

  internal class CommandInterceptor: IDbCommandInterceptor {
    public void NonQueryExecuted(DbCommand command, DbCommandInterceptionContext<int> interceptionContext) {
    }

    public void NonQueryExecuting(DbCommand command, DbCommandInterceptionContext<int> interceptionContext) {
    }

    public void ReaderExecuted(DbCommand command, DbCommandInterceptionContext<DbDataReader> interceptionContext) {
    }

    public void ReaderExecuting(DbCommand command, DbCommandInterceptionContext<DbDataReader> interceptionContext) {

      for (int i = command.Parameters.Count - 1; i >= 0; i--) {
        var param = command.Parameters[i];
        if (!command.CommandText.Contains(":" + param.ParameterName))
          command.Parameters.Remove(param);
      }
    }

    public void ScalarExecuted(DbCommand command, DbCommandInterceptionContext<object> interceptionContext) {
    }

    public void ScalarExecuting(DbCommand command, DbCommandInterceptionContext<object> interceptionContext) {
    }
  }

Code: Select all

            var context = new ExampleContext();

Code: Select all

            var context = new ExampleContext();
            context.DisableAllFilters();
            context.Languages.Any();
            System.Data.Entity.Infrastructure.Interception.DbInterception.Add(new CommandInterceptor());
            context.EnableAllFilters();

Code: Select all

exec sp_executesql N'SELECT 
    CASE WHEN ( EXISTS (SELECT 
        1 AS [C1]
        FROM [dbo].[MyLanguages] AS [Extent1]
        WHERE ([Extent1].[IsDeleted] = @DynamicFilterParam_000001) 
    )) THEN cast(1 as bit) ELSE cast(0 as bit) END AS [C1]
    FROM  ( SELECT 1 AS X ) AS [SingleRowTable1]',N'@DynamicFilterParam_000001 bit,@DynamicFilterParam_000002 bit',@DynamicFilterParam_000001=1,@DynamicFilterParam_000002=NULL

Code: Select all

var context = new ExampleContext();
            context.DisableAllFilters();
            context.Languages.Any();
            System.Data.Entity.Infrastructure.Interception.DbInterception.Add(new CommandInterceptor());
            context.EnableAllFilters();
            context.Languages.Any();

Code: Select all

var context = new ExampleContext();
            //context.DisableAllFilters();
            //context.Languages.Any();
            System.Data.Entity.Infrastructure.Interception.DbInterception.Add(new CommandInterceptor());
            context.EnableAllFilters();
           context.Languages.Any();