Make a free query using the entity frame MVC

0

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.

    
asked by anonymous 12.07.2018 / 19:17

0 answers