WCF data service in wcf class library from client

Question

I created the WCF Dataservice service and tested using Postman (Chrome extension), which work fine. Then I added a service link that points to WCF Dataservice in my C # client library.

When I call a DbSet transaction in my DataService, I get the number of transactions correctly, however, all the items in the list were overwritten by the last item in the list. If I have 10 transactions in the database, I get 10 in my list, but the data in all the elements is the same, which is the last element in the database.

I use simple LINQ to retrieve data as shown below

List<Transaction>() tempList = new List<Transaction>(); tempList = GetContext().Transactions.ToList(); 

The strange part is when I catch a query that works in the database using Fiddler, the output from the database is beautiful, which means that something happens in my client and redefines all the items in the list with the last item. Can someone tell me how to debug this or how can I catch who overrides my list.

Answer 1

Suppose that the table does not have a UNIQUE key, so from the client, when deserializing it, add the last element found to the list