Expression<Func<T, bool>> support

[tmsmith]

Expression> support

from dapper-extensions.

[pagebrooks]

It is certainly possible and LINQ to SQL does this. But you have to decide where you are going to draw the line in supporting such functionality. LINQ to SQL has a lot of support for method translations to SQL, but there are also tons of caveats.

I personally feel like it's a leaky abstraction to support this type of functionality because it is so easy to build a predicate that can't be translated to SQL. You kind of just have to know what will work and what won't work. For example, you obviously couldn't write something like this and have it translate to native SQL. However, this would compile without fault:

IEnumerable parts = DbConnection.GetList(part => SomeNativeCSharpLogic(part));

LINQ to SQL has many limitations on what will work in the predicate expression.
http://msdn.microsoft.com/en-us/library/bb882677
http://msdn.microsoft.com/en-us/library/bb882672

[holyprin]

Totally understood, I was just wondering why the boolean aspect wasn't used (where clause) because that is basically what the custom predicate functions create. Joins / inner joins / outer joins are far beyond the scope of a micro orm, those should be handled imo through raw sql or sprocs via dapper itself. I was just a little curious if the boolean portion were possible, I haven't looked into the source code for more then 5 minutes browsing it.