How to return anonymous type from c# method that uses LINQ to SQL [duplicate]

by

Make the anonymous type into a class…

public class Person
{
    public Person() {
    }

    public String Name { get; set; }
    public DateTime DOB { get; set; }
}


Person p = 
    from person in db.People 
    where person.Id = 1 
    select new Person { 
        Name = person.Name,
        DOB = person.DateOfBirth
    }

More Related Contents:

  1. Difference Between Select and SelectMany
  2. Return anonymous type results?
  3. LINQ – Left Join, Group By, and Count
  4. When should I dispose of a data context
  5. How can I conditionally apply a Linq operator?
  6. LINQ to SQL – Left Outer Join with multiple join conditions
  7. How to do a subquery in LINQ?
  8. LINQ to SQL and a running total on ordered results
  9. TransactionScope vs Transaction in LINQ to SQL
  10. LINQ: combining join and group by
  11. How to write Asynchronous LINQ query?
  12. Am I misunderstanding LINQ to SQL .AsEnumerable()?
  13. How do you perform a CROSS JOIN with LINQ to SQL?
  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 Expression to return Property value?
  20. Max or Default?
  21. How to make LINQ execute a (SQL) LIKE range search
  22. How do I do a left outer join with Dynamic Linq?
  23. Get sum of two columns in one LINQ query
  24. A dictionary where value is an anonymous type in C#
  25. Accessing System Databases/Tables using LINQ to SQL?
  26. LINQ to SQL Where Clause Optional Criteria
  27. Linq where column == (null reference) not the same as column == null
  28. Is Injection Possible through Dynamic LINQ?
  29. If Else in LINQ
  30. C# Linq to SQL: How to express “CONVERT([…] AS INT)”?

Leave a Comment