/C#/Query into complex object using dapper

Query into complex object using dapper

public class Customer {
    public int Id { get; set; }
    public string Name { get; set; }
    public int AddressId { get; set; }  
    public int ContactId { get; set; }
    public Address Address { get; set; }
    public Contact Contact { get; set; }
}

public class Address {
    public int Id { get; set; }
    public string Address1 {get;set;}
    public string Address2 {get;set;}
    public string City {get;set;}
    public string State {get;set;}
    public int ZipCode {get;set;}
    public IEnumerable<Customer> Customer {get;set;}
}

public class Contact {
    public int Id { get; set; }
    public string Name { get; set; }
    public IEnumerable<Customer> Customer {get;set;}
}

using (var conn = GetOpenConnection())
{
    var query = _contextDapper
        .Query<Customer, Address, Contact, Customer>($@"
            SELECT c.Id, c.Name, 
                c.AddressId, a.Id, a.Address1, a.Address2, a.City, a.State, a.ZipCode,
                c.ContactId, ct.Id, ct.Name
            FROM Customer c
            INNER JOIN Address a ON a.Id = c.AddressId
            INNER JOIN Contact ct ON ct.Id = c.ContactId", 
            (c, a, ct) =>
            {
                c.LogType = a;
                c.Contact = ct;
                return c; 
            }, splitOn: "AddressId, ContactId")
        .AsQueryable();

    return query.ToList();          
}

Source: dapper-tutorial.net

Similar codes

-1 vote160 views1 answer
Task w = Task.Delay(600);w.Wait();new Program().Start();
C#
0 vote146 views2 answers
How to show a first item in a combobox in c# winforms
C#
0 vote155 views1 answer
How to keep line breaks in SQL Server using ASP.NET and C#?
C#
0 vote166 views1 answer
Why Duplicate "..TargetFrameworkAttribute" c# assemblies created
C#
0 vote189 views1 answer
LINQ query on a DataTable C#
C#
1 vote138 views1 answer
C# xpath read attribute value
C#
0 vote265 views1 answer
Unity C# add torque to rigidbody
C#Unity
1 vote147 views1 answer
C# hex to console color
C#
-1 vote152 views1 answer
Access audio source from gameobject unity
C#
0 vote133 views1 answer
Linq query to fetch parent child data from same table in c#
C#