如何使用C#和SQLite进行本地数据库开发？步骤是什么？

using Microsoft.Data.Sqlite;

var connectionString = "Data Source=app.db";
using var connection = new SqliteConnection(connectionString);
connection.Open();

var command = connection.CreateCommand();
command.CommandText = @"
    CREATE TABLE IF NOT EXISTS Users (
        Id INTEGER PRIMARY KEY AUTOINCREMENT,
        Name TEXT NOT NULL,
        Email TEXT UNIQUE
    )";
command.ExecuteNonQuery();

command.CommandText = "INSERT INTO Users (Name, Email) VALUES (@name, @email)";
command.Parameters.AddWithValue("@name", "张三");
command.Parameters.AddWithValue("@email", "zhangsan@example.com");
command.ExecuteNonQuery();

command.CommandText = "SELECT Id, Name, Email FROM Users";
using var reader = command.ExecuteReader();

while (reader.Read())
{
    Console.WriteLine($"ID: {reader["Id"]}, 名字: {reader["Name"]}");
}

command.CommandText = "UPDATE Users SET Name = @newName WHERE Email = @email";
command.Parameters.AddWithValue("@newName", "李四");
command.Parameters.AddWithValue("@email", "zhangsan@example.com");
command.ExecuteNonQuery();

public class User
{
    public int Id { get; set; }
    public string Name { get; set; }
    public string Email { get; set; }
}

public class AppDbContext : DbContext
{
    public DbSet<User> Users { get; set; }
    protected override void OnConfiguring(DbContextOptionsBuilder options)
        => options.UseSqlite("Data Source=app.db");
}

using var db = new AppDbContext();
db.Users.Add(new User { Name = "王五", Email = "wangwu@example.com" });
db.SaveChanges();