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
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
Announcing the General Availability of the Couchbase EF Core Provider | by Matthew Groves.
buff.ly/pwBm2w9
#efcore #dotnet #couchbase #nosql #entityframework #csharp
buff.ly/pwBm2w9
Announcing the General Availability of the Couchbase EF Core Provider | by Matthew Groves.
https://www.couchbase.com/blog/ef-core-provider-for-couchbase-general-availability/
Does the #PostgreSQL team get enough props for their #EntityFramework provider documentation? No matter how much they receiver, the answer is: no.
via @dotnet : .NET and .NET Framework April 2025 servicing releases updates
https://ift.tt/WRnZhzB
#DotNet #DotNetFramework #April2025 #SecurityUpdates #CVE #ReleaseNotes #ASPNetCore #EntityFramework #SDK #Winforms #SoftwareDevelopment #Programming #DevCommunity…
Are you tired of generic exceptions in #EntityFramework? Let’s fix this! 😌
📺 OSS Power-Ups: EntityFramework.Exceptions
🗣 Speaker: Giorgi Dalakishvili
📅 Thursday, Apr 3, 3pm UTC
🤗 Open to all, welcome!
🎟 More info: https://blog.jetbrains.com/dotnet/2025/03/07/webinar-oss-power-ups-entityframework-exceptions/?utm_medium=social&utm_source=mastodon&utm_campaign=webinar-oss-power-ups-entityframework-exceptions
https://learn.microsoft.com/en-us/ef/core/dbcontext-configuration/#use-a-dbcontext-factory - want to use an #EntityFramework DBContext in a singleton? In #ASPnet's DI, rig up a factory: `services.AddDbContextFactory<ApplicationDbContext>(o => o.UseSqlServer("Server=...`
Step by step, it became harder to install an older program that I created years ago on current Windows systems.
Now, I decided to redo major parts of it, e.g., upgrade from .net framework from 4.6 to something more current, upgrade from entity framework 4 to something more current, ...
There are lots of changes to something that was running for years without problems, but the environment changed.
#programming #dotnet #entityframework
via @dotnet : .NET and .NET Framework March 2025 servicing releases updates
https://ift.tt/rLuXd7N
#DotNet #DotNetFramework #March2025 #ServicingUpdates #SecurityImprovements #CVE #ReleaseNotes #ASPNetCore #EntityFramework #SoftwareUpdates #TechNews #DeveloperCo…
Me: #EntityFramework is hreat. My one true love. A dream.
EF: Bet. So, for some reason i insist on adding the same entity twice, and tripping over that error. Also, i wont tell you what the id is. Why not try turning on explicit error messages?
Me: who. The hell. Has access to a program that can edit the database - i.e., has access to the db connection password - but is expected to not be allowed to see the database? Go ahead, turn that on...
EF: great. Here's such a glut of information that youll never find aaaanything, just a constant, unending stream of meaningless selects and updates. "Show explicit" means "log level: every single goddamn thing", right?
...this is what i get for praising something. Jinxed it.
📢 A new open-source project - EntityLengths.Analyzer!
🔍 It's a Roslyn analyzer for .NET projects that helps prevent string length issues in your code at compile time.
#dotnet #csharp #opensource #entityframework #programming #coding #development #roslyn
Finally some good news, and some hilarity
I finally convinced the client to move the app out of Umbraco CMS into a "modern age". Here is the conversation with the team:
I wrote my first blog post 🎉
Domain event dispatching using the outbox pattern with Entity Framework
https://sajilicious.micro.blog/2025/02/15/domain-event-dispatching-using-the.html
New Coding Short: "Late to the Party: PostgreSQL in .NET Core". In this Coding Short, I show how to use PostgreSQL in your .NET Projects #entityframework
#30MinsLearning Day 5: I got the identityDB context into a #sql server. It is a journey. To reach here, I ran a sql express in #container on #Ubuntu, get basics of #EntityFramework migrations, figured out the nugets to reference, and derived IdentityDbContext. 💪 #dotnet
Here's a document that helped: learn.microsoft.com/dotnet/api/s.... I didn't know that the server name was ".". And trust server certificate to true. #dotnet #sql #database #entityframeworkcore #entityframework
SqlConnection.ConnectionString...
This library is a C# source generator designed to automatically generate string length constants from Entity Framework configurations and data annotations.
Needed to do some database stuff in #DotNet today and thought I’d do it in #EntityFramework as I’ve not used it in years.
Lost interest after about 20 minutes and went back to just writing SQL. So much easier
