Question
I have
dbContext.Items.FromSql("SELECT COUNT(*)
FROM Items
WHERE JSON_VALUE(Column, '$.json') = 'abc'")
This returns an IQueryable, I am wondering how I can return a scalar int back?
Popular Answer
Try
var firstElement = dbContext.Items
.FromSql (..)
.ToList
.First();
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow