public List <TestModel> GetAllTest2()
{
using (var db = new ContosoDbContext())
{
//var res = from test4 in db.Test4
// join test2 in db.Test2
// on test4.Test2Id equals test2.Id
// into MatchedOrders
// from mo in MatchedOrders.DefaultIfEmpty()
// select new { test4.NameOf, mo.Name, };
var res = (from test4 in db.Test4
join test2 in db.Test2
on test4.Test2Id equals test2.Id
into MatchedOrders
from mo in MatchedOrders.DefaultIfEmpty()
select new TestModel()
{
Id = test4.Id,
NameOf = test4.NameOf,
Name = mo.Name
}).ToList();
return(res);
}
}
public void AddExchangingOrder(int orderId)
{
var orders = MatchedOrders?.ToList() ?? new List <int>();
orders.Add(orderId);
MatchedOrders = orders.ToArray();
}
