使用c#从Sqlite表中获取特定客户的值之和

using System.Data.SQLite;

string connectionString = "Data Source=path_to_your_database.db;Version=3;";
SQLiteConnection connection = new SQLiteConnection(connectionString);
connection.Open();

string sql = "SELECT SUM(value) FROM your_table WHERE customer = @customer";
SQLiteCommand command = new SQLiteCommand(sql, connection);
command.Parameters.AddWithValue("@customer", "your_customer_name");

object result = command.ExecuteScalar();

if (result != null && result != DBNull.Value)
{
    decimal sum = Convert.ToDecimal(result);
    // 处理结果
}

connection.Close();