Click here to Skip to main content
15,891,713 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
i'm tryin to create an asp.net c# website with 3 tier architecture
my question is: What are the benefits of using Entity Framework and is it necessar
or should i keep using the classic ado.net??
Posted

You must check and read this link.
Security Considerations (Entity Framework)[^]
 
Share this answer
 
Comments
thatraja 1-Apr-14 8:55am    
5! Hey you!
Yes, this is secure. As its advance way of interacting with database it will be better to use this.
Here are some benefits of EF:
Provides dedicated functionality for CRUD operation (Create, Read, Update, Delete). Easy to implement CRUD operations.

>> If you want to replace the data store, it is very easy to replace without modifying the data access logic since all data access logic are present in higher level.

>> Easy to manage one to one, one to many and many to many relationship between tables.

>> Conceptual model can be represented in a better way.

>> Developer can reduce the code in classes and sub-classes for data access.
 
Share this answer
 
It is not a necessary to use entity framework, you can keep using the classic ado.net. Entity framework is not a replacement of ado.net, entity framework also uses the ado.net behind the scenes.

The main advantages are
1. It is easy to manage the code, especially when you are working on enterprise applications.

2. You will have to write less code for regular database operations. Instead entity framework will do most of this stuff and you can concentrate on your main application logic.

Note that you will not get any performance benefits by using entity framework. It also uses ado.net as its base layer. So calling stored procedures etc. using classic adp.net techniques will be faster as compared to having an extra entity framework layer inbetween.
 
Share this answer
 
 
Share this answer
 

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900