Does AutoMapper support Linq?

by

While @Aaronaught’s answer was correct at the time of writing, as often the world has changed and AutoMapper with it. In the mean time, QueryableExtensions were added to the code base which added support for projections that get translated into expressions and, finally, SQL.

The core extension method is ProjectTo1. This is what your code could look like:

using AutoMapper.QueryableExtensions;

public IQueryable<DO_RoleInfo> SelectAll()
{
    Mapper.CreateMap<DB_RoleInfo, DO_RoleInfo>();
    return _ctx.DB_RoleInfo.ProjectTo<DO_RoleInfo>();
}

and it would behave like the manual mapping. (The CreateMap statement is here for demonstration purposes. Normally, you’d define mappings once at application startup).

Thus, only the columns that are required for the mapping are queried and the result is an IQueryable that still has the original query provider (linq-to-sql, linq-to-entities, whatever). So it is still composable and this will translate into a WHERE clause in SQL:

SelectAll().Where(x => x.Id == Key).SingleOrDefault();

1 Project().To<T>() prior to v. 4.1.0

More Related Contents:

  1. Is LINQ to SQL Dead or Alive?
  2. How to do a join in linq to sql with method syntax?
  3. How do I update a Linq to SQL dbml file?
  4. Benchmark Linq2SQL, Subsonic2, Subsonic3 – Any other ideas to make them faster?
  5. ASP.MVC: Repository that reflects IQueryable but not Linq to SQL, DDD How To question
  6. Explicit construction of entity type ‘###’ in query is not allowed.
  7. NOLOCK with Linq to SQL
  8. Common Table Expression (CTE) in 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. Linq: adding conditions to the where clause conditionally
  15. Making Entity Class Closed for Changes
  16. Understanding SQL Server LOCKS on SELECT queries
  17. TransactionScope vs Transaction in LINQ to SQL
  18. How to ignore null values for all source members during mapping in Automapper 6?
  19. Get SQL query from LINQ to SQL?
  20. How to write Asynchronous LINQ query?
  21. How do you perform a CROSS JOIN with LINQ to SQL?
  22. How can I reject all changes in a Linq to SQL’s DataContext?
  23. Get all associate/composite objects inside an object (in Abstract way)
  24. Is there a difference between Select * and Select [list each col] [duplicate]
  25. Linq To Sql – Dynamic OrderBy – Case When
  26. What can I do to resolve a “Row not found or changed” Exception in LINQ to SQL on a SQL Server Compact Edition Database?
  27. Doesn’t Linq to SQL miss the point? Aren’t ORM-mappers (SubSonic, etc.) sub-optimal solutions?
  28. Pass Objects to AutoMapper Mapping
  29. IDENTITY INSERT and LINQ to SQL
  30. Mapping Lists using Automapper

Leave a Comment