As of 5.1.0, SqlExpression<T> is currently missing the overload SelectDistinct<Table1>(Expression<Func<Table1, object>> fields) while it exists for Select(). It is currently not possible to SelectDistinct and projecting the data using one table only, when this table is not the T of SqlExpression.
I’ve added the missing API + up 12 Select<...,Table12> and SelectDistinct<...,Table12> APIs which is available from v5.1.1 on MyGet.
1 Like