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}!");
}
}
}
}
这样写:
Data Source=c:\mydb.db;Version=3;Password=myPassword;