Breaking News: Grepper is joining You.com. Read the official announcement!

tables join in entity core

Islam answered on April 7, 2022 Popularity 9/10 Helpfulness 4/10

answer tables join in entity core

tables join in entity core

Comment

var query = context.Customers
    .Join(
        context.Invoices,
        customer => customer.CustomerId,
        invoice => invoice.Customer.CustomerId,
        (customer, invoice) => new
        {
            InvoiceID = invoice.Id,
            CustomerName = customer.FirstName + "" + customer.LastName,
            InvoiceDate = invoice.Date
        }
    ).ToList();

foreach (var invoice in query)
{
    Console.WriteLine("InvoiceID: {0}, Customer Name: {1} " + "Date: {2} ",
        invoice.InvoiceID, invoice.CustomerName, invoice.InvoiceDate);
}

Popularity 9/10 Helpfulness 4/10 Language whatever

Source: entityframeworkcore.com

Tags: core entity join whatever

Link to this answer
Share Copy Link