Assume I have the following table called Timing: Obviously each row represents a shift in a specific day. A day can have non-overlapping multiple shifts. If a shift spans the next day it will be splitted at midnight, and the second half would have a parent id of the first half (as you can see in row 24 and 31…
Tag: ef-core-5.0
Different performance from SQL Server query from Management Studio vs EF Core 5
I wrote a simple EF Core query that makes a select on a table using some where clause to filter data: start date and finish date between the actual date and a field (DescrizioneCommessa) containing a value. To get the raw SQL I just execute the statement: And the resultant query is: I notice that it takes ver…