Invalid name for parameter when build a select

Hi, using lastest trunk I found is not posible to build a select with a calculated column like: q.Where(String.Format("LEFT(Convert(varchar, {0} ,103),{1})", "Fecha", ValorStr.Length)).IsEqualTo(ValorStr) I get this: WHERE LEFT(Convert(varchar, Fecha ,103),3) = @LEFTConvertvarchar,Fecha,103,30 This happend alwasy a function is called with ",". However, this work fine: "CAST(Values AS VARCHAR)"

mamcx:

@LEFTConvertvarchar,Fecha,103,30

Subsonic is trying to to parameterize your query, and commas don't work in parameter names. can you try using the "as" keyword?

 

Generate this: @LEFTConvertvarchar,Fecha,103,3ASFecha0 Subsonic need clean the generated name. You know where is that function so I can fix it ?

Ok, I put this code and work fine: Also, I think that StripNonAlphaNumeric is not rigth. The best is check for valid chars, not hardcode what is wrong.

        public static string PrefixParameter(string parameter, DataProvider provider)
        {
            //added this check for Unit Testing weirdness - RC
            if(provider == null)
                provider = DataService.Provider;

            string prefix = provider.GetParameterPrefix();

            if(!parameter.StartsWith(prefix))
                parameter = String.Concat(prefix, parameter.Replace(" ", String.Empty));
            //clean non-valid chars
            string regex = "@|\\w+|\\d+";
            RegexOptions options = ((RegexOptions.IgnorePatternWhitespace | RegexOptions.Multiline) 
                        | RegexOptions.IgnoreCase);
            Regex reg = new Regex(regex, options);

            string clean = "";
            MatchCollection theMatches = reg.Matches(parameter);

            for (int counter = 0; counter