Click here to Skip to main content
15,881,938 members

Comments by Atlapure Ambrish (Top 76 by date)

Atlapure Ambrish 18-Oct-18 4:47am View    
If i have not overlooked the code, he is using dataset in db.cs - GetLocationHistory() method and ExecuteNonQuery is used for other save methods.
Atlapure Ambrish 18-Oct-18 4:26am View    
one alternate could be to loop over the datareader and covert the result to a collection of some class and then return to the controller.
Atlapure Ambrish 18-Oct-18 4:01am View    
and what about the api get method? are you seeing the data in dataset which you are returning from the method??

On another note, web api should always return a standard format data e.g. JSON, XML. so that it is not restricted to specific applications. So, I would return JSON from GetLocationHistory and GetUser methods.
Atlapure Ambrish 18-Oct-18 4:01am View    
Deleted
and what about the api get method? are you seeing the data in dataset which you are returning from the method??

On another note, web api should always return a standard format data e.g. JSON, XML. so that it is not restricted to specific applications. So, I would return JSON from GetLocationHistory and GetUser methods.
Atlapure Ambrish 18-Oct-18 3:44am View    
I would suggest you to capture the stored procedure call in 'SQL profiler' and try to run the same from SQL management studio to check if it is returning intended result.