我正在使用實(shí)體框架。我的數(shù)據(jù)庫(kù)客戶(hù)和發(fā)票中有 2 個(gè)表。發(fā)票表有一列 CustomerID 作為外鍵引用客戶(hù)。我正在使用DataGrid具有以下列的一個(gè)，如圖所示。這DataGrid應(yīng)該顯示來(lái)自發(fā)票表的數(shù)據(jù)和來(lái)自客戶(hù)表的客戶(hù)名稱(chēng)。請(qǐng)幫我如何查詢(xún)這個(gè)？數(shù)據(jù)網(wǎng)格<DataGrid IsReadOnly="False" Margin="0 10 0 0" Background="white" Name="InvoiceGrid" AutoGenerateColumns="False"> <DataGrid.Columns> <DataGridTextColumn Header="Invoice ID" IsReadOnly="True" MinWidth="100"/> <DataGridTextColumn Header="Date" IsReadOnly="True" MinWidth="100" /> <DataGridTextColumn Header="Customer" IsReadOnly="True" MinWidth="250" /> <DataGridTextColumn Header="Quantity" IsReadOnly="True" MinWidth="80" /> <materialDesign:MaterialDataGridTextColumn IsReadOnly="True" Header="Total" MinWidth="150" /> 上下文類(lèi)public partial class Intelliventory_DBEntities : DbContext{ public Intelliventory_DBEntities() : base("name=Intelliventory_DBEntities") { } protected override void OnModelCreating(DbModelBuilder modelBuilder) { throw new UnintentionalCodeFirstException(); } public virtual DbSet<Category> Categories { get; set; } public virtual DbSet<Customer> Customers { get; set; } public virtual DbSet<Employee> Employees { get; set; } public virtual DbSet<Invoice> Invoices { get; set; } public virtual DbSet<InvoiceItem> InvoiceItems { get; set; } public virtual DbSet<Product> Products { get; set; } public virtual DbSet<Purchase> Purchases { get; set; } public virtual DbSet<Supplier> Suppliers { get; set; } public virtual DbSet<sysdiagram> sysdiagrams { get; set; }}
1 回答
回首憶惘然
TA貢獻(xiàn)1847條經(jīng)驗(yàn) 獲得超11個(gè)贊
如果Customer是 的導(dǎo)航屬性Invoice，您可以使用預(yù)先加載來(lái)加載它，例如：
var context = new Intelliventory_DBEntities();
InvoiceGrid.ItemsSource = context.Invoices.Include(x => x.Customer).ToList();
//...
context.Dispose();
然后，您可以將該列綁定到導(dǎo)航屬性：
<DataGridTextColumn Header="Invoice ID" Binding="{Binding InvoiceID}" IsReadOnly="True" MinWidth="100"/>
<DataGridTextColumn Header="Date" Binding="{Binding Date}" IsReadOnly="True" MinWidth="100" />
<DataGridTextColumn Header="Customer" Binding="{Binding Customer.CustomerName}" IsReadOnly="True" MinWidth="250" />
- 1 回答
- 0 關(guān)注
- 201 瀏覽
添加回答
舉報(bào)
0/150
提交
取消