[Solved] Convert SQL Query To LINQ?

by


I didn’t test it, but it should look something like that :

var query = (from s in Suppliers 
             select new 
             {
                 SupplierId = s.SupplierId,
                 CompanyName = s.CompanyName,
                 ContactPerson = s.ContactPerson,
                 Address = s.Address,
                 Email = s.Email,
                 InActive = s.InActive,
                 BranchId = s.BranchId,
                 CreateDate = s.CreateDate,
                 CreatedBy = s.CreatedBy,
                 UpdateDate = s.UpdateDate,
                 UpdateBy = s.UpdatedBy,
                 PhoneNumber = s.PhoneNumber,
                 Balance = SupplierTransactions
                          .Where(st => st.SupplierId == s.SupplierId)
                          .Select(st => (st.CreditAmount - st.DebitAmount))
                          .Sum()
             });

1

solved Convert SQL Query To LINQ?