None of these queries return anything with EF but using this not commented query in - for example - phpmyadmin it returns elements that I want.
|
var scores = await dbContext.Scores |
|
.FromSqlRaw($"SELECT * FROM Scores WHERE PlayerId IN ({string.Join(", ", playerIds)}) AND PlayTime > TIMESTAMP(\"{date:yyyy-MM-dd}\", \"{date:HH:mm:ss}\")") |
|
.ToListAsync(); |
|
/*var scores = await dbContext.Scores |
|
.Where(s => playerIds.Contains(s.PlayerId) && s.PlayTime > date) |
|
.ToListAsync();*/ |
None of these queries return anything with EF but using this not commented query in - for example - phpmyadmin it returns elements that I want.
BanchoNET/Services/Repositories/Scores.cs
Lines 71 to 76 in 8e8c4a3