阻止数据网格在C#中加载实体框架导航属性

Question

我有一个数据库(具体来说是火鸟，但我认为问题与EF有关(。我已经使用数据库中的代码优先生成了代码文件。例如，为驱动程序生成的代码是：

[Table("Firebird.DRIVER")]
public partial class DRIVER
{
[System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2214:DoNotCallOverridableMethodsInConstructors")]
public DRIVER()
{
FAREs = new HashSet<FARE>();
//..... and other code generated for the other collections
}

[DatabaseGenerated(DatabaseGeneratedOption.Identity)]
[Key]
public int DRIVERID { get; set; }
[StringLength(100)]
public string FULLNAME { get; set; }
//... and other properties

public int? EQUIPMENTID { get; set; }
public virtual EQUIPMENT EQUIPMENT { get; set; }
[System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")]
public virtual ICollection<FARE> FAREs { get; set; }
//.... and other code generated for the other collections
}

我有一个带有DataGridView的基本表单。DataGridView的目的是编辑、添加或删除新实体(驱动程序(。我这样绑定

private async Task BindGrid()
{
var DBContext = AppVariables.CreateContext();
await Task.Run(() => DBContext.DRIVERs.Load());
var bindingSource = DBContext.DRIVERs.Local.ToBindingList();
dataGridView1.DataSource = bindingSource;
}

然而，我在我的网格中得到了导航属性(例如EQUIPMENT(。我可以做些什么来删除在网格中加载的导航属性。我应该先从代码中删除导航属性吗？或者还有其他方法可以在不加载导航属性的情况下将数据加载到网格中？

我试图只使用属性来创建对象，并避免导航，但网格是不可编辑的

private async Task BindGrid()
{
var list = from driver in DBContext.DRIVERs
select new
{
DRIVERID = destination.DRIVERID
//...
};
await list.LoadAsync();
var bindingSource = list.ToBindingList();
dataGridView1.DataSource = bindingSource;
}

Answer 1

加载导航属性和显示它们是两个不同的主题。

防止加载

禁用延迟加载，只包含那些需要的导航属性

var db = new MyDbContext(); 
db.Configuration.LazyLoadingEnabled = false; 
data = db.MyEntity.Local.ToBindingList();

阻止显示

用[Browsable(false)]修饰导航属性。

[Browsable(false)]
public virtual EQUIPMENT EQUIPMENT { get; set; }

或

将列可见性设置为false：

dataGridView1.Columns["EQUIPMENT"].Visible = false

或

首先，使用设计器或代码为DataGridView定义一组列。然后DataGridView将只显示您定义的列：

var DRIVERIDColumn = new DataGridViewTextBoxColumn();
DRIVERIDColumn.Name = "DRIVERID";
DRIVERIDColumn.HeaderText = "Id";
DRIVERIDColumn.DataPropertyName= "DRIVERID";
// ...
dataGridView1.Columns.AddRange(DRIVERIDColumn /*...*/);
// ...