BuildWhereStatement with IGeneratedCriteria as parameter

[GoogleCodeExporter]

What steps will reproduce the problem?
I did not find another place to comment on this...

On the ADOHelper class it will be usefull to have an overload funcion (to not 
break existing code) of BuildWhereStatement with IGeneratedCriteria as 
parameter, to include the full table name on the where clause. This is useful 
when overriding the select statement in "OnFetching" where you could include 
join(s) with another table(s) that might have the same column names been used 
as part of the criteria.

    Public Shared Function BuildWhereStatement(criteria As IGeneratedCriteria) As String
     If criteria isnot nothing then
        Dim bag As Dictionary(Of String, Object) = criteria.StateBag
        If bag.Count = 0 Then
            Return String.Empty
        End If
        Dim columnNames As String = bag.Keys.Aggregate(String.Empty, Function(current, columnName) current + String.Format(criteria.TableFullName & "." & "[{0}] = @p_{0} AND ", columnName))
        Return String.Format("WHERE {0}", columnNames.Remove(columnNames.Length - 5, 5))
    else
       Return String.Empty
     End If
    End Function

Original issue reported on code.google.com by yoselsua...@gmail.com on 7 Mar 2013 at 1:32

• Merged into: #683

[GoogleCodeExporter]

Original comment by bniemyjski on 7 Mar 2013 at 10:39

• Changed state: Duplicate