public virtual async Task AlteringDocumentShouldUpdateReducedIndex() in CoreTest.cs

[xeron333]

I'm studying your YesSQL project and I'd like to report a problem in the test YesSQL.Tests :
public virtual async Task AlteringDocumentShouldUpdateReducedIndex()
The deletion function:

session.Delete(article); (line 2864)

doesn't work with both SQLite and SQL Server in LocalDB. With SQL Server, I get the following message:
Microsoft.Data.SqlClient.SqlException: The DELETE statement conflicted with the REFERENCE constraint "tpFK_ArticlesByDay_Document_DocumentId". The conflict occurred in database "TestDb_Temp", table "TestDb_Temp.tpArticlesByDay_Document", column 'DocumentId'. The statement has been terminated.`
I tried modifying the constraint to "On Cascade" using a Temp database, but it's impossible; your model resets everything when the test starts. Do you have any ideas on how to make this test work?
Please keep me informed
Greetings

[xeron333]

Hello, after quite a bit of research, I managed to find the solution to the problem. The test fails because of the date format:

new DateTime(2011, 11, 1),
new DateTime(2011, 11, 2),
new DateTime(2011, 11, 2),

Indeed, if we leave it as is and the time zone is UTC+1, for example, we get:

2011-11-01 00:00:00 (local)
→ 2011-10-31 23:00:00 UTC

The test needs to be modified like this, for example (by changing the UTC):

var articles = new[]

{ new Article { Title = "Title1", PublishedUtc = new DateTime(2011, 11, 1, 0, 0, 0, DateTimeKind.Utc)},

new Article { Title = "Title2", PublishedUtc = new DateTime(2011, 11, 1, 0, 0, 0, DateTimeKind.Utc)} DateTime(2011, 11, 2,0,0,0, DateTimeKind.Utc)},
new Article { Title = "Titre3", PublishedUtc = new DateTime(2011, 11, 2,0,0,0, DateTimeKind.Utc)},

I hope this answer will help some people