Efcore: SQL Server 2016 Change Data Capture support
Is there any support planed for the sql server feature called "Change Data Capture".
How to collect this information with Entity Framework core to use this informations in my project.
Why: Currently i create a web application in .NET Core (Yeah! Rocks!) which is an intranet application that hold many entity informations and the costumer needs a high traceablity and data integrity for each change...
EF Core version: 1.1.0
Database Provider: Microsoft.EntityFrameworkCore.SqlServer
IDE: Visual Studio 2015
subprime
All 7 comments
I think it is not related to using EF Core, you can just enable it on your server.
ErikEJ
on 24 Jan 2017
You are right but my costumer won't look into the plain DB. For this we are planing something like a dashboard in the backend area
subprime
on 24 Jan 2017
?? Are you talking about showing the results of this? https://msdn.microsoft.com/en-us/library/bb522553.aspx
ErikEJ
on 24 Jan 2017
@ErikEJ Right.
subprime
on 24 Jan 2017
This isn't really something we would bake into EF, but you could definitely use EF to get the info from the database and then write an app to display it.
rowanmiller
on 1 Feb 2017
@rowanmiller
...but you could definitely use EF to get the info from the database and then write an app to display it
Can you in short explain how to get this information with EF. Thanks
subprime
on 2 Feb 2017
@subprime Create/map an entity to hold the data, and use EF to query for that data. (remove it manually from scaffolded migrations) - you will most likely need to call a stored proc to get the data into the entity
ErikEJ
on 2 Feb 2017
Related issues
ghost
路
3Comments
RehanSaeed
路
3Comments
MontyGvMC
路
3Comments
yukozh
路
3Comments
pachecosoftware
路
3Comments
Most helpful comment
@subprime Create/map an entity to hold the data, and use EF to query for that data. (remove it manually from scaffolded migrations) - you will most likely need to call a stored proc to get the data into the entity