358 questions
-4
votes
0
answers
21
views
Advice on Efficiently Tracking Product Data Updates [closed]
I’m working on a Python-based web scraping project that involves tracking updates to product table fields such as:
{
{
price_history,
chat_count_history,
like_count_history,
...
0
votes
1
answer
49
views
Entity Framework 6 change tracker issuing statements in the wrong order
Problem description
I have a method that syncs changes to graphs of entities to the database by comparing the received entities with the corresponding database rows and then updates the ChangeTracker ...
- 2,868
0
votes
0
answers
279
views
How to reduce CPU impact of sp_cdc_scan procedure in SQL Server when CDC is enabled on multiple databases?
I have enabled CDC on a few databases in my SQL Server instance. I noticed that enabling CDC on a database creates the sp_cdc_scan request, which runs continuously and consumes CPU time. This has ...
- 517
0
votes
0
answers
118
views
EF Core Entity OwnsOne Value Object Change Tracking Problem
Edit 1: Github Issue link : https://github.com/dotnet/efcore/issues/33981
We have an entity named Customer which has a Name Property that is a value Object. I'm sharing the entity value object and ...
0
votes
1
answer
756
views
Removing (clearing) specific entries from EF Core ChangeTracker
.NET 7/ EF Core 7: we have a process that tracks changes to a db and I have no control over it. It's a black box.
What I do have control over is the methods to save these changes. In my routine I want ...
- 1,354
0
votes
1
answer
124
views
How to avoid "The instance of entity type 'xx' cannot be tracked" exception in ASP.NET Core & EF Core
I'm encountering an issue in my ASP.NET Core application with Entity Framework Core where I repeatedly get the following response:
The instance of entity type 'Airline' cannot be tracked because ...
- 1
0
votes
1
answer
92
views
Incremental copy by Change Tracking, Using Procedure and Trigger but output being lag for 1 execute time
I am trying to demo incremental copy from a table in a database A (source) to another table in another database B (destination) with using Change Tracking.
I create two tables with the same name in ...
- 1
0
votes
0
answers
160
views
Sync data from one application to another
We have an application A which has its own domain model and database (SQLSERVER). Another application B has its own domain model and database. We want to create another application C which is to ...
- 49
0
votes
1
answer
61
views
.NET Core ChangeTracker returning invalid values
I am rewriting an application that was written 12 years ago using ASP.NET v4 with SQL Server 2014, and I'm using ASP.NET Core v6 Razor with SQL Server 2019, and yes I am required to use v6 because of ...
- 31
0
votes
0
answers
596
views
EF Core change tracker stores same reference for Current and Original value of complex property
SO shows possible duplicates for my question, but I'm not quite sure my case (and actually the question itself) is the same.
I have an entity with complex property, let's say
public class Entity
{
...
- 363
2
votes
3
answers
8k
views
Entity Framework: The instance of entity type '<T>' cannot be tracked because another instance with the key value '{Id: x}' is already being tracked
I have a controller which calls the ChangeActivity method, the source and destination is gained using another dbContext than what is used here.
All code can be found here.
I also have a lot of unit ...
- 173
1
vote
1
answer
149
views
Use change tracking in StoredProcedure only if is On for table in SQL Server
I want to create an SP that will get data from ChangeTracking only if it is enabled for a given table.
In SP I have:
DECLARE @CHANGE_TRACKING_ENABLED BIT;
SELECT @CHANGE_TRACKING_ENABLED = ...
- 359
0
votes
0
answers
468
views
Word VBA TrackRevisions with comment pane
I understand there have been issues since Microsoft changed the way comments are handled (this is MS Word). I have a proofreading macro that includes the line "If ActiveDocument.TrackRevisions = ...
- 11
1
vote
1
answer
645
views
How to use CHANGE_TRACKING_CURRENT_VERSION in a user defined function?
I am working on a project that uses Entity Framework and change tracking in SQL Server. I want to create a user defined function that returns the current version of the tracked changes in the database,...
- 5,139
1
vote
1
answer
184
views
Will change tracking continue to work if a new table is renamed to original table name
I have a scenario where change tracking is enabled on a Table (say tblABC). This table has IDENTITY set on its primary key column (ID). I plan to remove the IDENTITY spec from this column. The best ...
- 107