I'm trying to do a simple query with LINQ, and the code below is returning me repeated records in the first 5 rows of the list.
var teste = (from p in db.VW_PAGAMENTO_RECEBIDO where p.ID_Pessoa == 23 select p).ToList();
When I run the SQL script in SQL Manager, the records are displayed correctly (as pictured below).
Note that the file code differs across all records through SqlManager. However, when I run via LINQ, the first 5 records display the replayed data, the same as the first.