reEntity Framework Core performance tuning–Part III

time to read 1 min | 166 words

I mentioned in the previous post that I’ll take the opportunity to show of some interesting queries. The application itself is here, and you can see how to UI look in the following screenshot:

image

I decided to see what would be the best way to come up with the information we need for this kind of query. Here is what I got.

image

This is using a select object style to get a complex projection back from the server. Here are the results:

image

As you can see, we are able to get all the data we want, in a format that is well suited to just sending directly to the UI with very little work and with tremendous speed.

More posts in "re" series:

  1. (05 Dec 2025) Build AI that understands your business
  2. (02 Dec 2025) From CRUD TO AI – building an intelligent Telegram bot in < 200 lines of code with RavenDB
  3. (29 Sep 2025) How To Run AI Agents Natively In Your Database
  4. (22 Sep 2025) How To Create Powerful and Secure AI Agents with RavenDB
  5. (29 May 2025) RavenDB's Upcoming Optimizations Deep Dive
  6. (30 Apr 2025) Practical AI Integration with RavenDB
  7. (19 Jun 2024) Building a Database Engine in C# & .NET
  8. (05 Mar 2024) Technology & Friends - Oren Eini on the Corax Search Engine
  9. (15 Jan 2024) S06E09 - From Code Generation to Revolutionary RavenDB
  10. (02 Jan 2024) .NET Rocks Data Sharding with Oren Eini
  11. (01 Jan 2024) .NET Core podcast on RavenDB, performance and .NET
  12. (28 Aug 2023) RavenDB and High Performance with Oren Eini
  13. (17 Feb 2023) RavenDB Usage Patterns
  14. (12 Dec 2022) Software architecture with Oren Eini
  15. (17 Nov 2022) RavenDB in a Distributed Cloud Environment
  16. (25 Jul 2022) Build your own database at Cloud Lunch & Learn
  17. (15 Jul 2022) Non relational data modeling & Database engine internals
  18. (11 Apr 2022) Clean Architecture with RavenDB
  19. (14 Mar 2022) Database Security in a Hostile World
  20. (02 Mar 2022) RavenDB–a really boring database