Everything about Database and .NET Aspire

In this session, we will explore various integration patterns for enterprise engineers looking to incorporate SQL Server into their .NET Aspire solutions. Learn about different data source options, including the use of local and container databases. Additionally, we cover Data API builder to streamline data management and access. These are practical insights and hands-on examples to help engineers effectively leverage SQL Server in real-world applications.

⌚ Chapters:
00:00 Welcome to .NET Aspire and SQL Server
00:22 Agenda
01:20 What is Azure SQL database
02:12 Demo - Database project
07:21 SQL container
13:42 Seed Data
16:25 Data persistence
18:20 Data Api builder
23:52 A simple client
27:50 Resources
28:12 Wrap

Book Discount: Pragmatic Microservices with C# and Azure

Connect with .NET:

Featuring: Jerry Nixon

#dotnet

[Tech_Alchemy]

Great demo on ways we can integrate SQL into aspire projects.

[Hamaze]

That was a great session and Jerry is an impressive presenter

[rafaelregueira]

Hi,
Excellent demo. Thanks for sharing.

[JohnMarsing]

Wow, lots of stuff. My biggest constraint to using Aspire like you're doing here is leaning Docker and Linux oh yeah also DAB.

Right now I'm trying to get up to speed on converting a Blazor Server app to Blazor 8 WASM that's using NSwag

Thanks for the video Jerry, I'll keep this in my notes for sometime in the future.

[Gamer-il-ke]

Where are the two files promised at 14:24 of the video?

[IndigoDalliance]

Great video, Jerry. I have found your tutorial very clear and informative. This comes handy as I am just working on implementing SQL Server with Aspire and ran into some issues. It would be great if you could do a tutorial on how to implement migration in Aspire, as well.

[billydev]

Great demo, very in-depth! Maybe that's a stupid question, I know you didn't actually say this, but how is this any better than using migrations? It seems like a lot of steps and configurations just to make it work. Migrations already contain the schema of the database in the source.

[ArnonDanon]

This is a great video, very clear, very structured, how much of this will translate if i use oracle for example?

[alonezlciel]

18:23 This is the part I do not like about Aspire. People already use docker compose file to configure containers. Why do we have to covert everything into C# program.cs again.

[ardallleonardo]

I got error `stderr exec /usr/config/entrypoint.sh: exec format error` any hint?