SqlDataReader how to bind Inner join data to object

Question

Currently I'm trying to combine two database tabels with a join

After that I looping through the reader and create an Appointment Object foreach row that returned from the query. That Appointment object is added to a list.

The problem is when I start my program. The user data is not binded to the Customer object. Customer is still null here, but the customer data is added with the join.

How can I fix this issue? So that the Customer data that comes from the join is added to that Customer Model object.

Soo.. where's the bit of your code that looks like appointments.Add(new Appointment { ... Customer = new Customer( CustomerId = int.Parse( reader["CustomerId"])) ? — Caius Jard
– Caius Jard, Commented Mar 19, 2022 at 19:20
Please do not post images of code or data, paste them in as text. Please use images ony for things that cannot be shown as text — Charlieface
– Charlieface, Commented Mar 19, 2022 at 20:55
Side point: you need using blocks for your connection, command and reader objects — Charlieface
– Charlieface, Commented Mar 19, 2022 at 20:55

Ezaldden Almaghout · Accepted Answer · 2022-03-20 02:10:50Z

0

Looking at your screenshots, I can't see explicit binding for cutomer-related fields. And to understand the logic well, the list of appointments should have some sort of Customer object that u need to initialize while looping the reader.

appointments.add(new Appointment{
  Customer = new Customer{
    customerId = reader["Customers.CustomerId"]
    .
    .
    .
  },
  AppointmentId = reader["AppointmentId"],
  .
  .
  .
}

answered Mar 20, 2022 at 2:10

Ezaldden Almaghout

711 gold badge1 silver badge6 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SqlDataReader how to bind Inner join data to object

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related