How do I write this cross apply query in LINQ-to-SQL?

by

This should do the trick

var query = from a in context.TableA
            from b in context.TableB
                             .Where(x => x.TableA_Id == a.Id)
                             .OrderBy(x => x.Value)
                             .Take(10)
            where a.Key >= 0 && a.Key <= 999
            select new
            {
              a.Key,
              b.Value,
            };

More Related Contents:

  1. LINQ-to-SQL vs stored procedures? [closed]
  2. Linq: adding conditions to the where clause conditionally
  3. LINQ Between Operator
  4. LINQ across multiple databases
  5. Learning about LINQ [closed]
  6. How can I reject all changes in a Linq to SQL’s DataContext?
  7. LINQ with SQLite (linqtosql)
  8. How to create a dynamic LINQ join extension method
  9. LINQ not updating on .SubmitChanges()
  10. How to dynamically add OR operator to WHERE clause in LINQ
  11. LINQ To SQL exception: Local sequence cannot be used in LINQ to SQL implementation of query operators except the Contains operator
  12. Linq To Sql – Dynamic OrderBy – Case When
  13. Is there a pattern using Linq to dynamically create a filter?
  14. Linq to SQL how to do “where [column] in (list of values)”
  15. Multiple WHERE clause in Linq
  16. Point connectionstring in dbml to app.config
  17. Building Dynamic LINQ Queries based on Combobox Value
  18. NHibernate vs LINQ to SQL
  19. Returning IEnumerable vs. IQueryable
  20. Linq to Sql: Multiple left outer joins
  21. Entity framework linq query Include() multiple children entities
  22. Convert String to Int in EF 4.0
  23. Understanding .AsEnumerable() in LINQ to SQL
  24. Linq version of SQL “IN” statement
  25. LINQ Join with Multiple Conditions in On Clause
  26. Am I misunderstanding LINQ to SQL .AsEnumerable()?
  27. Entity Framework – “Unable to create a constant value of type ‘Closure type’…” error
  28. EF 4: Removing child object from collection does not delete it – why?
  29. How do I do a left outer join with Dynamic Linq?
  30. Linq “Could not translate expression… into SQL and could not treat it as a local expression.”

Leave a Comment