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?
Try
var firstElement = dbContext.Items
.FromSql (..)
.ToList
.First();