以下是一个简化的示例，展示如何在MAUI项目中使用SQLite来存储和检索购物车数据。
首先，需要在项目中添加一个模型来表示购物车项：
public class CartItem
{
[PrimaryKey, AutoIncrement]
public int Id { get; set; }
public string ProductId { get; set; }
public string ProductName { get; set; }
public decimal Price { get; set; }
public int Quantity { get; set; }
}然后，创建一个数据库上下文类：
public class CartDatabase
{
public SQLiteAsyncConnection Database { get; }
public CartDatabase(string dbPath)
{
Database = new SQLiteAsyncConnection(new SQLite.SQLiteConnectionString(dbPath, true));
Database.CreateTableAsync<CartItem>().Wait();
}
public Task<List<CartItem>> GetCartItemsAsync()
{
return Database.Table<CartItem>().ToListAsync();
}
public Task<int> AddCartItemAsync(CartItem item)
{
return Database.InsertAsync(item);
}
public Task<int> UpdateCartItemAsync(CartItem item)
{
return Database.UpdateAsync(item);
}
public Task<int> DeleteCartItemAsync(CartItem item)
{
return Database.DeleteAsync(item);
}
}最后，在MAUI应用中使用这个数据库：
public partial class MainPage : ContentPage
{
private CartDatabase cartDb;
public MainPage()
{
InitializeComponent();
cartDb = new CartDatabase(Path.Combine(FileSystem.AppDataDirectory, "cart.db3"));
// ...
}
private async void AddToCartButton_Clicked(object sender, EventArgs e)
{
var cartItem = new CartItem
{
ProductId = "123",
ProductName = "Sample Product",
Price = 99.99m,
Quantity = 1
};
await cartDb.AddCartItemAsync(cartItem);
// ...
}
private async void LoadCartButton_Clicked(object sender, EventArgs e