Querying into a complex object with sqlkata

Question

Querying into a complex object with sqlkata

dapper sqlkata

Question

I cant built a complex object with a query. How I do?

public class Person
{
    public long Id { get; set; }
    public string Name { get; set; }
    public Contact Contact { get; set; }
}

public class Contact
{
    public long Id { get; set; }
    public string FoneNumber { get; set; }
}

VFB

View more on Stack Overflow

amd · Accepted Answer · 8/27/2018 1:13:08 PM

As you have wrote before, use the Join Method to join with the "Contact" table,

var row = db.Query("Person")
            .Select(
                "Person.Id",
                "Person.Name",
                "Contact.Id as ContactId",
                "Contact.FoneNumber as FoneNumber"
            )
            .Join("Contact", "Person.Id", "Contact.PersonId")
            .Where("Person.Id", 1)
            .FirstOrDefault();

Querying into a complex object with sqlkata

Question

Fastest Dapper Plus Extensions

Popular Answer

Performance

Expression Evaluator