To do app made with ASP.NET MVC5 ,C# and SQLServer 2017, I use stored procedures and a class to connect with the database