Common Table Expression (CTE) in linq-to-sql?

by

AFAIK, this isn’t supported by the object model. However, LINQ supports a method to execute a query (strangly enough called DataContext.ExecuteQuery). Looks like you can use that to call a arbitrary piece of SQL and map it back to LINQ. You won’t be SQL free because of the embedded SQL, but you won’t have to use a sproc.

How to: Directly Execute SQL Queries (LINQ to SQL)

More Related Contents:

  1. Is LINQ to SQL Dead or Alive?
  2. Does AutoMapper support Linq?
  3. How to do a join in linq to sql with method syntax?
  4. How do I update a Linq to SQL dbml file?
  5. Benchmark Linq2SQL, Subsonic2, Subsonic3 – Any other ideas to make them faster?
  6. ASP.MVC: Repository that reflects IQueryable but not Linq to SQL, DDD How To question
  7. Explicit construction of entity type ‘###’ in query is not allowed.
  8. NOLOCK with Linq to SQL
  9. Convert SQL to LINQ to SQL
  10. C# Linq-to-Sql – Should DataContext be disposed using IDisposable
  11. T4 template to Generate Enums
  12. Using System.Data.Linq in a Razor view
  13. linq to sql: join multiple columns from the same table
  14. Returning IEnumerable vs. IQueryable
  15. LINQ: When to use SingleOrDefault vs. FirstOrDefault() with filtering criteria
  16. efficient way to implement paging
  17. Apply properties values from one object to another of the same type automatically?
  18. LINQ across multiple databases
  19. Understanding .AsEnumerable() in LINQ to SQL
  20. Metadata were not loaded using MetadataType
  21. Am I misunderstanding LINQ to SQL .AsEnumerable()?
  22. INSERT rows into multiple tables in a single query, selecting from an involved table
  23. A dependent property in a ReferentialConstraint is mapped to a store-generated column
  24. Incorrect syntax near the keyword ‘with’…previous statement must be terminated with a semicolon
  25. How to dynamically add OR operator to WHERE clause in LINQ
  26. Polymorphism: Is ORM entity a Domain Entity or Data Entity?
  27. Max or Default?
  28. How do I do a left outer join with Dynamic Linq?
  29. ASP MVC: When is IController Dispose() called?
  30. IDENTITY INSERT and LINQ to SQL

Leave a Comment