Are Query Notifications on the roadmap?

[rposener]

It seems the System.Data.SqlClient does not include any of the query notification (SqlNotification or SqlDependency) classes. is this on the roadmap to be added?

[ViktorHofer]

@saurabh500 @YoungGah @karelz It seems we still haven't ported them to corefx. Any reason why? I see them supported in Xamarin and Desktop: https://apisof.net/catalog/System.Data.SqlClient.SqlDependency

[karelz]

@corivera any insight here?
@stephentoub @weshaggard @danmosemsft?

[akoeplinger]

@ViktorHofer FYI it's just a stub in Mono/Xamarin at the moment: SqlDependency.cs

[ViktorHofer]

@karelz Moving this to future as we reached feature freeze...

[karelz]

I'd like area experts & owners to make the decision. While we are past feature complete, there are options like DCRs, etc. I would prefer to focus on doing the right thing for the customers rather than process.

That said, given they are stubbed out in Xamarin, it feels more like Future to me as well, but I don't have enough background in the space to make the call ...

[corivera]

We currently don't have any plans for working on query notifications.

[grahamehorner]

Is there any mileage in possibility providing a work around until officially supported, this is a blocker for us moving to asp.net core as we aren't able to invalidate cached items as notifications was used as the trigger this

[saurabh500]

Query notifications via SqlDependency and related APIs is a feature we have on the backlog. However we couldn't get it into 2.0 because we didn't have the bandwidth.
We will be looking to port this feature in Future iterations.

[saurabh500]

Related issue https://github.com/dotnet/corefx/issues/17833

[maike9]

This is a roadblock to moving to .net core for me too.

[saurabh500]

@maike9 What is your scenario for query notification?

[corivera]

Query notification support was added in dotnet/corefx#20708

[ViktorHofer]

... and will be available with the .NET Core 2.1 and the next version of UWP. Right @corivera ?

[corivera]

Yep

[ChristopherRobinSuperStar]

@corivera Is it possible to use it with action attribute in asp net core 2.1?
Before in asp net mvc it was:

[OutputCache(Duration = Int32.MaxValue, SqlDependency = "DBNAME:DEPENDENCY_TABLE_NAME", Location = System.Web.UI.OutputCacheLocation.Server)]
public ActionResult Index()
{
}

[karelz]

cc @keeratsingh @David-Engel @afsanehr