In my current situation I am one of two developers at a manufacturer. We have been extending the functionality of existing applications (ERP and some others).
These third party applications do not allow for much modification of their database as it may/would break the application. We are strongest in T-SQL and have many stored procedures that implement the logic needed to return a db set with a minimal wrapper to the .net applications.
I have also built another code-first application using Entity Framework that lives in Azure. I'd like to take some of the practices of this and apply it to what we are doing.
Keeping in mind we have little control over the third party applications what are the recommended best practices?
Would it still be using T-SQL with a minimal wrapper to return data or can we also do that using Entity Framework for some continuity between custom apps.