Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: ASP.NETODP.NET
Hi,
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?
Posted 17-Dec-12 10:05am

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

Hi,
 
1. In this case, can i use entity framework for my asp.net application?
 
Yes, you can use entity frame work.
 
2. Also does it make the application work/respond really slow if i use stored procedures all the time without entity framework?
 
No, not really. But If you use via entity framework it will be faster.
 
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?
 
Yes, you can use via entity framework. But if you are use optimistic locking you need to write extra code for that.
 
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?
 
No, Use Linq along with entity framework it will be faster.
 
5. What is Data Access Blocks used for, can i use it with odp.net?
 
Yes, Use odp.net as your data block.
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 Sergey Alexandrovich Kryukov 686
1 OriginalGriff 498
2 Tadit Dash 420
3 sanket saxena 337
4 Zoltán Zörgő 230
0 Sergey Alexandrovich Kryukov 11,800
1 OriginalGriff 7,225
2 Peter Leow 5,009
3 Abhinav S 3,893
4 Maciej Los 3,575


Advertise | Privacy | Mobile
Web04 | 2.8.140421.2 | Last Updated 18 Dec 2012
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Use
Layout: fixed | fluid