EF Core is a great tool to quickly build and test applications using database backends, however it does some issues related to performance. Particularly the queries were very very slow in one of the applications which has the SQL server database hosted in Azure SQL Database.
Thus finally we resorted to using two different data access technologies in the same application:
1) Dapper was used to query the database in read-only mode
2) EF Core was used for most (but not all) DML operations
This approach ensured that the data access layer has required flexibility without sacrificing speed of development.
A very good guide to using different data access technologies in the same application can be found at https://www.c-sharpcorner.com/article/combine-ado-net-ef-core-and-dapper-in-same-blazor-app/
Thus finally we resorted to using two different data access technologies in the same application:
1) Dapper was used to query the database in read-only mode
2) EF Core was used for most (but not all) DML operations
This approach ensured that the data access layer has required flexibility without sacrificing speed of development.
A very good guide to using different data access technologies in the same application can be found at https://www.c-sharpcorner.com/article/combine-ado-net-ef-core-and-dapper-in-same-blazor-app/
No comments:
Post a Comment