Mappint 2 or more entities into 1 model (Not AutoMapper)

Guest User

I have 2 entities which the People and Contact

public class People{
[Key, DatabaseGenerated(DatabaseGeneratedOption.Identity)]
public Guid Id { get; set; }
public string FirstName { get; set; }
public string LastName { get; set; }
}
public class Contact{
[Key, DatabaseGenerated(DatabaseGeneratedOption.Identity)]
public Guid Id { get; set; }
public Guid PeopleId { get; set; }
public string Type { get; set; }
public string ContactNumber { get; set; }
}

and I have the model ContactModel to display the entity.

public class ContactModel{
public Guid Id { get; set; }
public Guid PeopleId { get; set; }
public string FirstName { get; set; }
public string LastName { get; set; }
public string Type { get; set; }
public string ContactNumber { get; set; }
}

my problem is when I'm trying to map the entities to model, I can only map the People entity or one entity and the the two entities.

public static ContactModel ToModel(this People people){
return new ContactModel{
Id = people.Id,
FirstName = people.FirstName,
LastName = people.LastName
};
}

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Gopaiah Nekarukanti6y ago
Accepted answer
try something like below

var result = Context.People.Include(p => p.Contact).ToList();

foreach (var people in result)
{
var peopleContact = people.ToModel();
}

+1
Gopaiah Nekarukanti6y ago
I think you need to write your extenstion method on this List peoples and need to change the logic and return List
public static ContactModel ToModel(this People people){
return new ContactModel{
Id = people.Id,
FirstName = people.FirstName,
LastName = people.LastName,
ContactId = people.Contact.Id,
Type = people.Contact.Type,
ContactNumber = people.Contact.ContactNumber
};
}
+1
Guest User6y ago
Thank You. it works. Follow up question..

Can we do the ToModel direct as a list like

var result = Context.People.Include(p => p.Contact).ToList().ToModel();

rather than doing a loop or foreach?

foreach (var people in result)
{
var peopleContact = people.ToModel();
}
0
Guest User6y ago
I'm having trouble because I'm having trouble in my query using the code below. Is there any missing on my code?
var contacts = Context.Contacts
join p in Context.People on c.PeopleId equals p.Id
foreach (var contact in contacts)
{
var c = contact.ToModel();
}
0
Gopaiah Nekarukanti6y ago
You can achieve that by changing your Entity class and model class like below.
public class People
{
[Key, DatabaseGenerated(DatabaseGeneratedOption.Identity)]
public Guid Id { get; set; }
public string FirstName { get; set; }
public string LastName { get; set; }
[ForeignKey("Contact")]
public Guid ContactId { get; set; }
public Contact Contact { get; set; }
}
public static ContactModel ToModel(this People people){
return new ContactModel{
Id = people.Id,
FirstName = people.FirstName,
LastName = people.LastName,
ContactId = people.Contact.Id,
Type = people.Contact.Type,
ContactNumber = people.Contact.ContactNumber
};
}
Reference link: https://www.entityframeworktutorial.net/code-first/configure-one-to-many-relationship-in-code-first.aspx
+1