От: | Naf2000 | ||
Дата: | 28.09.21 14:14 | ||
Оценка: |
[Table("Partners")]
class Partner
{
[PrimaryKey, Identity]
public long ID { get; set; }
[Column]
public string Name { get; set; }
}
[Table("Orders")]
class Order
{
[PrimaryKey, Identity]
public long ID { get; set; }
[Column]
public string Number { get; set; }
[Association(ThisKey = "Partner", OtherKey = "ID")]
public Partner Partner { get; set; }
}
var query = db.GetTable<Order>().Select(_=>_.Partner.Name);
var list = query.ToList();