CodeSmith Community

I've created a patch that adds an SqlFilterType to our strongly typed filter based on the discussion here:
http://community.codesmithtools.com/forums/p/5677/30760.aspx

Basically, you will be able to filter your where clause by using each individual word or a phrase of words.

By default, it will use SqlFilterType.Word, the same functionality that was used before the changes to prevent bugs in legacy code.

Example usage:

<data:AirportCodeDataSource ID="AirportCodeDataSource1" runat="server" SelectMethod="GetPaged" EnablePaging="true" EnableSorting="true">
    <Parameters>
        <data:SqlParameter Name="WhereClause" UseParameterizedFilters="false">
            <Filters>
                <data:AirportCodeFilter Column="CountryCode" ControlID="ddlCountryList" />
                <data:AirportCodeFilter Column="City" ControlID="txtSearch" ComparisionType="Contains" FilterType="Phrase"  />
            </Filters>
        </data:SqlParameter>
    </Parameters>
</data:AirportCodeDataSource>

Cheers,
CB

Edit: I'm still not sure whether or not "FilterType" should be the right word here... anyone have suggestions?