I'm looking for somebody who would be willing to talk to me about Entity Framework Core and F# on a .NET Data & EF Core Community Standup (https://www.youtube.com/playlist?list=PLdo4fOcmZ0oX0ObHwBrJ0vJpZ7PiYMqeA).
Recent searches
Search options
#efcore
1 post1 participant1 post today
I had a full project setup using #dotnet 9 hosted in #docker multi containers, other tech #efcore #postgresql, I wanted to see if I can set it up and continue development on my #mac. It took me roughly 15 minutes to setup everything from scratch and get to exactly where I am on my windows machine. I'm just happy to be alive in this era to be able to experience this shit.
Rebuilding everything in order to apply a migration to a database is so '90s when you already have #Ecto in mind... 
#Microsoft #EfCore
That’s a wrap on the EF Core series! The final post on Temporal Tables is live. Thanks for following along.
Starting tomorrow, it’s all about Terraform—infrastructure as code, automation, and making cloud deployments easier. Stay tuned!
Ever wish you could go back in time and see how your data looked yesterday, last week, or last year?
Temporal Tables in EF Core let you easily track changes, audit history, and recover deleted data. No more guesswork—just built-in time travel for your database.
Learn how it works: https://woodruff.dev/temporal-tables-in-ef-core-bringing-time-travel-to-your-data/
Chris Woody Woodruff · Temporal Tables in EF Core: Bringing Time Travel to Your Data - Chris Woody WoodruffWhat if you could go back in time and see exactly what your database looked like yesterday, last week, or even last year? Sounds like something out of a sci-fi movie, right? Well, Temporal Tables in SQL Server let you do exactly that!
Need to store flexible data in SQL Server without creating endless tables?
JSON in SQL Server lets you store and query structured data while keeping your schema simple. EF Core makes it easy to work with JSON directly in your queries.
https://woodruff.dev/json-columns-in-sql-server-storing-querying-json-with-ef-core/
Chris Woody Woodruff · JSON Columns in SQL Server: Storing & Querying JSON with EF Core - Chris Woody WoodruffEver wished you could store semi-structured data in your database without dealing with complex table relationships? Good news! SQL Server has native JSON support, and EF Core makes working with JSON columns easier than ever. Whether you’re handling dynamic configurations, logging data, or flexible user preferences, JSON columns let you mix structured and unstructured data in SQL Server—without creating dozens of extra tables.
Not every query needs a primary key.
Keyless Entity Types in EF Core let you query database views, raw SQL results, and reports without requiring a unique identifier. Perfect for read-only scenarios and complex data models.
https://woodruff.dev/keyless-entity-types-in-ef-core-query-data-without-primary-keys/
Chris Woody Woodruff · Keyless Entity Types in EF Core: Query Data Without Primary Keys - Chris Woody WoodruffNot everything in your database needs a primary key. Sometimes, you just want to query views, stored procedures, or raw SQL results without forcing a unique identifier on them. That’s where Keyless Entity Types in EF Core come in! If you’ve ever struggled with querying database views, reports, or read-only datasets, this feature is exactly what you need. Let’s dive into what Keyless Entity Types are, when to use them, and how to make them work in EF Core.
via @dotnet : .NET and .NET Framework February 2025 servicing releases updates
https://ift.tt/S9TPOjh
#DotNet #NetFramework #DotNetUpdates #February2025 #DotNet9 #DotNet8 #ReleaseNotes #ASPNetCore #EFCore #WindowsForms #SoftwareDevelopment #TechUpdates #Programm…
.NET Blog · .NET and .NET Framework February 2025 servicing releases updates - .NET BlogA recap of the latest servicing updates for .NET and .NET Framework for February 2025.
Tired of slow GroupBy queries in EF Core?
With LINQ GroupBy, EF Core 6+ now translates more groupings directly into SQL. No more pulling all the data into memory—just fast, efficient queries.
Learn how it works: https://woodruff.dev/grouping-smarter-linq-groupby-enhancements-in-ef-core/
Chris Woody Woodruff · Grouping Smarter: LINQ GroupBy Enhancements in EF Core - Chris Woody WoodruffGrouping data in Entity Framework Core (EF Core) used to feel a little… clunky. Sometimes, LINQ’s GroupBy() worked beautifully in-memory but got lost in translation when executing SQL queries. You’d write a simple GroupBy(), and EF Core would pull all the data into memory before doing the grouping—not good! But things are getting smarter and more efficient in recent versions of EF Core! With LINQ GroupBy enhancements, EF Core now translates more grouping operations into optimized SQL queries, saving memory and improving performance.
Using Snapshot Testing to validate EF Core schema #EFCore #dotnet https://www.meziantou.net/using-snapshot-testing-to-validate-ef-core-schema.htm?utm_medium=social&utm_source=mastodon
Meziantou's blog · Using Snapshot Testing to validate EF Core schema - Gérald BarréIn this post, I describe how to use snapshot testing to validate the schema generated by Entity Framework Core.
Did you make a mistake while saving data to your database? No need to roll back everything.
Transactional Savepoints in EF Core let you undo just the parts that went wrong while keeping the rest intact. Perfect for complex, multi-step operations.
Learn how to use them: https://woodruff.dev/transactional-savepoints-in-ef-core-rollback-just-what-you-need/
Chris Woody Woodruff · Transactional Savepoints in EF Core: Rollback Just What You Need! - Chris Woody WoodruffWe’ve all been there—you’re halfway through a multi-step transaction, and boom! 💥 Something fails. You don’t want to roll back everything, just the part that went wrong. That’s where Transactional Savepoints come in! Savepoints let you partially roll back transactions, keeping the good stuff while undoing just the problematic parts. If you've ever wished for a "Ctrl + Z" in database operations, this is it.
Database views + EF Core = clean, efficient queries. Learn how to reverse engineer views, map them in EF Core, and simplify your data access.
Check out the guide: https://woodruff.dev/tapping-into-database-views-with-ef-core-reverse-engineering-made-easy/
Chris Woody Woodruff · Tapping into Database Views with EF Core: Reverse Engineering Made Easy - Chris Woody WoodruffNot all database tables are created equal! Sometimes, you don’t need direct access to raw data—you need a refined, read-only version that makes querying easier. That’s where database views come in!
Working on GIS projects with EF Core?
Spatial Data support lets you store, query, and analyze geographic data like points, lines, and polygons with ease. Perfect for mapping, location-based apps, and more.
Learn how to get started: https://woodruff.dev/mapping-the-world-with-ef-core-working-with-spatial-data/
Chris Woody Woodruff · Mapping the World with EF Core: Working with Spatial Data - Chris Woody WoodruffHave you ever needed to store coordinates, track locations, or perform distance calculations in your database? Whether you're building a ride-sharing app, a location-based service, or an interactive map, working with spatial data is essential. Luckily, EF Core supports spatial data types, allowing you to store, query, and manipulate geographic data seamlessly. No more treating latitude and longitude as simple numbers—let’s bring real GIS (Geographic Information System) power to your EF Core apps!
Want to know what’s slowing down your EF Core queries?
Event Counters lets you track query execution times, connection usage, and more—all in real-time. Perfect for spotting performance issues before they become problems.
Learn how to use them: https://woodruff.dev/unlocking-ef-core-performance-how-to-track-queries-with-event-counters/
Chris Woody Woodruff · Unlocking EF Core Performance: How to Track Queries with Event Counters - Chris Woody WoodruffIf you've ever wondered why your EF Core queries feel sluggish or why your database is working overtime, you're not alone. Performance issues can creep in quietly, and before you know it, your app is struggling to keep up. Wouldn’t it be great if EF Core had built-in performance tracking so you could monitor database activity in real time? Good news—it does!
Ever wonder why your SQL queries are slow?
It’s time to crack the case with Query Execution Plans in SQL Server! Learn how to spot bottlenecks, optimize performance, and make your queries lightning-fast.
Dive in: https://woodruff.dev/cracking-the-code-decoding-query-plans-like-a-pro/
Chris Woody Woodruff · Cracking the Code: Decoding Query Plans Like a Pro - Chris Woody Woodrufflike at first glance—cryptic, overwhelming, and maybe a little intimidating. But don’t worry! Once you embark on the journey to analyze and understand query plans, you’ll be unlocking hidden performance treasures like a true database pirate, and you'll be amazed at how much you can grow and learn in the process.
Want to track every change in your EF Core app?
With SaveChanges Interception, you can log inserts, updates, and deletes automatically—perfect for auditing, debugging, and keeping tabs on your data!
Learn how: https://woodruff.dev/tracking-every-change-using-savechanges-interception-for-ef-core-auditing/
Chris Woody Woodruff · Tracking Every Change: Using SaveChanges Interception for EF Core Auditing - Chris Woody WoodruffEver wonder who changed what and when in your database? Or maybe you’ve had that “uh-oh” moment where data was updated, but no one knows how? Good news: EF Core has a built-in way to track changes—without modifying every query manually! SaveChanges Interception lets you hook into EF Core’s SaveChanges() pipeline and log inserts, updates, and deletes automatically.
Entity Framework Core 9 provider for Firebird is ready
www.tabsoverspaces.comEntity Framework Core 9 provider for Firebird is ready | tabs ↹ over ␣ ␣ ␣ spaces by Jiří {x2} Činčura
Many-to-Many relationships in EF Core is just easier! No more manual join tables—EF Core handles it all!
Learn how to set up, query, and navigate many-to-many relationships without causing any trouble.
Read more: https://woodruff.dev/many-to-many-made-easy-mastering-relationships-in-ef-core/
Chris Woody Woodruff · Many-to-Many Made Easy: Mastering Relationships in EF Core - Chris Woody WoodruffRemember when dealing with many-to-many relationships in Entity Framework felt like trying to assemble IKEA furniture without instructions? You needed an extra join entity and sometimes a sprinkle of luck to get it all working. EF Core has come to the rescue, making many-to-many relationships as easy as pie (or a fully assembled bookshelf) and giving you improved configurations that put you in the driver's seat.
Still saving EF Core updates one at a time? Let’s batch like a boss!
With IDbContextFactory, you can process batch updates efficiently, avoid DbContext issues, and keep your app running smoothly. No more unnecessary DB calls!
Chris Woody Woodruff · Batching Like a Boss: Using IDbContextFactory for High-Performance EF Core Updates - Chris Woody WoodruffI love receiving feedback on my blog posts! After sharing “Batching Updates and Inserts: Making EF Core Work Smarter, Not […]
Tracking down SQL queries in EF Core? Make it easier with Query Tags!
Tag your queries like sticky notes, making debugging & performance tuning a breeze. No more guessing where that query came from!
Learn how: https://woodruff.dev/query-tags-debugging-ef-core-like-a-detective/
Chris Woody Woodruff · Query Tags: Debugging EF Core Like a Detective - Chris Woody WoodruffImagine you’re a detective working on a big case. You’ve got a pile of clues (queries), but they’re all mixed together with no labels. Which one belongs to which part of the case? Frustrating, right? That’s what debugging EF Core queries feels like without Query Tags. But with Query Tags, it's like a breath of fresh air, relieving the frustration and making the process more manageable. Query Tags in EF Core are like sticky notes for your SQL. They allow you to label your queries, making it significantly easier to track down problems, optimize performance, and appear as a debugging wizard.