#databases #sqlserver #technicalDebt #entityFramework
So... At work, our product has many data grids, and uses Entity Framework, most of the grids are paged.
Paging is done via await orderedQuery. Skip((page-1)*pageSize). Take(pageSize).TolistAsync()
Page 2 loads had always been slow. EF "optimises" the generated query to use one parameter for the second page because page 2 is ... .Skip((1-1)*pageSize).Take(pageSize) ...
Both resolve to the same value. EF says "same value, same parameter!" Find whatever.
Except... SQL server builds and uses a different (and more costly) plan for the resulting OFFSET \@p ROWS LIMIT \@p that is consistently worse than it they had didn't values that produces OFFSET \@p1 ROWS LIMIT \@p2

Apparently it's been a known problem for a long time.

Until someone as dumb as me asks... Why not Skip as much as normal and Take one extra then don't use it the extra.

(await orderedQuery. Skip((page-1)*pageSize). Take(pageSize+1).TolistAsync()).Take(pageSize)

/1

From the archives...

KCDC 2024 Slidedeck
https://barretblake.dev/posts/conferences/2024/kcdc-2024-slidedeck/ #efcore #entityframework #slides

Blogged: Entity Framework Core 10 provider for Firebird is ready

https://www.tabsoverspaces.com/id/233960

#efcore #ef #entityframework #entityframeworkcore #firebird

Coming up next month (February 9-11th), I'm holding my "ASP․NETCore 10 and Vue.js From Scratch" course in The Hague, NL. Limited seating for this three day class on #aspnetcore, #entityframework, and #vuejs. Check it out here:

https://wildermuth.com/en/training/inperson/aspnetcore-vue/

Viết script chuyển đổi Prisma schema thành model C# Entity Framework, hỗ trợ MySQL/MariaDB. Công cụ mã nguồn mở giúp tiết kiệm thời gian đồng bộ DB giữa web app và backend C#. Tải về tại GitHub: devs.io/prisma-to-csharp.
#PrismaToCSharp #EntityFramework #CSharp #MySQL #XâyDựngPhầnMền #MãNguồnMở

https://www.reddit.com/r/SideProject/comments/1pp6035/convert_prisma_schema_file_to_c_entity_framework/

Зачем вообще использовать ORM?

Разработка софта всегда была поиском баланса между разными аспектами, вроде скорости разработки (как быстро ты выкатываешь новые фичи), производительности приложения, потребления им памяти, красотой интерфейса и отполированностью логики. В большинстве случаев скорость разработки важнее, чем производительность и потребление памяти. ORM - это как раз инструмент, экономящий время разработки. Но за счёт чего?

https://habr.com/ru/articles/973608/

#orm #entityframework

https://www.sea-ql.org/SeaORM/docs/generate-entity/entity-first/

>This is where SeaORM shines: it automatically builds a dependency graph from your entities and determines the correct topological order to create the tables, so you don't have to keep track of them in your head.

Awesome. It sounds like #SeaORM might be Rust's equivalent of #EntityFramework from the #dotnet world. I'm fiddling with a local application that stores data in a #sqlite database, and have been looking at various crates that could handle schema and entity management. While SeaORM bills itself as being meant for web applications, I'm not seeing anything that would preclude using it in local apps.

#rustlang

EFCore.Visualizer – View Entity Framework Core query plan inside Visual Studio.

https://devblogs.microsoft.com/dotnet/ef-core-visualizer-view-entity-framework-core-query-plan-inside-visual-studio/?hide_banner=true

#dotnet #efcore #visualstudio #entityframework #orm #csharp

UK #dotnet #csharp #sqlserver lead/senior developer with over 15 years’ experience looking for new permanent role if possible. Would consider temporary contract.

#AspDotNet #mvc #blazor #entityframework #azure #tdd #agile #Git

Looking for hybrid role in London, Cambridge, Essex, or Hertfordshire. Also interested in fully-remote UK or European roles.

#FediHire #getfedihired