{"action":"created","issue":{"url":"https://api.github.com/repos/aspnet/EntityFramework/issues/4693","repository_url":"https://api.github.com/repos/aspnet/EntityFramework","labels_url":"https://api.github.com/repos/aspnet/EntityFramework/issues/4693/labels{/name}","comments_url":"https://api.github.com/repos/aspnet/EntityFramework/issues/4693/comments","events_url":"https://api.github.com/repos/aspnet/EntityFramework/issues/4693/events","html_url":"https://github.com/aspnet/EntityFramework/issues/4693","id":138080370,"number":4693,"title":"Temporal Tables","user":{"login":"shivajiraot","id":11180445,"avatar_url":"https://avatars.githubusercontent.com/u/11180445?v=3","gravatar_id":"","url":"https://api.github.com/users/shivajiraot","html_url":"https://github.com/shivajiraot","followers_url":"https://api.github.com/users/shivajiraot/followers","following_url":"https://api.github.com/users/shivajiraot/following{/other_user}","gists_url":"https://api.github.com/users/shivajiraot/gists{/gist_id}","starred_url":"https://api.github.com/users/shivajiraot/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/shivajiraot/subscriptions","organizations_url":"https://api.github.com/users/shivajiraot/orgs","repos_url":"https://api.github.com/users/shivajiraot/repos","events_url":"https://api.github.com/users/shivajiraot/events{/privacy}","received_events_url":"https://api.github.com/users/shivajiraot/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2016-03-03T05:30:12Z","updated_at":"2016-03-04T21:13:10Z","closed_at":null,"body":"Does EF7 support code first approach for Temporal tables?\r\nLooking to find a way to use Temporal tables with EF7 code first approach. Please guide me to the article if any existing already.\r\nThank you."},"comment":{"url":"https://api.github.com/repos/aspnet/EntityFramework/issues/comments/192468098","html_url":"https://github.com/aspnet/EntityFramework/issues/4693#issuecomment-192468098","issue_url":"https://api.github.com/repos/aspnet/EntityFramework/issues/4693","id":192468098,"user":{"login":"rowanmiller","id":4741851,"avatar_url":"https://avatars.githubusercontent.com/u/4741851?v=3","gravatar_id":"","url":"https://api.github.com/users/rowanmiller","html_url":"https://github.com/rowanmiller","followers_url":"https://api.github.com/users/rowanmiller/followers","following_url":"https://api.github.com/users/rowanmiller/following{/other_user}","gists_url":"https://api.github.com/users/rowanmiller/gists{/gist_id}","starred_url":"https://api.github.com/users/rowanmiller/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rowanmiller/subscriptions","organizations_url":"https://api.github.com/users/rowanmiller/orgs","repos_url":"https://api.github.com/users/rowanmiller/repos","events_url":"https://api.github.com/users/rowanmiller/events{/privacy}","received_events_url":"https://api.github.com/users/rowanmiller/received_events","type":"User","site_admin":false},"created_at":"2016-03-04T21:13:10Z","updated_at":"2016-03-04T21:13:10Z","body":"For the most part, the fact that a table is temporal is opaque to the data layer - so from that point of view you should be fine to connect to an existing database with temporal tables.\r\n\r\nHere are some limitations though, that we could address in EF:\r\n * If you wanted to query a past state of the table you would need to use a raw SQL query.\r\n * There is no way to make a table temporal in the model/migrations. So if you are using EF to create the database then you would need to hand edit the migration and use `Sql(string)` to make the table temporal."}}