Runtime: Are Query Notifications on the roadmap?

Created on 30 Apr 2016 · 16Comments · Source: dotnet/runtime

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?

area-System.Data.SqlClient tenet-compatibility

Source

rposener

👍1

All 16 comments

@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

ViktorHofer on 14 Apr 2017

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

karelz on 14 Apr 2017

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

akoeplinger on 14 Apr 2017

👍1

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

ViktorHofer on 15 Apr 2017

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 ...

karelz on 16 Apr 2017

👍1

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

corivera on 17 Apr 2017

👎2

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

grahamehorner on 2 May 2017

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 on 2 May 2017

saurabh500 on 31 May 2017

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

maike9 on 11 Jun 2017

@maike9 What is your scenario for query notification?

saurabh500 on 12 Jun 2017

Query notification support was added in https://github.com/dotnet/corefx/pull/20708

corivera on 20 Jul 2017

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

ViktorHofer on 20 Jul 2017

Yep

corivera on 20 Jul 2017

@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()
{
}