Using Oracle stored procedure throughout the asp.net application.

Question

0.00/5 (No votes)

See more:

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

Member 9542426

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Sampath Kumar Sathiya · Accepted Answer · 2012-12-18T16:34:00

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.