Temporal Table Support (new in SQL Server 2016)

[wangkanai]

Do you have any plan to integrate Temporal table to align the feature from Sql 2016?

[rowanmiller]

Triage For the most part basic query etc. should just work. We do want to look at ability to query particular points in time etc., but we will look at this once we ship the initial RTM.

[adamjstone]

I'm glad to see that this is in queue. This is an important feature for large enterprises. We want to ease the pain of delivering reports for sox audits. This is a painful bureaucratic hoop that every publicly traded enterprise in the United States has to jump through. Over and over.

[pkothare]

+1 on SOX compliance. I'd like to contribute to this. There is a huge community of enterprise developers that will see value in this feature.

[rohits-dev]

Now when SQL 2016 is released, is there any update on this issue?

[rowanmiller]

This is on our backlog to look at, but there are higher priority features that we will be tackling first. You can absolutely use temporal tables with EF Core, there just isn't a first class way to reason about points in time. To do this, you would use a raw SQL query https://docs.efproject.net/en/latest/querying/raw-sql.html.

[qanuj]

+1 on SOX compliance

[smoelker]

+1 Temporal support would be incredibly useful!

[amirazizian]

+1

[GalayM]

+1

[lovezhuliang]

+1

[johnavery]

+1 for creating Temporal Tables from Fluent API and also issuing temporal queries!

[cSteusloff]

+1

[SamNasr]

Rowan, any updates on using EF Code First to build/maintain Temporal Tables? Where can we monitor this issue?

[rowanmiller]

@SamNasr this is the right place to monitor the issue. No updates as yet, this isn't planned for our next release (2.0)

[jessanmen1]

Any news on this?

[ajcvickers]

We seem to have two issues tracking this. Closing this one in favor of #4693, since that issue contains a bit more information.

[rezdm]

One more vote for this one.

[angularDevd]

and another one +1

[hadi-jabbari]

+1

[toper]

+1

[pfaisant]

+1. any update ?

[AliaksandrBortnik]

+1. any update ?

This ticket is closed. Go to the following ticket: #4693