I am looking for something like a micro ORM (like Dapper) where it will, hopefully, solve the current issues my client solution has.

There are 2 issues:

its a big solution. Repositories, services, DTO's, ViewModels, Interfaces all over the place etc....
means if we need to create a new entity - create the table in SQL, create the entity in DBML, create interfaces for that new entity, create the service and interface for that service, and the same with the respository for that entity. its a long complicated process, unfortunately. Want to reduce this overhead

The other problem is, things like being able to create a flattened ViewModel/Model or even a VM/Model with the exact entity we want to show/work on, is not entirely workable when dealing with IQueryable. It wouldnt be able to translate the object in question to the relational entity I am querying.

It's difficult to explain but essentially:

what suggestions/ORM tools can you recommend that is lightweight, fast and can handle IQueryable process before finally being able to execute that against SQL. It should be able to handle our currently defined entities/DTO's in the DBML.

any ideas?