Locating SQLite file on Azure after publishing WebAPI

Question

Hello,

I have developed an API that relies on an SQLite database to function correctly. When working with the API locally, I can easily locate and specify the file path in my DbContext class.

However, the challenge arises when I publish the application, as I am uncertain about the location of the SQLite file and how to effectively locate it in the deployed environment on Azure.

Answer 1

Hey @Sinzore

When you deploy your site, the contents are deployed to home/site/wwwroot. Depending on where your db file is, it would be relative to that directory. Have a look at Understanding the Azure App Service file system to learn more.

However, I will caution that you it is not recommended to use this file to store any application related data. Sqlite utilizes file handles and locks so if you were to ever scale your application, you could run into lock contention.