One Bindinglist from multible DbSets to gridview

YouElz 1

Just wondering if it is possible to bind 2 DbSets to one data grid view leveraging BindingList.

public virtual DbSet<Candidate> Candidates { get; set; } = null!;  
public virtual DbSet<Candimmigration> Candimmigrations { get; set; } = null!

;

one-to-one relationship -> Candidate and Candimmigration;

public partial class Candidate  
{  
        [Key]  
        [Column("ID")]  
        public int Id { get; set; }  
        [StringLength(20)]  
        public string FirstName { get; set; } = null!;  
        [StringLength(20)]  
        public string? MiddleName { get; set; }  
        [StringLength(20)]  
        public string LastName { get; set; } = null!;  
        [Column(TypeName = "date")]  
        public DateTime? DateOfBirth { get; set; }  
  
        [InverseProperty("Candidate")]  
        public virtual Candimmigration Candimmigration { get; set; } = null!;  
}

I have the below code that I would like to convert into BindingList of 2 DbSets which bind to one grid view dgvCandidates.

var candiatesList = await _dbContext.Candidates  
    .Include(i => i.Candimmigration)  
    .Select(s => new  
    {  
      Id = s.Id,  
      FirstName = s.FirstName,  
      LastName = s.LastName,  
      DOB = s.DateOfBirth,  
      VisaNo = s.Candimmigration.VisaNo,  
      PassportNo = s.Candimmigration.PassportNo,  
    }).ToListAsync();  
     
dgvCandidates.DataSource = candiatesList;

AgaveJoe 26,191 Reputation points

2022-09-03T15:20:33.43+00:00

It takes at least two GridViews to display two separate DbSets. I could take more GridViews depending on your design. For example, if you're plan is to have a nested GridViews for each record in the main GridView.

Google Nested GridView for examples.

YouElz 1

@AgaveJoe , thank you for the response.
Even though if the second DbSet is a property of the first DbSet, one-to-one relationship -> Candidate and Candimmigration;

Candidate has a property of Candimmegration

 public partial class Candidate  
 {  
         [Key]  
         [Column("ID")]  
         public int Id { get; set; }  
         [StringLength(20)]  
         public string FirstName { get; set; } = null!;  
         [StringLength(20)]  
         public string? MiddleName { get; set; }  
         [StringLength(20)]  
         public string LastName { get; set; } = null!;  
         [Column(TypeName = "date")]  
         public DateTime? DateOfBirth { get; set; }  
      
         [InverseProperty("Candidate")]  
         public virtual Candimmigration Candimmigration { get; set; } = null!; // <-------------------------  
 }

AgaveJoe 26,191 Reputation points

2022-09-04T18:50:07.767+00:00

I have no idea what you're asking.

If you have a flat result set the just use the pattern in your first post to create the tabular layout you want. If you have two results sets then at least two GridViews are needed.
YouElz 1 Reputation point

2022-09-06T06:00:38.397+00:00
Apologies for any confusion, I am a newbie who just started to leanr EF and C# so I may not be familiar with the terminology

I have this below code which is working just fine. Basically creating a list of specific properties from the Candidate DbSet and "Include" Candimmigration and assigning it to the grid view DataSource.

However, this approach is not binding, so every time I change a record I have to call the below code to reload/refresh the data grid view, which I don't believe is ideal.

var candiatesList = await _dbContext.Candidates .Include(i => i.Candimmigration) .Select(s => new { Id = s.Id, FirstName = s.FirstName, LastName = s.LastName, DOB = s.DateOfBirth, VisaNo = s.Candimmigration.VisaNo, PassportNo = s.Candimmigration.PassportNo, MobileNo = s.MobileNumber, Status = s.Status, }) .ToListAsync(); dgvCandidates.DataSource = candiatesList;

I was able to create a binding list just for the Candidate using the below code:

_dbContext.Candidates.Load(); dgvCandidates.DataSource = _dbContext.Candidates.Local.ToBindingList();

But the above code shows all the properties of the Candidate in DGV, even if tried to hide the columns, I still can't reference for example the property of VisaNo and PassportNo in Candimmigration.
AgaveJoe 26,191 Reputation points

2022-09-06T13:33:52.097+00:00

What kind of application are you building? Desktop? Web?
YouElz 1 Reputation point

2022-09-30T07:29:14.33+00:00

Apologies for the late reply... I am building a Desktop application.