local variable anonymous type how to resolve this issue.

Any Expert can resolve this problem.

public class productviewModel
{
public Product listProducts { get; set; }
public List listProductDetails { get; set; }
}

function

public ProductViewModel GetProductByID(int ID)
{
ProductViewModel listprod = new ProductViewModel();
try
{
var productsl = (from p in _db.Products
where p.ProductID == ID
select new
{
p.PName,
p.PDescription,
p.Model,
p.Condition,
p.UnitPrice,
p.ManificturedPrice,
p.Discount,
p.UnitWeight,
p.UnitInStock
}).FirstOrDefault();
var productD = (from pd in _db.ProductDetails
join b in _db.Products on pd.ProductID equals b.ProductID
where pd.ProductID == ID
select new
{
pd.ProductID,
pd.OS,
pd.ProcessorType,
pd.RAM,
pd.ScreenSize,
pd.TouchScreen,
pd.BatteryLife,
pd.Camera
}).ToList();
listprod.listProducts = productsl;
listprod.listProductDetails = productD;
return listprod;
}
catch (Exception)
{
throw;
}
}

Error

productsl

productD

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Amit Mohanty6y ago
Accepted answer
Try this in your model class.
public List listProducts = new List();
public List listProductDetails = new List();
0
Ravi Patel6y ago
1. var productsl = (from p in _db.Products
2. where p.ProductID == ID
3. select new Product
4. {
5. PName=p.PName,
6. // same way for other propert
8. }).FirstOrDefault();
9. var productD = (from pd in _db.ProductDetails
10. join b in _db.Products on pd.ProductID equals b.ProductID
11. where pd.ProductID == ID
12. select new ProductDetail
13. {
14. ProductID=pd.ProductID
15. // same way for other property
17. }).ToList();
18. listprod.listProducts = productsl;
19. listprod.listProductDetails = productD;
20. return listprod;
1. //here is the complete code
2. public class Product
3. {
4. // all your property
5. }
6. public class ProductDetail
7. {
8. //all your property
9. }
10. public class ProductViewModel
11. {
12. public Product products{get;set;}
13. public ListProductDetails{get;set;}
14. }
15. //final code
16. public ProductViewModel GetProductByID(int ID)
17. {
18. try
19. {
20. var product = (from p in _db.Products
21. where p.ProductID == ID
22. select new Product
23. {
24. PName= p.PName,
25. // same way for other property
26. }).FirstOrDefault();
27. var productDetail = (from pd in _db.ProductDetails
28. join b in _db.Products on pd.ProductID equals b.ProductID
29. where pd.ProductID == ID
30. select new ProductDetail
31. {
32. ProductID= pd.ProductID,
33. // same way for other property
34. }).ToList();
35. return new ProductViewModel{products= product, ProductDetails=productDetail };
36. }
0