I would like to bring a result of a days calculation using mvc with frame entity .
My query would be this:
select
Notas_IdSoft, Notas_TipoLic, t.Notas_Validade,
DATEDIFF(DAY, GETDATE(), t.Notas_Validade ) as Data
from Notas as t
where
DATEDIFF(DAY, GETDATE(), t.Notas_Validade ) >10
I would like to apply it to my page, but I do not know how to do it.