.NET EFCore | Publish your Web API and SQL database to Azure Service using Visual Studio ONLY

[@Netcode-Hub]

Follow @Netcode-Hub on: netcodehub.blogspot.com github.com/Netcode-Hub | Grab projects source code from here. twitter.com/NetcodeHub | Twitter web.facebook.com/NetcodeHub | Facebook www.linkedin.com/in/netcode-hub-90b188258/ | LinkedIn

[@colocaps]

good tutorial man, it would be great if you could explain how to connect the azure sql db to sql server managment studio

[@Netcode-Hub]

Alright sir, will see to that😀

[@dilrukshiperera-yo5br]

thankyou. I made some use of this tutorial.

[@Netcode-Hub]

Welcome 🤗

[@HieuNguyen-un4bb]

nice video bro! But i have an question. When i click finish on 8:31 , i get 3 errors : - NuGet.PackageManagement.PackageReferenceRollbackException: Package restore failed. Rolling back package changes for 'MagicPost_BackendAPI'. - Failed to configure NuGet packages. - Failed to configure dependency Azure SQL Database mssql1. i don't understand why cause i do it same as you do. Can you explain for me if u know that! Thank u so much

[@Netcode-Hub]

Will check please

[@lirovink]

Thank you so much for this video man! I was looking for ages for an answer to show the Swagger (now OpenAPI) page on my web app until i came across this video. Just a quick question - how come the database is empty if we choose to include the dbContext from our application? did i miss something from your explanation?

[@Netcode-Hub]

Did you publish your database to azure?

[@lirovink]

@@Netcode-Hub Yes of course When I executed show all data GET command, I was presented with an empty array After adding data using the ADD command, I saw the new data I saved displayed instead of the empty array. I have another question. I have a registration function with which I register new users, and then a login function with which I get a JWT to authenticate and send CRUD commands. Is there a way to use the token that I get through SWAGGER, or do I have to work only with the help of POSTMAN for example?

[@Netcode-Hub]

@lirovink yes , you can add authorization feature to swagger . Check playlist, have couple of videos to assist you. You can also mail me for special assistance.

[@lirovink]

@@Netcode-Hub Thank you man. I am lost, can you please direct me to a specific video about the subject? much appreciation

[@mostafayehya4902]

this error shown in the step entity framework migration dotnet tool install dotnet-ef The tool package could not be restored. Tool 'dotnet-ef' failed to install. This failure may have been caused by: * You are attempting to install a preview release and did not use the --version opt * A package by this name was found, but it was not a .NET tool. * The required NuGet feed cannot be accessed, perhaps because of an Internet co * You mistyped the name of the tool. For more reasons, including package naming enforcement,

[@Netcode-Hub]

Use this instead dotnet tool install --global dotnet-ef

[@crepinoscript12]

I am using a MySQL database, and in the API, I have configured token generation and role-based authorization before accessing an API route. Could this tutorial apply to my system? PLEASE

[@Netcode-Hub]

Absolutely

[@crepinoscript12]

@@Netcode-Hub i tried to do that but microsoft azure service is not available in my country unfortunetly i can"t create an account 💔,can you please show me another way to publish my API ?

[@محمد-ع4ث2ق]

can i use postgresql insted of sql server ?

[@Netcode-Hub]

Absolutely

[@ReadLineAcademy]

Thanks sir❤️❤️

[@Netcode-Hub]

😃

[@stark5131]

what is cost for this ??

[@Netcode-Hub]

Are you talking about azure hosting service ?

[@leandroangeldzibnauat4427]

Don't show swagger on my app deployed

[@Netcode-Hub]

Check your program setting Change swagger middleware from development to production or comment it. Have you don’t that already ?

[@dznleandro]

Yeah, I commented the if of development mode, thanks 🎉

[@Netcode-Hub]

@dznleandro welcome 🤗