I'm starting to develop an application, basically it's a business management control. The application will issue NFC-e, NFe, will control inventory, financial and etc., the database will be hosted on Azure. I started by modeling the database and creating stored procedures to keep the data in the database, but I noticed that I have to create a huge amount of stored procedures due to the fact that the database contains many objects. I am careful not to insert anything from the business layer into stored procedures.
As I have a little experience, I'm confused because some say that stored procedure is a bad practice and should only be used on issues where performance is required, eg here . Others say it's worth using, example here .
In the opinion of the most experienced, what is the best way, to use an ORM or to create all the stored procedures that it is necessary? Is it a problem for a database to have a large number of stored procedures? In this answer you have one that claims to have 200 or more in a commercial system .