没设置数据库密码时,明明能正常跑起来,加上密码就不行了还一直说这不是一个数据库

    private static void Opendb()
    {
        var connectionString = new SqliteConnectionStringBuilder(@"Data Source=C:\Users\2\Desktop\ppt材料\test4.db")
        {
            Mode = SqliteOpenMode.ReadWriteCreate,
            Password = "123"
        }.ToString();

        using (var connection = new SqliteConnection(connectionString))
        {

            connection.Open();
            var command = connection.CreateCommand();
            command.CommandText =
            @"
                 SELECT name
                 FROM user
                 WHERE id = $id
             ";
            command.Parameters.AddWithValue("$id", 2);

            using (var reader = command.ExecuteReader())
            {
                while (reader.Read())
                {
                    var name = reader.GetString(0);

                    Console.WriteLine($"Hello, {name}!");
                }
            }
        }
    }

img

这样写:

Data Source=c:\mydb.db;Version=3;Password=myPassword;