Xamarin新手求助：主详情页集成SQLite出现空异常

Hey there! As a fellow Xamarin developer, I’ve run into this exact SQLite null reference issue a few times when setting up Master-Detail pages—let’s break down what’s likely going wrong and how to fix it.

Common Causes & Fixes #

1. Your SQLHelper.Connection isn’t initialized before use #

The most probable culprit is that SQLHelper.Connection is still null when GetAccountsAsync() runs in your AccountsView constructor. Master-Detail page navigation can sometimes load child pages before your global database helper is fully set up.

Here’s how to fix this by adding initialization checks directly in your database call:

private async Task GetAccountsAsync() // Switch to Task return type for better async practices
{
    // Initialize the connection if it's null
    if (SQLHelper.Connection == null)
    {
        // Replace with your actual database file name
        SQLHelper.Connection = new SQLiteAsyncConnection("AccountsDatabase.db3");
        // Make sure your Account table is created before querying
        await SQLHelper.Connection.CreateTableAsync<Account>();
    }

    var accounts = await SQLHelper.Connection.Table<Account>().ToListAsync();
    lvwAccounts.ItemsSource = accounts;
}

2. Database call is running too early in the page lifecycle #

Xamarin.Forms executes the page constructor before the page is fully attached to the navigation stack. Moving your database logic to the OnAppearing method ensures the page is ready to interact with resources like databases:

public partial class AccountsView : ContentPage 
{
    public AccountsView() 
    {
        InitializeComponent();
        // Remove GetAccountsAsync() from the constructor
    }

    protected override async void OnAppearing()
    {
        base.OnAppearing();
        await GetAccountsAsync(); // Call it here instead
    }

    private async Task GetAccountsAsync()
    {
        // Same initialization and query logic as above
        if (SQLHelper.Connection == null)
        {
            SQLHelper.Connection = new SQLiteAsyncConnection("AccountsDatabase.db3");
            await SQLHelper.Connection.CreateTableAsync<Account>();
        }

        var accounts = await SQLHelper.Connection.Table<Account>().ToListAsync();
        lvwAccounts.ItemsSource = accounts;
    }

    async void Handle_Clicked(object sender, System.EventArgs e) 
    {
        var account = (Account)((Button)sender).BindingContext;
        // Rest of your click logic here
    }
}

3. Double-check your SQLite NuGet packages #

Make sure you have the correct SQLite packages installed in all your projects (shared, Android, iOS):

• Recommended packages: sqlite-net-pcl (for async support) and SQLitePCLRaw.bundle_green (for native platform bindings)
• Avoid mixing different SQLite packages—this can cause unexpected null references or connection issues.

Quick Additional Tip #

If you’re using a static SQLHelper class, consider making it a singleton to ensure only one connection instance is created throughout your app. This prevents connection leaks and ensures consistency:

public static class SQLHelper
{
    private static SQLiteAsyncConnection _connection;
    public static SQLiteAsyncConnection Connection
    {
        get
        {
            if (_connection == null)
            {
                _connection = new SQLiteAsyncConnection("AccountsDatabase.db3");
                // You can also create tables here once
                _connection.CreateTableAsync<Account>().Wait();
            }
            return _connection;
        }
    }
}

内容的提问来源于stack exchange，提问作者Guy