#entityframework — Public Fediverse posts on home.social

#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

#sqlserver #databases #technicaldebt #entityframework

Barret @[email protected] · 2026-03-22 · 19:00 UTC

From the archives...

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

#efcore #entityframework #slides

robrich @[email protected] · 2026-02-26 · 16:01 UTC

https://antondevtips.com/blog/how-to-increase-ef-core-performance-for-read-queries-in-dotnet?utm_source=linkedin&utm_medium=social&utm_campaign=13-01-2026 - Speed up #EntityFramework Core in #dotNET. Nice post Anton Martyniuk.

#entityframework #dotnet

Jiří Činčura ↹ @[email protected] · 2026-02-08 · 19:10 UTC

Blogged: Entity Framework Core 10 provider for Firebird is ready

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

#efcore #ef #entityframework #entityframeworkcore #firebird

#firebird #entityframeworkcore #entityframework #ef #efcore

Jiří Činčura ↹ @[email protected] · 2026-02-08 · 19:10 UTC

Blogged: Entity Framework Core 10 provider for Firebird is ready

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

#efcore #ef #entityframework #entityframeworkcore #firebird

#firebird #entityframeworkcore #entityframework #ef #efcore

Jiří Činčura ↹ @[email protected] · 2026-02-08 · 19:10 UTC

Blogged: Entity Framework Core 10 provider for Firebird is ready

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

#efcore #ef #entityframework #entityframeworkcore #firebird

#firebird #entityframeworkcore #entityframework #ef #efcore

Jiří Činčura ↹ @cincura_net · 2026-02-08 · 19:10 UTC

Blogged: Entity Framework Core 10 provider for Firebird is ready

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

#efcore #ef #entityframework #entityframeworkcore #firebird

#firebird #entityframeworkcore #entityframework #ef #efcore

Jiří Činčura ↹ @[email protected] · 2026-02-08 · 19:10 UTC

Blogged: Entity Framework Core 10 provider for Firebird is ready

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

#efcore #ef #entityframework #entityframeworkcore #firebird

#firebird #entityframeworkcore #entityframework #ef #efcore

Shawn Wildermuth (🇺🇦++) @shawnwildermuth · 2026-01-06 · 17:28 UTC

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/

#aspnetcore #entityframework #vuejs

Habr @[email protected] · 2025-12-05 · 10:12 UTC

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

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

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

#orm #entityframework

Preston Maness ☭ @[email protected] · 2025-11-04 · 19:50 UTC

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

#seaorm #entityframework #dotnet #sqlite #rustlang

Preston Maness ☭ @[email protected] · 2025-11-04 · 19:50 UTC

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

#seaorm #entityframework #dotnet #sqlite #rustlang

Preston Maness ☭ @[email protected] · 2025-11-04 · 19:50 UTC

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

#seaorm #entityframework #dotnet #sqlite #rustlang

Preston Maness ☭ @[email protected] · 2025-11-04 · 19:50 UTC

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

#rustlang #sqlite #dotnet #entityframework #seaorm

Preston Maness ☭ @[email protected] · 2025-11-04 · 19:50 UTC

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

#seaorm #entityframework #dotnet #sqlite #rustlang

Alvin Ashcraft 🐿️ @[email protected] · 2025-08-28 · 19:00 UTC

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

AliveDevil @[email protected] · 2025-07-24 · 22:32 UTC

#AspNetCore, for an #Sqlite database.

- Vacuum on startup/shutdown,
- offline by user running vacuum command through Sqlite CLI,
- or on regular intervals during runtime?

#DotNet #CSharp #EFCore #EntityFramework

#aspnetcore #sqlite #dotnet #csharp #efcore #entityframework

Habr @[email protected] · 2025-05-30 · 17:42 UTC

T-SQL в .NET Core EF Core: Гибридный подход к производительности и гибкости (Переосмысление с учетом обсуждения)

Секретное оружие в .NET Core: Почему вы игнорируете мощь T-SQL? Ваши LINQ-запросы становятся громоздкими? Производительность упирается в потолок? Возможно, вы упускаете нечто важное. Эта статья — приглашение взглянуть на привычные инструменты под новым углом. Мы исследуем гибридный подход, который позволяет использовать весь потенциал Microsoft SQL Server, выходя за рамки стандартного взаимодействия через EF Core. Узнайте, как T-SQL может упростить сложные задачи, повысить производительность и сделать вашу архитектуру более гибкой. Это не просто технический трюк, а переосмысление роли СУБД в современном приложении. Готовы узнать, как использовать "скрытые" возможности MSSQL и почему это может быть именно то, что нужно вашему проекту? Читать об этом

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

#net #net_core #ef #entityframework #linq #tsql #sql #mssql #mssqlserver #database_development

#database_development #mssqlserver #mssql #sql #tsql #linq

nickproud @[email protected] · 2025-05-28 · 09:00 UTC

So many SaaS applications are simply single-page applications wrapping a database. So why not learn the #dotnet SPA framework, #blazor and the popular #EntityFramework?

https://zurl.co/vM0Tn

#dotnet #blazor #entityframework

nickproud @[email protected] · 2025-05-22 · 20:31 UTC

Curious about when to choose between Dapper and Entity Framework for your .NET project? 🤔

If you need high-performance, lightweight data access, go with Dapper! 💪 For more complex data models and relationships go for Entity Framework.
#Dapper #EntityFramework #dotnet

#dapper #entityframework #dotnet

nickproud @[email protected] · 2025-05-16 · 12:25 UTC

One thing is for sure, version controlling a #SQL database is not easy.
There's a bit more ceremony involved, but it looks like #microsoft does have a recommendation. Check it out.

https://www.youtube.com/watch?v=xzqpf0Nq06o
#sql #git #dotnet #entityframework

#sql #microsoft #git #dotnet #entityframework

Habr @[email protected] · 2025-05-02 · 18:42 UTC

T-SQL в .NET Core EF Core: Гибридный подход к производительности и гибкости

В мире .NET разработки, работа с базами данных – неотъемлемая часть. Entity Framework Core (EF Core) предоставляет удобный способ взаимодействия с данными, но при работе с SQL Server, особенно в сложных сценариях, LINQ запросы могут уступать в производительности и гибкости T-SQL. Статья рассматривает эту дилемму, предлагая гибридный подход. Мы погрузимся в проблему: как эффективно использовать мощь T-SQL, не отказываясь от преимуществ EF Core? Обсудим интеграцию T-SQL через Raw SQL, Views, UDF и Stored Procedures. Раскроем лучшие практики: разделение ответственности, оптимизацию запросов, безопасность и тестирование. Поймем, как сочетать удобство ORM с производительностью SQL Server, применяя Data-Driven Design и, при необходимости, Domain-Driven Design. Статья – руководство для .NET разработчиков, стремящихся к оптимальному балансу между производительностью, гибкостью и удобством разработки при работе с SQL Server и EF Core. Читать об этом

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

#net #net_core #ef #entityframework #linq #tsql #sql #mssql #mssqlserver #database_development