Hi, Friends
In this blog we discussed about Performance analyze of
ADO.NET and Entity Framework.
Which one gives better performance? ADO.NET or Entity Framework.
These are the two method I want to analyze.
Which one gives better performance? ADO.NET or Entity Framework.
These are the two method I want to analyze.
ADO.NET Test Method
Write a simple method to test ADO.NET.It contain a simple select query it will return more than 1000 rows and we put the "Stopwatch" class it helps to calculate the execution time
Entity Framework Test Method
Write a simple method to test Entity Framework.It contain a simple ORM it will return more than 1000 rows and we put the "Stopwatch" class it helps to calculate the execution time
Result in first time execution
When i ran this above method in more than 100 times.The average execution time was show in the above image. ADO.NET was took only 2 milliseconds weather Entity Framework took more than 4 milliseconds .
Result in second time execution
When i ran this method again and again in single run. The average execution time was show in the above image. The average execution time between ADO.NET and EF is not much more
Conclusion
I think EF gives very worst performance in first time execution . To improve the EF performance read this article
Thanks
Niventh@ abi
No comments:
Post a Comment