ASP.NET CORE Web App throwing SQLiteException: unable to open database file

Question

I have an SQLite DB and I uploaded it to my server [hosted in azure]. But when I try to access it, It throws SQLiteException: unable to open database file.

My connection string is something like this -

string connectionString = "Data Source=https:\\mywebsite.azurewebsites.net\\DB\\persondb.db; Version=3"

I also tried this too -

string connectionString = "Data Source=~/DB/persondb.db; Version=3";

Here is my full method's code -

        public static List<PersonDetails> GetPersons()
        {
            // string connectionString = "Data Source=https:\\mywebsite.com\\DB\\persondb.db; Version=3";
            string connectionString = "Data Source=~/DB/persondb.db; Version=3";

            using (IDbConnection cnn = new SQLiteConnection(connectionString))
            {
                var output = cnn.Query<PersonDetails>
                    ("SELECT * FROM persons",
                    new DynamicParameters());
                return output.ToList();
            }
        }

How can I resolve this issue?

The connection string is wrong It should be a local path rather than URL — Thiago Custodio
– Thiago Custodio, Commented Apr 5, 2020 at 21:51

Jack Jia · Accepted Answer · 2020-04-06 02:01:45Z

1

Refer to About SQLite

SQLite is an embedded SQL database engine. Unlike most other SQL databases, SQLite does not have a separate server process. SQLite reads and writes directly to ordinary disk files.

You may use the following code in your ASP.NET web project:

    string path = Server.MapPath("~/DB");
    string connectionString = $"Data Source={path}/demo.db; Version=3";

    using (var con = new SQLiteConnection(connectionString))
    {
        con.Open();
        var cmd = new SQLiteCommand("SELECT SQLITE_VERSION()", con);
        return cmd.ExecuteScalar().ToString();
    }

The code Server.MapPath("~/DB") will find the physical path of the DB folder in your project, and then the connection string should be work.

answered Apr 6, 2020 at 2:01

Jack Jia

5,5391 gold badge14 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Mahmudul Hasan Over a year ago

Hi! Your answer clears something but It actually isn't correct. Server.MapPath doesn't work in ASP.NET Core. IWebHostEnvironment can be used as an alternative. Thanks, BTW.

Mahmudul Hasan · Accepted Answer · 2020-04-06 06:30:29Z

1

Jack Jia's answer clears the scenario. But since Server.MapPath doesn't work in ASP.NET Core, we can get the server root path via IWebHostEnvironmentinterface.

This problem can be resolved like this -

Create a string that can be accessed globally [e.g. internal static string rootpath;]
In startup.cs file, assign rootpath in the method public void Configure(IApplicationBuilder app, IWebHostEnvironment env) [e.g. Program.rootpath = env.WebRootPath;]
Now a valid connection string should look like this - string connectionString = $"Data Source={Program.rootpath}/DB/demo.db; Version=3";

answered Apr 6, 2020 at 6:30

Mahmudul Hasan

8322 gold badges15 silver badges37 bronze badges

Comments

dynamiclynk · Accepted Answer · 2022-06-24 21:15:10Z

0

This worked for me .Net 6

Program.cs

var builder = WebApplication.CreateBuilder(args);

// Add services to the container.
var services = builder.Services;
GlobalContext.ApplicationRootPath = Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location)??"";

appSettings.json

"DefaultConnection": "DataSource={dbPath}\\SqlLite\\app.db;Cache=Shared",

Usage:

var connectionString = connectionString.Replace("{dbPath}", GlobalContext.ApplicationRootPath);
                    options.UseSqlite(connectionString, sqlLiteOptions =>
                    {
                        sqlLiteOptions.MigrationsAssembly("MyAssembly");
                    });

answered Jun 24, 2022 at 21:15

dynamiclynk

2,3311 gold badge28 silver badges31 bronze badges

Collectives™ on Stack Overflow

ASP.NET CORE Web App throwing SQLiteException: unable to open database file

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related