1. 确保SQLite数据库文件已正确部署到web服务器的正确位置。
2. 在项目中添加SQLite包NuGet包。
3. 使用SQLiteConnectionStringBuilder创建与SQLite数据库的连接字符串。

using Microsoft.Data.Sqlite;

public class SqliteService
{
    private readonly SqliteConnection _connection;

    public SqliteService(string connectionString)
    {
        var connectionStringBuilder = new SqliteConnectionStringBuilder(connectionString);
        _connection = new SqliteConnection(connectionStringBuilder.ConnectionString);
    }

    public void Open() => _connection.Open();

    public void Close() => _connection.Close();

    public void ExecuteSqlCommand(string commandText)
    {
        var command = _connection.CreateCommand();
        command.CommandText = commandText;
        command.ExecuteNonQuery();
    }
}

//在页面中创建sqlite服务的实例，在需要的时候打开并关闭连接，调用ExecuteSqlCommand执行命令。

@page "/"

@inject SqliteService SqliteService

Add Data


@code {
    private void AddData()
    {
        SqliteService.Open();

        SqliteService.ExecuteSqlCommand("INSERT INTO MyTable (Column1, Column2) VALUES ('Value1', 'Value2')");

        SqliteService.Close();
    }
}