Edit

Share via

.NET Data Community Standups

The .NET Data Community Standups are live-streamed monthly (roughly) on Wednesday (usually) to YouTube and Twitch. This is your opportunity to interact with the .NET Data team and community. All past episodes are available on YouTube and are listed below with links to content from the shows.

Comment on GitHub with ideas for guests, demos, or anything else you want to see.

Summary

Date Area Title
Jun 19, 2025 Vector databases Microsoft.Extensions.VectorData - Access Vector databases in AI apps
May 14, 2025 Azure SQL Azure SQL vector search with Davide Mauri
Apr 24, 2025 EF Core Jiri and Shay talk about EF Core testing and Maurycy corrects them
Mar 19, 2025 EF Core Stop using Entity Framework as a DTO provider!
Mar 6, 2025 Chroma Using Chroma vector database from .NET
Jan 22, 2025 Tips Context pooling, FromSql and compiled queries
Nov 20, 2024 Release EF Core 9: Release extravaganza
Jun 26, 2024 SQL schemas Improve your SQL schema and scripts with .NET based static code analysis
May 15, 2024 Firebird Harnessing the Power of Firebird in .NET
Apr 17, 2024 EF Core mapping All about EF Core property mapping
Mar 20, 2024 GraphQL Distributed Applications with Hot Chocolate 14, Aspire, and EF Core
Mar 6, 2024 Value generation EF Core keys and value generation
Feb 21, 2024 SQL translation Window and binary functions using Zomp EF Core extensions
Feb 7, 2024 Database concurrency Database concurrency and EF Core: Beyond optimistic concurrency
Jan 24, 2024 Database concurrency Database concurrency and EF Core: ASP.NET and Blazor
Jan 10, 2024 Database concurrency Database concurrency and EF Core
Nov 29, 2023 New features A tour of what's new in EF8
Oct 18, 2023 Document databases Introducing the MongoDB provider for EF Core
Oct 4, 2023 New features Size doesn't matter: Smaller features in EF8
Sep 20, 2023 Complex types/DDD Complex types as value objects in EF8
Jun 14, 2023 SQLite Synchronizing data between the cloud and the client (using SQLite)
May 31, 2023 Power Tools New CLI edition of EF Core Power Tools
May 17, 2023 Primitive collections Collections of primitive values in EF Core
Apr 19, 2023 EF internals EF Core Internals - Model Building
Mar 22, 2023 HierarchyId Using hierarchical data in SQL Server and PostgreSQL with EF Core
Mar 8, 2023 EF internals EF Core internals: IQueryable, LINQ and the EF Core query pipeline
Feb 22, 2023 MySQL MySQL and .NET: MySqlConnector and the Pomelo EF Core Provider
Feb 8, 2023 SQLite SQLite with .NET and EF Core
Jan 11, 2023 FAQ Entity Framework Core FAQs
Dec 14, 2022 EF Core plans The Plan for Entity Framework Core 8
Nov 16, 2022 New features A Whirlwind Tour of EF7
Nov 7, 2022 Model building EF7 Custom Model Conventions
Oct 19, 2022 Bulk updates New EF Core 7.0 APIs (Bulk Update)
Oct 5, 2022 JSON mapping JSON Columns
Sep 21, 2022 Azure Mobile Apps Azure Mobile Apps and offline sync
Aug 24, 2022 SQL translation New aggregate function support in EF Core 7
Aug 10, 2022 WCF CoreWCF: Roadmap and Q&A
Jul 27, 2022 ADO.NET DbDataSource, a new System.Data abstraction
Jul 13, 2022 EF Interceptors Intercept this EF7 Preview 6 Event
Jun 29, 2022 EF internals DbContext Configuration and Lifetime - EF Core Architecture Part 2
Jun 15, 2022 TPH/TPT/TPC TPH, TPT, and TPC Inheritance mapping with EF Core
Jun 1, 2022 EF internals EF Core Architecture: Internal Dependency Injection
May 18, 2022 Testing Testing EF Core Apps (part 2)
May 4, 2022 Pagination Database Pagination
Apr 20, 2022 SaveChanges Performance Improvements to the EF7 Update Pipeline
Apr 6, 2022 Scaffolding Database-first with T4 Templates in EF7: Early look
Mar 9, 2022 GraphQL/OData GraphQL and OData: An In-Depth Discussion
Feb 23, 2022 Entity Framework Celebrating 20 Years of .NET: Entity Framework
Feb 9, 2022 Versioning Software version and "stuff"
Jan 26, 2022 Testing Testing EF Core Apps
Jan 12, 2022 EF Core plans The EF7 Plan
Dec 1, 2021 GraphQL Hot Chocolate 12 and GraphQL 2021
Nov 17, 2021 New features Make History and Explore the Cosmos, an EF Core 6 Retrospective
Nov 3, 2021 Noda Time Noda Time
Oct 6, 2021 Temporal tables SQL Server Temporal Tables and EF Core 6
Oct 20, 2021 Docs EF Core and ASP.NET Core from the ASP.NET documentation team
Sep 22, 2021 PostgreSQL PostgreSQL and EF Core
Aug 25, 2021 Dapper Dapper
Aug 11, 2021 SQL translation EF Core's Global Query Filter
Jul 28, 2021 OData OData
Jul 14, 2021 SQL translation Visualizing database query plans
Jun 16, 2021 Azure Cosmos DB Azure Cosmos DB and EF Core
Jun 2, 2021 Model building Introducing EF Core Compiled Models
May 19, 2021 GraphQL Building Modern Apps with GraphQL
May 5, 2021 Triggers Triggers for EF Core
Apr 21, 2021 Open source Open Source Contributions: How to Add a Feature to EF Core
Apr 7, 2021 Azure SQL Azure SQL for Cloud-Born Applications and Developers
Mar 24, 2021 EF Core Power Tools EF Core Power Tools: the New Batch
Mar 10, 2021 AMA Julie Lerman and EF Core Ask Me Anything (AMA)
Feb 24, 2021 Performance Performance Tuning an EF Core App
Feb 10, 2021 Exception handling Typed Exceptions for Entity Framework Core
Jan 27, 2021 Database projects Introducing MSBuild.Sdk.SqlProj
Jan 13, 2021 Survey EF Core 6.0 Survey Results
Dec 2, 2020 LLBLGen Pro LLBLGen designer and .NET data history
Nov 18, 2020 New features Special EF Core 5.0 Community Panel
Oct 28, 2020 Collations EF Core 5.0 Collations
Oct 14, 2020 Azure Cosmos DB Cosmos DB: Repository Pattern .NET Wrapper SDK
Sep 20, 2020 Spatial types Geographic Data with NetTopologySuite
Sep 16, 2020 Migrations What's New with Migrations in EF Core 5.0
Sep 2, 2020 Offline sync Sync your database with DotMim.Sync
Aug 19, 2020 Many-to-many Many-to-Many in EF Core 5.0
Aug 5, 2020 EF in-depth EF Core In Depth Video Series
Jul 22, 2020 Scaffolding Using Scaffolding with Handlebars
Jun 24, 2020 Blazor EF Core in Blazor
Jun 10, 2020 EF Core Power Tools EF Core Power Tools
May 6, 2020 Welcome! Introducing the EF Core Community Standup

2025

Jun 19: Microsoft.Extensions.VectorData - Access Vector databases in AI apps

Join us for another .NET Data Community Standup where Shay tells us about Microsoft.Extensions.VectorData.

Featuring:

Links:

May 14: Azure SQL vector search with Davide Mauri

We welcome Davide Mauri, Principal Product Manager at Microsoft, to explore the exciting new vector search capabilities in Azure SQL. With the rise of AI-powered applications and semantic search, vector databases are more relevant than ever. In this session, Davide will demonstrate how Azure SQL is evolving to meet these modern needs with integrated vector search features.

Featuring:

Links:

Apr 24: Jiri and Shay talk about EF Core testing and Maurycy corrects them

Jiri and Shay talk about how we test whole EF Core and Maurycy corrects them, because they have it wrong.

Featuring:

Links:

March 19: Stop using Entity Framework as a DTO provider!

Chris Klug has some opinions about Entity Framework and wants you to know about them…

Featuring:

Links:

March 6: Using Chroma vector database from .NET

Join Jiri as he talks about Chroma vector database and fresh new library for .NET that you can use to interact with Chroma.

Featuring:

January 22: Context pooling, FromSql and compiled queries

Join us for another .NET Data Community Standup with Chris Woodruff where he talks about context pooling, FromSql and compiled queries.

Featuring:

2024

November 20: EF Core 9: Release extravaganza

EF Core 9 was just released. Join us in this special session talking with industry experts about all topic EF Core.

Featuring:

June 26: Improve your SQL schema and scripts with .NET based static code analysis

By harnessing the power of the .NET DacFX framework and the related .NET T-SQL parser, you can improve the quality of your database schema and scripts with static T-SQL analysis.

@ErikEJ has recently revived this 15-year-old technology with support for .NET 6 and later, and has brought a number of third-party rules back from the grave.

In this EF Core community standup we will have a closer look - from generation of a simple HTML report with findings to managing and creating your own analyzer rules using modern .NET.

Featuring:

Links:

May 15: Harnessing the Power of Firebird in .NET

In this community talk, we delve into the integration of Firebird, an open-source SQL relational database management system, with .NET, a free, cross-platform, open-source developer platform. This session aims to provide an understanding of how these two powerful technologies can be combined to create robust, scalable, and efficient applications.

This talk is designed for developers of all levels interested in expanding their knowledge on database management and .NET development. Whether you're a seasoned developer or a beginner looking to broaden your skill set, this talk will provide valuable insights into the effective use of Firebird with .NET.

Join us for this enlightening session and discover how you can harness the power of Firebird in .NET to take your applications to the next level.

Featuring:

Links:

Apr 17: All about EF Core property mapping

In this episode, Arthur Vickers and Jiri Cincura from the EF team discuss everything about mapping properties in EF Core. We’ll look at:

  • The differences between properties and navigations.
  • How EF decides to map a property, and whether it is mapped to a nullable column, has a max length defined, etc.
  • When backing fields are used, and mapping fields directly.
  • Shadow properties.
  • Indexer properties.

And if we get time, we’ll look at how value converters influence all this!

Featuring:

Links:

Mar 20: Building Distributed Applications with Hot Chocolate 14, Aspire, and Entity Framework

Building and debugging distributed systems challenges developers to balance complexity with the need for simplicity. Ideally, we aim for the simplicity of a monolith while benefiting from microservices' scalability and isolation. In todays meetup we will have an early look at what we are doing with Hot Chocolate 14 to integrate well with Aspire and bridge this gap, offering an approach that combines microservices' advantages with the ease of a monolith for our consumers. Also we will have a look at a lot of the new feature around Hot Chocolate 14 that will make it so much easier to build layered services with entity framework. Do not worry! We will start slow with just the simplest of services accessing a database and then go all the way in.

Featuring:

Links:

Mar 6: EF Core keys and value generation

In this episode, Arthur and members of the EF Team will explore generated property values and how value generation interacts with keys in the model. We will look at fully client-side value generation, as well as how to use identity columns, database sequences, or a hi-lo pattern for server-side generation. In addition, we’ll investigate how generated key values impact EF Core change tracking by determining if an entity will go into the Added state or not. And finally, if we have time, we’ll look at special considerations for TPC mapping, and customizations such as setting before and after save behaviors, and sentinel values.

Featuring:

Links:

February 21: Window and binary functions using Zomp EF Core extensions

Window functions are one of the most powerful features of SQL. Did you know that you can use Window Functions in EF Core today instead of writing raw SQL? Victor Irzak joins Shay and Arthur to explore real use cases of window functions with EF Core.

Featuring:

Links:

February 7: Database concurrency and EF Core: Beyond optimistic concurrency

In the 3rd installment of our series on concurrency, we'll dive deep into SQL isolation levels, how they work (and work differently!) across SQL Server and PostgreSQL. We'll hopefully learn a bit about how database locks, snapshots and isolation levels work together to bring some sanity into the world of concurrency.

Featuring:

Links:

January 24: Database concurrency and EF Core: ASP.NET and Blazor

In the last episode, we dug deep into the underpinnings of optimistic concurrency handling in EF Core. In this episode, we continue that journey to cover disconnected scenarios. That is, where the entity travels to a client and then back to the server before being updated in the database. We’ll look at the different patterns for doing updates like this in ASP.NET Core and Blazor apps and see how concurrency tokens work with each of these. We’ll also look at how ExecuteUpdate can be used with concurrency tokens, and take a look at ETag concurrency in Azure Cosmos DB.

Featuring:

Links:

January 10: Database concurrency and EF Core

What happens when one user is reading a record while another user is updating it? What if both users try to update the same record at the same time? In this episode of the .NET Data Community Standup, Shay and Arthur take a look at how different database isolation levels impact concurrency and performance, and then extend this to optimistic concurrency patterns supported by Entity Framework Core. This includes both manual concurrency tokens and automatic concurrency tokens like SQL Server’s “rowversion”. We’ll also dig into what happens in disconnected scenarios, and when to use the original value as opposed to the current value of the concurrency token. Finally, we’ll look at how EF Core handles optimistic concurrency with ETags when using a document database like Azure Cosmos DB.

Featuring:

Links:

2023

November 29: A tour of what's new in EF8

Arthur and Shay from the EF team are joined by members of the community to demo some of the key new features available now in Entity Framework Core 8. For example:

  • Primitive collections
  • Complex types
  • HierarchyId in .NET and EF Core
  • Raw SQL queries for unmapped types
  • Lazy-loading enhancements
  • Lookup tracked entities by PK/AK/FK
  • DateOnly/TimeOnly supported on SQL Server
  • Sentinel values and database defaults

Featuring:

Links:

October 18: Introducing the MongoDB provider for EF Core

In this episode of the .NET Data Community Standup, we talk to the engineers from MongoDB who have just released the first preview of an official EF Core provider. The EF team has collaborated closely with MongoDB on this provider, which now joins the Cosmos provider as flagship document database providers for EF Core. We will demo the provider, talk about what it can and cannot do, and of course answer all your questions!

Featuring:

Links:

October 4: Size doesn't matter: Smaller features in EF8

In addition to the big features such as primitive collections and complex types, EF8 contains many smaller features and minor improvements. In this session, Arthur and Shay from the EF team will take a look at a few of these smaller features, including:

  • Sentinels to control when the database generates a value
  • Massive performance improvements for IN and EXISTS in LINQ queries
  • DateOnly/TimeOnly on SQL Server
  • Raw SQL queries for unmapped types
  • More flexible ExecuteUpdate
  • Numeric SQL rowversion properties
  • Cleaner SQL through parentheses elimination

Featuring:

Links:

September 20: Complex types as value objects in EF8

The Entity Framework team returns with new community standups after a summer break heads-down working on EF8. In this session, we’ll look at the new “complex types” feature in EF8. Complex types do not have a key or any identity outside of the object’s value, but can still be deconstructed by property to map to different columns in the database. This allows either reference or value types to be used as DDD value objects with much better fidelity than when owned types are used. We’ll show examples of using complex types and talk about and answer your questions on the behavioral differences between entity types, owned entity types, complex types, and primitive types.

Featuring:

Links:

June 14: Synchronizing data between the cloud and the client (using SQLite)

In this session, we'll invite Eric Sink to discuss a solution for keeping a synchronized copy of the DB (using SQLite) on the client, rather than asking data for the cloud every time. This is helpful for mobile scenarios where the connectivity may be poor, but the "rep and sync" approach can reduce the time the user spends waiting on the network. Local writes are fast, sync happens in the background. We'll explore how this can be done efficiently, how to deal with conflict resolution, and other data sync-related concerns. Featuring:

Links:

May 31: New CLI edition of EF Core Power Tools

In today's standup, Erik will demonstrate the new CLI edition of EF Core Power Tools and show how he used a number of community NuGet packages to improve the user experience when creating a CLI tool.

Featuring:

Links:

May 17: Collections of primitive values in EF Core

In this episode of the .NET Data Community Standup, the .NET Data Access team dive into new support for collections of primitive values, just released in EF Core 8 Preview 4. Collections of a primitive type can now be used as properties of an entity type and will be mapped to a JSON column in the relational database. In addition, parameters of primitive values can be passed to the database. In either case, the native JSON processing capabilities of the database are then used to exact and manipulate the primitive values, just as if they were in a table. This opens up powerful query possibilities, as well as optimizations to common problems such as translating queries that use Contains.

Featuring:

Links:

Apr 19: EF Core Internals – Model Building

In this session, the .NET Data Access team will dig into the EF Core internals for building a model. EF models are built using a combination of three mechanisms: conventions, mapping attributes, and the model builder API. We will explain each of these mechanisms and show how they interact. We’ll also cover how models are cached, and ways in which that caching can be controlled. And, as always, we’ll answer your questions live! Featuring:

Links:

Mar 22: Using hierarchical data in SQL Server and PostgreSQL with EF Core

Join the .NET Data Access Team to learn about mapping hierarchical data structures to relational databases using EF Core. We’ll look at “hierarchyid” on SQL Server/Azure SQL and “ltree” on PostgresSQL, and show how to map tree structures such as a family tree, file system, or organization structure. EF Core can then be used to write LINQ queries against the hierarchy to find ancestors and descendants in various ways, as well as perform manipulation of subtrees for updates. And, as always, we’ll be here to answer your questions!

Featuring:

Links:

Mar 8: EF Core internals: IQueryable, LINQ and the EF Core query pipeline

In this standup, we'll dive deep under the hood to see how EF Core processes LINQ queries, translates them to SQL and executes them on your database. We'll introduce key concepts such as IQueryable and LINQ providers, and see how EF Core uses caching to make your querying lightning-fast. Join us to understand how the magic works!

Featuring:

Links:

Feb 22: MySQL and .NET: MySqlConnector and the Pomelo EF Core Provider

This week, we'll be hosting Bradley Grainger and Laurents Meyer, authors of the open-source MySQL ADO.NET driver and of the Pomelo EF Core provider. Both these components work together to provide a 1st-class MySQL data access experience in .NET. We'll discuss some of the specifities of MySQL as a database, what it's like to work on open source data projects in .NET, and whatever else comes to mind!

Featuring:

Links:

Feb 8: SQLite with .NET and EF Core

This week, Eric Sink (creator of SQLitePCL.raw) and Brice Lambson (creator of Microsoft.Data.Sqlite) join the .NET Data Access Team to discuss everything SQLite on .NET. We’ll start down low digging into different ways to get the SQLite native binaries using Eric’s packages. Then we’ll move up the stack to look at the basics of SQLite on .NET with Brice’s ADO.NET provider. Going higher still, we’ll look at how to get the most from SQLite with the EF Core provider. And, as always, we’ll be there to answer any questions you have about SQLite on .NET.

Featuring:

Links:

Jan 11: Entity Framework Core FAQs

Join the Microsoft .NET Data team to get answers to many frequently asked questions about EF Core. For example:

  • What's the difference between EF Core and EF6?
  • What NuGet packages to I need to install to use EF Core?
  • Should I always use no-tracking queries?
  • Why does EF Core sometimes ignore Includes?
  • What's wrong with using owned types for value objects?
  • Should I create a repository over EF Core?
  • Why does the in-memory database not work in my tests?
  • How do I call stored procedures from EF Core?
  • How do I see the SQL for a LINQ query?

Featuring:

Links:

2022

Dec 14: The Plan for Entity Framework Core 8

The plan has been published for EF Core 8 and other data access work in .NET 8. This includes work in five major themes:

  • Highly requested features
  • Cloud native and devices
  • Performance
  • Visual tooling
  • Developer experience

Join the .NET Data Team for a discussion of what’s in and what’s out, and to get your questions answered.

Featuring:

Links:

Nov 16: A Whirlwind Tour of EF7

Join the .NET Data team as we take a whirlwind tour through new features of EF Core 7.0 (EF7). This includes JSON columns, bulk updates, TPC mapping, and more!

Featuring:

Links:

Nov 7: EF7 Custom Model Conventions

EF Core uses a metadata "model" to describe how the application's entity types are mapped to the underlying database. This model is built using a set of around 60 "conventions". The model built by conventions can then be customized using mapping attributes (aka "data annotations") and/or calls to the DbModelBuilder API in OnModelCreating. EF7 allows applications to remove or modify existing conventions, as well as create new conventions. Join us for this .NET Data Community Standup to learn how to take advantage of custom model building conventions in your EF Core 7.0 applications.

Featuring:

Links:

Oct 19: New EF Core 7.0 APIs (Bulk Update)

EF Core 7.0 introduces the ExecuteUpdate and ExecuteDelete APIs, which allow you to easily use LINQ to express a database update or delete operation. These APIs can be far more efficient for applying changes to multiple rows based on a condition, e.g. “delete rows which have InActive set to true” (AKA bulk update scenarios). But in some scenarios, they also allow you to express changes over a single row in a much more succinct and simple way, simplifying your code. ExecuteUpdate and ExecuteDelete completely bypass EF’s change tracking and execute immediately, as opposed to when SaveChanges is called. Tune in to learn more and to explore the new possibilities that these new APIs bring!

Featuring:

Links:

Oct 5: JSON Columns

JSON columns allow relational databases to directly store documents while retaining the overall relational structure of the data. EF7 contains provider-agnostic support for JSON columns, with an implementation for SQL Server. The JSON in these columns can queried using LINQ, allowing filtering and sorting by the elements of the documents, as well as projection of elements out of the documents into results. In addition, EF7 supports element-level change tracking of the documents and partial updates for only the changed elements when SaveChanges is called.

Featuring:

Links:

Sep 21: Azure Mobile Apps and offline sync

Learn how Azure Mobile Apps provides the tools and libraries you need to easily synchronize data between an Entity Framework Core-backed Web API and your mobile or desktop app.

Featuring:

Links:

Aug 24: New aggregate function support in EF Core 7

Aggregate functions such as COUNT, MAX or AVG compute a single value from multiple rows. EF7 adds support for custom provider aggregate functions, adding support for many new translations. In this episode of the .NET Data Community Standup, we’ll explore these new translations across different EF providers, and see what they could mean for more efficient data loading from the database. We’ll also go into some tricky design problems and under the hood query translation details which the team discussed while working on this feature.

Featuring:

Links:

Aug 10: CoreWCF: Roadmap and Q&A

CoreWCF is a port of the service side of Windows Communication Foundation (WCF) to .NET Core. The goal of this project is to enable existing WCF services to move to .NET Core. The CoreWCF team recently conducted a survey and will be talking about some of the responses, answering questions, and sharing insights into their roadmap for the future.

Featuring:

Links:

Jul 27: DbDataSource, a new System.Data abstraction

In this episode of the .NET data community standup, we'll explore DbDataSource, a new abstraction being introduced to System.Data in .NET 7.0. DbDataSource unlocks easier integration of ADO.NET drivers with dependency injection, better management of advanced driver configuration, helps performance and more. Tune in to see improvements at the lower levels of the .NET data stack.

Featuring:

Links:

Jul 13: Intercept this EF7 Preview 6 Event

EF7 includes a variety of new interceptors and events, as well as many improvements to the existing lifecycle hooks. In this session, Arthur and others from the .NET Data team will dive into this new functionality, including examples for intercepting materialization of entities, query expression trees, identity resolution when tracking, and optimistic concurrency violations. Join us for a fun-packed ride into the world of modifying EF behavior through interception with code galore!

Featuring:

Links:

Jun 29: DbContext Configuration and Lifetime - EF Core Architecture Part 2

Arthur and others from the EF Team continue their deep dive into the architecture of Entity Framework Core. This is a code-driven discussion looking at how and why things are designed and implemented the way they are. In this session, we look at the initialization and configuration of a DbContext instance, including selection of the provider, creating DbSet instances, reading DbContextOptions, and DbContext pooling.

Featuring:

Links:

Jun 15: TPH, TPT, and TPC Inheritance mapping with EF Core

Type inheritance hierarchies as used in object-oriented programming do not map naturally to relational database schemas. In this live stream, we will look at different strategies for inheritance mapping when using EF Core with a relational database. This includes table-per-hierarchy (TPH) mapping, table-per-type (TPT) mapping, and table-per-concrete type (TPC) mapping, which is new in EF Core 7.0 preview 5. We will look at the consequences of the mapping on the generated SQL and consider the performance and storage implications. This will result in some guidance as to when each strategy should be used.

Featuring:

Links:

Jun 1: EF Core Architecture: Internal Dependency Injection

Join Arthur Vickers and others from the EF Team as we start a deep dive into the architecture of Entity Framework Core. This won’t be a formal talk, but rather a free-form discussion driven by the code where we look how and why things are designed and implemented the way they are. This week, we’ll start with the use of dependency injection (D.I.) and the “internal service provider.” This is the backbone of how EF Core works as a service-oriented architecture, where the core code, database providers, and plugins all implement services that work together to provide EF’s functionality.

Featuring:

Links:

May 18: Testing EF Core Apps (part 2)

In this second part of testing EF Core Apps, guest Jon P Smith will focus on the actual code and approaches that you need to test applications using EF Core and will address some key "pain points."

Featuring:

Links:

May 4: Database Pagination

Lots of data? Time to page it. But what's the best approach? TAKE, SKIP, and OFFSET? What about keyset pagination? Join the .NET Data team when we page the author of "keyset pagination for EF Core" Mohammed Rahhal to discuss paging and answer your questions live.

Featuring:

Links:

Apr 20: Performance Improvements to the EF7 Update Pipeline

Join the Entity Framework team as they review optimizations to the update pipeline to improve performance. Come prepared with your EF7 questions as we plan to spend time in Q&A to answer your questions live.

Featuring:

Links:

Apr 6: Database-first with T4 Templates in EF7: Early look

Prefer null setters? Property initializers? Constructor initialization? What about auto-generating database diagrams that render in markdown using Mermaid? Learn how to take control of your database scaffolding in this early look at an EF7 feature that's hot off the press

Featuring:

Links:

Mar 9: GraphQL and OData: An In-Depth Discussion

The creator of the GraphQL library HotChocolate, Michael Staib, and Microsoft engineer and OData expert Hassan Habib discuss the various capabilities of GraphQL and OData and how they empower developers to go beyond REST.

Featuring:

Links:

Feb 23: Celebrating 20 Years of .NET: Entity Framework

As .NET celebrates its 20th birthday, Entity Framework approaches its 10-year anniversary of going open source. The Entity Framework team will celebrate these milestones by inviting back the engineers and program managers who helped shipped previous versions to share their stories, demos, and anecdotes. Join Tim Laverty, Rowan Miller, Danny Simmons, Diego Vega, and more for this special edition of the .NET Data community standup.

Featuring:

Links:

Feb 9: Software version and "stuff"

Join the .NET Data team and Jon Skeet in a discussion around software versioning, issues with versioning in .NET, and… stuff. Who knows what topics may come up? Join us live to find out and have your questions answered in real time.

Featuring:

Links:

Jan 26: Testing EF Core Apps

What’s the best way to run automated tests on an application that uses Entity Framework Core? Jon P Smith, author of the book “Entity Framework Core in Action” covers three ways to create automated tests for your code and looks at the EF Core test “pain points” and how to get around them.

Featuring:

Links:

Jan 12: The EF7 Plan

The plan for EF7 has been published. In this episode, the EF Core/.NET Data team will review the details of the plan and answer live questions about the roadmap.

Featuring:

Links:

2021

Dec 1: Hot Chocolate 12 and GraphQL 2021

Hot Chocolate 12 allows for more schema-building options with deeper integrations into EF core. Hot Chocolate has already implemented the new GraphQL October 2021 spec, and we will explore the new capabilities. We now support the complete stream and defer spec and will look into these new data fetching capabilities.

Featuring:

Links:

Nov 17: Make History and Explore the Cosmos, an EF Core 6 Retrospective

EF Core 6 has been released with a long list of features from performance improvements, temporal tables support, CI/CD-friendly migration bundles, compiled models, query improvements, enhanced Azure Cosmos DB capabilities and much more. Join the EF Core team and our community panelists as we review what's new, share the EF Core 6 story and answer your questions live.

Featuring:

Links:

Nov 3: Noda Time

Noda Time is an alternative date and time API for .NET. It helps you to think about your data more clearly, and express operations on that data more precisely.

Featuring:

Links:

Oct 6: SQL Server Temporal Tables and EF Core 6

Learn about the new support in EF Core 6 for temporal tables, including creating them from migrations, transforming existing tables into temporal tables, querying historical data and point-in-time restore.

Featuring:

Links:

Oct 20: EF Core and ASP.NET Core from the ASP.NET documentation team

Back to the basics: EF Core and ASP.NET Core from the documentation team.

Featuring:

Links:

Sep 22: PostgreSQL and EF Core

PostgreSQL has some advanced capabilities not usually found in other relational databases. In this session we'll go over some of them, and see how EF Core makes these accessible.

Featuring:

Links:

Aug 25: Dapper

Dapper maintainers and key contributors Nick and Marc will show people the glorious power of Dapper and everything it can do, so they are fully informed and can choose something much better, like EF Core (their words).

Featuring:

Links:

Aug 11: EF Core's Global Query Filter

Why do customers want "soft delete"? What's a good practice for handling multi-tenancy in EF Core apps? The reformed programmer, Jon P. Smith, shares how to use a powerful tool in the EF Core platform, global query filters, to handle scenarios like "soft delete."

Featuring:

Links:

Jul 28: OData

OData is one of the best protocols out there to supercharge your ASP.NET Core APIs with so many capabilities such as shaping, filtering, batching and ordering the data on the fly - it executes it's queries on the server which tremendously improves the performance on client side. Hassan talks all things OData on the Community Standup.

Featuring:

Links:

Jul 14: Visualizing database query plans

Learn what a query plan is, how to view EF Core query plan in LINQPad, find missing indexes, and improve performance of your queries.

Featuring:

Links:

Jun 16: Azure Cosmos DB and EF Core

EF Core may be an object relational mapper, but it also can ditch the relational and connect directly to the Azure Cosmos DB NoSQL engine. In this standup, the team will discuss the rationale behind a Cosmos DB provider, show code examples, discuss the major differences between SQL and NoSQL data and share the roadmap for future enhancements to the Azure Cosmos DB provider.

Featuring:

Links:

Jun 2: Introducing EF Core Compiled Models

EF Core creates an internal model for entity types and their database mappings. This model is typically built once when the application starts. Starting with EF Core 6.0, it is now possible to instead build this model at compile time. This can reduce startup time by up to 67% for large models. Join us for this Community Standup, where the team will introduce compiled models and demo their use.

Featuring:

Links:

May 19: Building Modern Apps with GraphQL

GraphQL is a great way to expose data whether you expose your business layer in a much richer way or just map your data models to get started quickly. GraphQL gives backend engineers the tools to mold the service layer without compromises and lets the frontend engineer decide what data he or she needs to build that awesome application. Learn the what, why, and see how to build apps with GraphQL.

Featuring:

Links:

May 5: Triggers for EF Core

Guest Koen Bekkenutte will introduce us to the EFCore.Triggered project and discuss its advantages and how it differs from domain events and database triggers. See how it is implemented and how the project uses EF Core's ChangeTracker and SaveChanges interception. As always, the EF Core team and Koen will be responding to live Q&A.

Featuring:

Links:

Apr 21: Open Source Contributions: How to Add a Feature to EF Core

Do you want to contribute to EF Core but are uncertain where to begin? We’re here to help! In this episode of the EF Core Community Standup, we will add an EF Core feature live. We’ll go through everything from forking the repo, adding the code and related tests, and generating the pull request. Learn how the codebase is organized, how to build and how to run tests and receive answers to your questions in real time direct from the team that brings you magic unicorns!

Featuring:

Links:

Apr 7: Azure SQL for Cloud-Born Applications and Developers

Join Davide Mauri and the EF Core team for an interactive discussion about how Azure SQL helps cloud developers create cloud native solutions. From simple REST APIs to scalable backends, Azure SQL provides the required flexibility, scalability, and features to simplify the developer's life. Davide will cover topics ranging from JSON support and CI/CD to column-store, geospatial and graph models.

Featuring:

Links:

Mar 24: EF Core Power Tools: the New Batch

Learn how to take advantage of the new advanced features recently added to EF Core Power Tools: - reverse engineer .dacpac files, renaming of tables, columns and even navigations, excluding columns, working with multiple DbContexts in the same project, map spatial columns and SQL Server stored procedures. The session will also include a look under the hood of EF Core Power Tools reverse engineering.

Featuring:

Links:

Mar 10: Julie Lerman and EF Core Ask Me Anything (AMA)

Julie Lerman is an independent authority and community luminary for Entity Framework. She has been programming for nearly 30 years and has been an independent consultant since 1989. Julie is one of 150 Microsoft Regional Directors worldwide and has been awarded Microsoft MVP annually since 2003. Join Julie and the EF Core team for an "ask me anything" session: your questions answered in real-time!

Featuring:

Links:

Feb 24: Performance Tuning an EF Core App

Guest Jon P Smith shows how he built a demo e-commerce book selling site that uses EF Core. He started with 700 books then scaled through 100,000 books to ½ million books. At each stage he compares the performance of each improvement, and the extra work to get that performance.

Featuring:

Links:

Feb 10: Typed Exceptions for Entity Framework Core

When using Entity Framework Core for data access all database exceptions are wrapped in DbUpdateException. If you need to know whether the exception was caused by a unique constraint, the value being too long, or the value missing for a required column, you need to dig into the concrete DbException subclass instance and check the error number to determine the exact cause. In this episode, learn how EntityFramework.Exceptions handles all the database-specific details and allows you to use typed exceptions for Entity Framework Core when your query violates database constraints.

Featuring:

Links:

Jan 27: Introducing MSBuild.Sdk.SqlProj

MSBuild.Sdk.SqlProj is a new open source project that allows you to build SQL Server Database Projects (.sqlproj) using the new SDK-style projects cross-platform without the need to have Visual Studio installed. Jonathan will show why you would use it, how you can get started and walk you through its various features. He'll also show how you can contribute to the project.

Featuring:

Links:

Jan 13: EF Core 6.0 Survey Results

We asked, and you listened! Nearly 4,000 developers responded to the EF Core 2020 survey. In this edition of the community standup, senior program manager Jeremy Likness will review the survey results and discuss how they impact the plan for EF Core 6.0. The team will be available to answer your questions live.

Featuring:

Links:

2020

Dec 2: LLBLGen designer and .NET data history

In this episode we welcome guest Frans Bouma, who will show us how to graphically model a domain for any .NET ORM with the LLBLGen Pro designer. Frans is also a venerable .NET data and SqlServer figure, so we will chat a lot about history and what's it's been like to make a commercial ORM in the Microsoft world.

Featuring:

Links:

Nov 18: Special EF Core 5.0 Community Panel

In this special edition of the EF Core Community Standup, we celebrate the release of EF Core 5.0 with a community panel. We'll welcome Entity Framework luminaries Diego Vega, Erik E Jensen, Jon P Smith and Julie Lerman to discuss their favorite features and answer your questions live.

Featuring:

Links:

Oct 28: EF Core 5.0 Collations

In this community standup, we'll be showing new features around case sensitivity and collations in 5.0. We'll also provide a glimpse into how these features were designed, and what considerations and constraints guide the EF team - performance, cross-database support, usability and more. Come see how we design EF features under the hood!

Featuring:

Links:

Oct 14: Cosmos DB: Repository Pattern .NET Wrapper SDK

In this episode, fellow .NET TV host David Pine will join Jeremy Likness to discuss his Cosmos DB Repository pattern .NET SDK. The SDK aims to simplify the Cosmos DB .NET SDK by abstracting away some of the complexities, exposing an elegant API surface area, and providing C.R.U.D. operations through the IRepository interface.

As always, the EF Core team will be available to answer questions live.

Featuring:

Links:

Sep 30: Geographic Data with NetTopologySuite

Joe Amenta joins us to discuss how to add spatial data to your applications to open a world of new relationships between data. He will demonstrate the "status quote" for querying spatial data from .NET Core and demo integrations with NetTopologSuite and EF Core.

Featuring:

Links:

Sep 16: What's New with Migrations in EF Core 5.0

The Entity Framework Core team focused on major improvements to migrations for the EF Core 5.0 release. Learn about what's new and explore different migrations scenarios in this demo-heavy session. As always, the team will be standing by live to answer your questions!

Featuring:

Links:

Sep 2: Sync your database with DotMim.Sync

The maintainer of open source software solution DotMim.Sync joins the EF Core team to discuss how the project helps keep local relational databases in sync.

Featuring:

Links:

Aug 19: Many-to-Many in EF Core 5.0

Join the team as they explore the latest many-to-many mapping features implemented for EF Core 5.0 including skip navigations and more!

Featuring:

Links:

Aug 5: EF Core In Depth Video Series

Join members from the .NET teams for our community standup covering great community contributions for Framework, .NET Core, Languages, CLI, MSBuild, and more.

Featuring:

Links:

Jul 22: Using Scaffolding with Handlebars

Join members from the .NET teams for our community standup covering great community contributions for Framework, .NET Core, Languages, CLI, MSBuild, and more.

Featuring:

Links:

Jun 24: EF Core in Blazor

Join members from the .NET teams for our community standup covering great community contributions for Framework, .NET Core, Languages, CLI, MSBuild, and more.

Featuring:

Links:

Jun 10: EF Core Power Tools

Join members from the .NET teams for our community standup covering great community contributions for Framework, .NET Core, Languages, CLI, MSBuild, and more.

Featuring:

Links:

May 6: Introducing the EF Core Community Standup

Join members from the .NET teams for our community standup covering great community contributions for Framework, .NET Core, Languages, CLI, MSBuild, and more.

Featuring:

Links: