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