[FREE] Hosting ASP.NET Web Apps with a SQLite database on Azure

In this tutorial I display a free approach for individuals to host ASP.NET net apps with a SQL database on Azure. In the demonstration a Blazor server app is created with primary CRUD performance, utilizing Bootstrap because the front-end framework. Entity Framework Core is used to create the database utilizing a code-first strategy. Lastly the app is revealed to an Azure App Service useful resource.


►► Blazor – Real World Developer Portfolio Course Discount Link (solely $14.99):






So what’s SQLite and why do you have to use it?

SQLite is a nice SQL database variant to your testing and smaller manufacturing apps. With SQLite your database is simply merely a file. Using this lets you host an app with a SQL database without spending a dime on Azure, whereas if you would like a full blown SQL server it will value you I imagine about $10 a month minimal. You can really run rising manufacturing apps on SQLite as properly, in case your SQLite database cannot deal with your visitors anymore you realize you’ve got a good downside on your palms. So that is a little overview of SQLite and why I take advantage of it.


0:00 – Intro
1:00 – Creating a new resolution with a Blazor server undertaking
2:24 – Visual Studio model
2:46 – Installing NuGet packages
4:20 – Creating a code-first database with EF
16:15 – Creating a easy Blazor front-end
43:21 – Publishing to Azure (App Service)
49:20 – Outro


Lively Animated Desktop Wallpaper Software:

Motherboard Background Image:

Visit my website (instance of what you’ll be able to construct with ASP.NET):


Good luck on your developer journey!

#azure #sqlite #aspnetcore

Video Duration: 00:49:52

Subscribe to Channel:

This video by Ruben Heeren was preferred: 42 occasions

If you want this video by Ruben Heeren, please help their CHANNEL by clicking on the SOURCE hyperlink beneath and Subscribe.



Featuring Your Videos:

By featuring your videos on our weblog, your videos will obtain a whole bunch of views each day from our website guests, you get a backlink to your channel for followers to subscribe to your channel. This is a win/win for website positioning for each of us. If you want to your videos or channel highlighted and premiered on our weblog for FREE, please contact us.

However, in the event you now not need us to premier your channel, and wish us to take away your video and never function your channel anymore, please contact us.

Video Post Disclaimer:

The info contained within the multimedia content material (“Video Content”) or put up content material generally, represents the views and opinions of the unique creators of such Video Content or put up, and doesn’t essentially characterize the views or opinions of YeniExpo. The mere look of Video Content or the put up on the Site doesn’t represent an endorsement by YeniExpo or its associates of such Video or Post Content. 

The Video Content or Post has been made out there for informational and academic functions solely. YeniExpo doesn’t make any illustration or warranties with respect to the accuracy, applicability, health, or completeness of the Video or Post Content. YeniExpo doesn’t warrant the efficiency, effectiveness or applicability of any websites listed or linked to in any Video Content or Post.

Affiliate Disclosure:

This put up and outline might also include some affiliate hyperlinks, which implies that the put up creator could obtain a small fee at no additional value to you in the event you click on on a few of the product hyperlinks and resolve to make a buy. This channel is a participant within the Amazon Services LLC Associates Program, an affiliate promoting program designed to offer a means for websites to earn promoting charges by promoting and linking to Amazon.com

Copyright Issue:

If you discover any of your copyrighted materials on this put up or video, please contact us, so we will resolve the difficulty.

© All rights reserved by respective owners.


300×600 olive oil talk ad 1

Video Keyword Tags:

8 thoughts on “[FREE] Hosting ASP.NET Web Apps with a SQLite database on Azure

  1. ecurbokareka says:

    Hi Ruben, Thank you for terrific turorial.

    I just downloaded your source code and had app running successfully on my development machine. I then tried publishing to my Azure account. Tried to run there and got a SQLite type error (see below). Any ideas ?

    Thanks again Ruben.

    An unhandled exception occurred while processing the request.

    SqliteException: SQLite Error 14: 'unable to open database file'. Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(int rc, sqlite3 db)

    Microsoft.Data.Sqlite.SqliteConnection.Open()..etc etc.

  2. Peter De Tender says:

    This was one of the most clear and working Blazor Server CRUD tutorials I"ve seen. I followed along end-to-end, while updating some terminology from Posts to my data set. And all was working as you showed (as expected :))

    Some questions:
    – how to ask for a confirmation before updating or deleting a record?
    – can I migrate SQL Server DB to SQLite (my database only has 25 records for now, not immediately growing)

Leave a Reply