asp.net mvc - Best practises for a Web Api -


i have movies table basic information , reviews table revies movies.

in app want show list name , avg score of movie. best practise?

do store avg field in movies table , use api/movies?

do have api return movies including reviews reviews , calculating in app (i guess not).

or necessary calcs on server , return view model needed?

have calcs done on server/database. assuming have back-end db store sql server, write query, stored procedure, or view calc on demand. don't need calculate on client (this slow , cause need transfer data) , don't need store average anywhere.


Comments

Popular posts from this blog

python - No exponential form of the z-axis in matplotlib-3D-plots -

php - Best Light server (Linux + Web server + Database) for Raspberry Pi -

c# - "Newtonsoft.Json.JsonSerializationException unable to find constructor to use for types" error when deserializing class -