4
I recently asked for help to assemble a SELECT to bring the price of products
They gave me this solution that worked perfectly:
SELECT P.PROCODIGO, P.PRONOME, H.HISPRECO
FROM PRODUTO P
INNER JOIN HISTORICO H ON P.PROCODIGO = H.PROCODIGO
WHERE H.HISDATA = (SELECT MAX(HISDATA) FROM HISTORICO WHERE PROCODIGO = P.PROCODIGO)
But now I need to mount that same SELECT in lambda with C#, because I started using Entity. Can someone help me?
Thank you!
you’re using context?
– Marco Souza
Use, but also use working unit and repositories.
– André Morais Martins