Merge pull request umbraco#535 from zpqrtbnk/7.2.0-wherein

Shazwazza · Shazwazza · commit c74c269b9a8f · 2014-11-13T09:35:00.000+11:00
Add WhereIn PetaPoco Sql Extension
diff --git a/src/Umbraco.Core/Persistence/PetaPocoSqlExtensions.cs b/src/Umbraco.Core/Persistence/PetaPocoSqlExtensions.cs
@@ -1,4 +1,5 @@
 ﻿using System;
+using System.Collections;
 using System.Linq;
 using System.Linq.Expressions;
 using System.Reflection;
@@ -24,11 +25,17 @@ public static Sql From<T>(this Sql sql)
         public static Sql Where<T>(this Sql sql, Expression<Func<T, bool>> predicate)
         {
             var expresionist = new PocoToSqlExpressionHelper<T>();
-            string whereExpression = expresionist.Visit(predicate);
-
+            var whereExpression = expresionist.Visit(predicate);
             return sql.Where(whereExpression, expresionist.GetSqlParameters());
         }
 
+        public static Sql WhereIn<T>(this Sql sql, Expression<Func<T, object>> fieldSelector, IEnumerable values)
+        {
+            var expresionist = new PocoToSqlExpressionHelper<T>();
+            var fieldExpression = expresionist.Visit(fieldSelector);
+            return sql.Where(fieldExpression + " IN (@values)", new {@values = values});
+        }
+
         public static Sql OrderBy<TColumn>(this Sql sql, Expression<Func<TColumn, object>> columnMember)
         {
             var column = ExpressionHelper.FindProperty(columnMember) as PropertyInfo;
