search

rahulsahay19 / AMA

Ask Me Anything
0 stars 1 forks source link

Entity framework #6

Closed mitpancha closed 7 years ago

mitpancha commented 7 years ago

Hello Rahul,

Could you just tell , how much EF is important to use in .net core, does it affects processing speeds when we use large size of database.

Little bit advantage and disadvantages of EF

Thanks, Mitesh

rahulsahay19 commented 7 years ago

Hi,

Frankly speaking its a myth that using dbContext impacts DB performance. If its designed keeping all design and modeling constraints in mind then there is no impication. On top of that there has been many performance improvements done in EF. Every new release you can expect more robust features getting added to EF. Currently, EF is one of the fastest and best ORM model in place. On top of that, if you need to build scalable DB, I would suggest keep multiple DBContext like schema-wise. This way segregation, Isolation, maintainability, performance, scalability ......everything can be maintained.

Thanks, Rahul