Entity Framework 6 - Knowledge Base (KB)

SqlDependency with EntityFramework 6 (async)

I'm using the EF 6 ...async... querying features, such as...var list = await cx.Clients.Where(c => c.FirstName.Length > 0).ToListAsync(); ...I want to also start SQL dependencies on these queries so that I can get notified when the data in the database ch...

Can calling ToList on a DbSet cause caching?

I was using the following code to repopulate an ...ObservableCollection<T>... on change notification from a ...SqlDependency...:...var set = _dbContext.Set<T>().ToList(); this.AddRange(set); ...In this scenario, the ...OnChange... event fires correctly, b...

SqlDependency not working

I'm using EF 6 with SQL Server 2012....I'm trying to use ...SqlDependency... to refresh my cached data, in a class library (DLL)....I have the following, based on whatever guides I found, but seems like it is not working, and I get no error....enabled bro...