[FREE] Hosting ASP.NET Web Apps with a SQLite database on Azure
In this tutorial I demonstrate a free way for people to host ASP.NET web apps with a SQL database on Azure. In the demonstration a Blazor server app is created with basic CRUD functionality, using Bootstrap as the front-end framework. Entity Framework Core is used to create the database using a code-first approach. Lastly the app is published to an Azure App Service resource.
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
►► Blazor – Real World Developer Portfolio Course Discount Link:
https://rubenheeren.com/course-promo-link/blazor-your-dev-portfolio
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
►► DOWNLOAD SOURCE CODE:
https://github.com/RubenHeeren/SQLiteDatabaseFreeAzure
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
►► LIVE DEMO
https://sqliteazuretwo.azurewebsites.net/
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
So what is SQLite and why should you use it?
SQLite is a great SQL database variant for your testing and smaller production apps. With SQLite your database is just simply a file. Using this allows you to host an app with a SQL database for free on Azure, whereas if you want a full blown SQL server it’ll cost you I believe about $10 a month minimum. You can actually run growing production apps on SQLite as well, if your SQLite database can’t handle your traffic anymore you know you have a good problem on your hands. So that’s a little overview of SQLite and why I use it.
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
►► TIMESTAMPS
0:00 – Intro
1:00 – Creating a new solution with a Blazor server project
2:24 – Visual Studio version
2:46 – Installing NuGet packages
4:20 – Creating a code-first database with EF
16:15 – Creating a simple Blazor front-end
43:21 – Publishing to Azure (App Service)
49:20 – Outro
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
►► CREDITS
Lively Animated Desktop Wallpaper Software: https://github.com/rocksdanister/lively
Motherboard Background Image:
https://unsplash.com/@alexkixa
Visit my website (example of what you can build with ASP.NET): https://rubenheeren.com
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Good luck on your developer journey!
#azure #sqlite #aspnetcore
Comments are closed.