问使用SQLite-Net扩展使用数据库表之间关系的方法

EN

public class Stock
    {
        [PrimaryKey, AutoIncrement]
        public int Id { get; set; }
        [MaxLength(8)]
        public string Symbol { get; set; }
    }

    public class Valuation
    {
        [PrimaryKey, AutoIncrement]
        public int Id { get; set; }
        [Indexed]
        public int StockId { get; set; }
        public DateTime Time { get; set; }
        public decimal Price { get; set; }
    }

 var Query = (connection.Table<Valuation>().Where(
               c => c.StockId == StockItem.ID)).ToList();