SqlTableDependencyFilter don't use Custom Mapping about monitor-table-change-with-sqltabledependency HOT 1 CLOSED

            // Because our model has a property that does not match table column name, we need a mapper C# Model PROPERTY <--> Database Table Column Name
            var mapper = new ModelToTableMapper<Product>();
            mapper.AddMapping(c => c.ItemsInStock, "Quantity");
            mapper.AddMapping(c => c.ComTime, "COM_TIME");

            // Define WHERE filter specifing the WHERE condition
            // We also pass the mapper defined above as last contructor's parameter
            var ti = DateTime.Now;
            Expression<Func<Product, bool>> expression = p => (p.ComTime > ti);
            ITableDependencyFilter whereCondition = new SqlTableDependencyFilter<Product>(expression, mapper);

            // Create SqlTableDependency and pass filter condition, as weel as mapper
            using (var dep = new SqlTableDependency<Product>(connectionString, "Products", mapper: mapper, filter: whereCondition))
            {
                dep.OnChanged += Changed;
                dep.OnError += OnError;
                dep.Start();

                Console.WriteLine(@"TableDependency, SqlTableDependency, SqlTableDependencyFilter");
                Console.WriteLine(@"Copyright (c) 2015-2017 Christian Del Bianco.");
                Console.WriteLine(@"All rights reserved." + Environment.NewLine);
                Console.WriteLine();
                Console.WriteLine(@"Waiting for receiving notifications...");
                Console.WriteLine(@"Press a key to stop");
                Console.ReadKey();
            }