EntityFrameworkCore.TemporalTables icon indicating copy to clipboard operation
EntityFrameworkCore.TemporalTables copied to clipboard

Execute Temportal Queries

Open vertonghenb opened this issue 6 years ago • 5 comments

I couldn't find any docs on how to fire some temportal queries using linq are there any samples or is this not supported?

vertonghenb avatar Oct 20 '19 00:10 vertonghenb

Hi, at this point this is not supported but I've definitely planned it for future releases. The main goal is to support temporal tables creation/deletion (current functionality) and ability to query temporal data.

findulov avatar Oct 28 '19 17:10 findulov

Might not be as complete as what you would like but I just created a PR to query the temporal tables to get entities at specified dates. https://github.com/findulov/EntityFrameworkCore.TemporalTables/pull/10

lpperras avatar Dec 20 '19 16:12 lpperras

Thanks for the AsOf implementation. When I use Include the related data is not loaded as of the specified date. Only the main entity Any generic method to get that at the moment?

KarlJorgen avatar Feb 18 '20 09:02 KarlJorgen

No, sorry to inform you that at this point it's not possible to fetch related data but I keep thinking of an appropriate way to implement that behavior.

findulov avatar Feb 18 '20 09:02 findulov

Any progress on related tables? What is the current functionality? .AsOf() only works if there is a single table in the query?

MikeOtown avatar Oct 20 '21 12:10 MikeOtown