My company wants to have the logic as much as possible in the stored procedure and do not want me to involve in creating them. The tables are already existing and have a system analyst to worry about the creation of the additonal tables and stored procedures.
1. In this case, can i use entity framework for my asp.net application?
2. Also does it make the application work/respond really slow if i use stored procedures all the time without entity framework?
3. Can i use stored procedures along with entity framework?, but i guess the point of having all the logic in the stored procedure will be neglected?
4. Just incase if i can't use the entity framework, what is the best secure architecture to use so that i don't have to open database connection very often, like how entity framework manages and can i use Linq without entity framework?
5. What is Data Access Blocks used for, can i use it with odp.net?