Step by step guide on utilising Docker Compose with Asp.Net Core, SQL Server

This video will show you step by step how to create a Docker Compose file for an ASP.Net core application and SQL Server Database utilising the entity framework code first approach.

Source code:

Visual Studio code:

DotNet core SDK:

Docker download:

Let us connect:

Support my work:

Hire Me:

WHO AM I:
I'm Mohamad, a Enterprise Architect working in Manchester, UK. I make videos about web, cloud, desktop and mobile development.

GET IN TOUCH:

#dotnet #docker #docker-compose #beginners #efcore #aspnetcore

[ahmadyamout]

Hello dear please make sure to raise your voice volume and to zoom in when typing any code . Please take it as a constructive criticism. Thank you for your informative videos

[yonis]

Great content thanks, my question is can we run the docker-compose from the published file of the .net application instead of using the project folder. the reason i asked is the connection string is only spcified on the appsetting.json of the published file. i didnt use any environment variables as you did in the program.cs file i seem to be getting error all the time " network related error ' could you please share any resources about this or make a video abut it thanks.

[HaoNguyen-nlfz]

Thank you so much. Read your article/blog. This saved me after weeks of deploying this Docker thing.

[josecarlosmacoratti]

Hi, How can I save the data after the SQL Server container was destroyed ?

[souviksardar]

Thank you so much. I have learnt lot of things from this. one quick question, where I can find the 'booksdb' database? what will be the server to connect to get the table using SA credential?
I have connected server with name (local), (.), localhost, (localdb)\MSSQLLocalDB and entered username as SA & respective password. I was able to login in all these servers but no where I found 'booksdb' database.

[ahmadyamout]

Dear you know in the thumbnail you have put azure logo I thought that you are gonna use also azure devops ci cd with them . Dear are you gonna do asp.net with docker sql image than push it to devops ci cd piplines . I haven't found such video. Thank you

[losamanos]

Hi thank you for your tutorial but could I couldn find your source code on github 😕

[_MoshikoAz_]

Hello Mohamad,
Does it works with m1 mac’s ?

[_grzehotnik]

The code does not work. The exception I get is: " (0x80131904): A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correc
t and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 25 - Connection string is not valid)".
I downloaded the code from github, that does not work either.

[buddysteve]

YOUR MIC IS WAY TOO LOW!! TURN UP YOUR MIC!!

[tadsshaddy]

How do you do it if the data base is already present.