If Else in LINQ

by

This might work…

from p in db.products
    select new
    {
        Owner = (p.price > 0 ?
            from q in db.Users select q.Name :
            from r in db.ExternalUsers select r.Name)
    }

More Related Contents:

  1. Returning IEnumerable vs. IQueryable
  2. Return anonymous type results?
  3. How can I conditionally apply a Linq operator?
  4. LINQ to SQL – Left Outer Join with multiple join conditions
  5. How to do a subquery in LINQ?
  6. LINQ to SQL and a running total on ordered results
  7. Understanding .AsEnumerable() in LINQ to SQL
  8. TransactionScope vs Transaction in LINQ to SQL
  9. How to return anonymous type from c# method that uses LINQ to SQL [duplicate]
  10. LINQ: combining join and group by
  11. How to write Asynchronous LINQ query?
  12. Convert Linq Query Result to Dictionary
  13. Am I misunderstanding LINQ to SQL .AsEnumerable()?
  14. How do you perform a CROSS JOIN with LINQ to SQL?
  15. LINQ Where Ignore Accentuation and Case
  16. Operation could destabilize the runtime?
  17. How to select only the records with the highest date in LINQ
  18. Linq query with nullable sum
  19. Custom Method in LINQ to SQL query
  20. LINQ to SQL using GROUP BY and COUNT(DISTINCT)
  21. LINQ Expression to return Property value?
  22. Max or Default?
  23. Will using LINQ to SQL help prevent SQL injection
  24. How do I do a left outer join with Dynamic Linq?
  25. Get sum of two columns in one LINQ query
  26. Last and LastOrDefault not supported
  27. Linq “Could not translate expression… into SQL and could not treat it as a local expression.”
  28. Accessing System Databases/Tables using LINQ to SQL?
  29. LINQ to SQL Where Clause Optional Criteria
  30. C# Linq to SQL: How to express “CONVERT([…] AS INT)”?

Leave a Comment