C#

using Newtonsoft.Json;

string productId = string.Empty;  // ** Init this not Empty
List<prodDetails> productionDetails = GetProductDetails(productId);
string ProductDetailsJSON = Newtonsoft.Json.JsonConvert.SerializeObject(productionDetails);
return ProductDetailsJSON;

Liagapi wrote:

At the moment I can only get a list which contains data from one table instead of all three tables.

Liagapi wrote:

I would like the list to contain employee, project, and product.

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

Liagapi wrote:

IEnumerable<Employee> emps = db.Employees.ToList();
IEnumerable<Project> projs= db.Projects.ToList();
IEnumerable<Product> prods = db.Products.ToList();

Liagapi wrote:

string productId
where prd.productID == Convert.ToInt32(productId)

Liagapi wrote:

public List<string> GetProductDetails

Liagapi wrote:

join prj in projs on e.EmployeeID equals prj.ProjectID
join prd in prods on e.EmployeeID equals prd.productID

public sealed class ProductDetails
{
    public string employee { get; set; }
    public string project { get; set; }
    public string product { get; set; }
}
...
public List<ProductDetails> GetProductDetails(int productId)
{
    using (var db = new ProductContext())
    {
        var productDetails = from e in db.Employees
                             join prj in db.Projects on e.EmployeeID equals prj.ProjectID // Is this the correct join?
                             join prd in prods on e.EmployeeID equals prd.productID // Is this the correct join?
                             where prd.productID == productId
                             select new { e.EmployeeName, prj.ProjectName, prd.ProductName };
        
        return productDetails.AsEnumerable().Select(x => new ProductDetails
        {
            employee = x.EmployeeName,
            project = x.ProjectName,
            product = x.ProductName
        }).ToList();
    }
}

System.Windows.Input.Mouse.OverrideCursor = Cursors.None;

TNCaver wrote:

But it returns False. Why?