Return anonymous type results?

by

I tend to go for this pattern:

public class DogWithBreed
{
    public Dog Dog { get; set; }
    public string BreedName  { get; set; }
}

public IQueryable<DogWithBreed> GetDogsWithBreedNames()
{
    var db = new DogDataContext(ConnectString);
    var result = from d in db.Dogs
                 join b in db.Breeds on d.BreedId equals b.BreedId
                 select new DogWithBreed()
                        {
                            Dog = d,
                            BreedName = b.BreedName
                        };
    return result;
}

It means you have an extra class, but it’s quick and easy to code, easily extensible, reusable and type-safe.

More Related Contents:

  1. Difference Between Select and SelectMany
  2. LINQ – Left Join, Group By, and Count
  3. When should I dispose of a data context
  4. How can I conditionally apply a Linq operator?
  5. LINQ to SQL – Left Outer Join with multiple join conditions
  6. How to do a subquery in LINQ?
  7. Understanding .AsEnumerable() in LINQ to SQL
  8. TransactionScope vs Transaction in LINQ to SQL
  9. LINQ: combining join and group by
  10. How to write Asynchronous LINQ query?
  11. Am I misunderstanding LINQ to SQL .AsEnumerable()?
  12. How do you perform a CROSS JOIN with LINQ to SQL?
  13. LINQ Where Ignore Accentuation and Case
  14. Operation could destabilize the runtime?
  15. How to select only the records with the highest date in LINQ
  16. Get table-data from table-name in LINQ DataContext
  17. DISTINCT() and ORDERBY issue
  18. Custom Method in LINQ to SQL query
  19. LINQ to SQL using GROUP BY and COUNT(DISTINCT)
  20. LINQ Expression to return Property value?
  21. Max or Default?
  22. How to make LINQ execute a (SQL) LIKE range search
  23. How do I do a left outer join with Dynamic Linq?
  24. Get sum of two columns in one LINQ query
  25. Last and LastOrDefault not supported
  26. Accessing System Databases/Tables using LINQ to SQL?
  27. LINQ to SQL Where Clause Optional Criteria
  28. Linq where column == (null reference) not the same as column == null
  29. Is Injection Possible through Dynamic LINQ?
  30. C# Linq to SQL: How to express “CONVERT([…] AS INT)”?

Leave a Comment