a WPF application that will deploy to ~50 users
Each user will probably make about 25 read/writes a day.
I have everything working in Azure but my issue/fear/question is I'm directly calling stored procedures in the Azure SQL db for all CRUD/Loading operations... is this wise/correct?
There are two main issues here: security and maintenance.
From the question and comments, it seems that the database is stored on Azure, with multiple clients accessing the database over the internet.
With this in mind, I would recommend making use of some sort of public-facing interface between your client application and database and making sure the database itself is not publically accessible (no public-facing ...