2. Join

@page "/study/join"
@using Microsoft.EntityFrameworkCore
@using RarareteApp.Data
@inject IDbContextFactory<DemoDbContext> _dbContextFactory


@code {
    private List<ResultModel> list = new List<ResultModel>();
    protected override async Task OnInitializedAsync()
    {
        using (var context = _dbContextFactory.CreateDbContext())
        {
            try
            {
                var result =await (from a in context.BOMs
                                    join b in context.Items on a.SubCode equals b.ItemCode
                                    select new ResultModel
                                  {
                                      SubCode = a.SubCode,
                                      SubName = b.ItemName,
                                      Cost = b.UnitPrice
                                  }
                 ).ToListAsync();

                foreach (var i in result)
                {
                    Console.WriteLine(i.SubCode + " " + i.SubName + " 단가:  " + i.Cost);
                }

            }
            catch (Exception ex)
            {
                Console.WriteLine("오류 : ", ex);
               // return null;
            }


        }

    }

    public class ResultModel
    {
        public String? SubCode { get; set; }
        public String? SubName { get; set; }
        public Decimal? Cost  { get; set; }
    }

}