使用SQLite在Xamarin.Forms中显示DateTime

using SQLite;

public class DatabaseHelper
{
    private SQLiteConnection _connection;

    public DatabaseHelper(string dbPath)
    {
        _connection = new SQLiteConnection(dbPath);
        _connection.CreateTable<MyModel>(); // 创建表
    }

    public void InsertData(MyModel model)
    {
        _connection.Insert(model); // 插入数据
    }

    public List<MyModel> GetAllData()
    {
        return _connection.Table<MyModel>().ToList(); // 获取所有数据
    }
}

public class MyModel
{
    [PrimaryKey, AutoIncrement]
    public int Id { get; set; }

    public DateTime MyDateTime { get; set; }
}

<ListView x:Name="myListView">
    <ListView.ItemTemplate>
        <DataTemplate>
            <TextCell Text="{Binding MyDateTime}" />
        </DataTemplate>
    </ListView.ItemTemplate>
</ListView>

public partial class MainPage : ContentPage
{
    private DatabaseHelper _databaseHelper;

    public MainPage()
    {
        InitializeComponent();

        string dbPath = Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.LocalApplicationData), "mydatabase.db");
        _databaseHelper = new DatabaseHelper(dbPath);
    }

    protected override void OnAppearing()
    {
        base.OnAppearing();

        List<MyModel> dataList = _databaseHelper.GetAllData();
        myListView.ItemsSource = dataList;
    }
}