Hi,

I need to type cast from string to double in my PredicateExpression. here's the code:

string[] textPromptRange = textPrompt.Split('-'); PredicateExpression.Add(ProductSingleAttributeMappingFields.ProductAttributeId == idAttribute); PredicateExpression.AddWithAnd(ProductSingleAttributeMappingFields.TextPrompt >= double.Parse(textPromptRange[0]));

actually it makes the compare as a string. I know it is a string in the database, but this is a generic field and it can be use as a double.

How can I make the the expression compare double??

thanks!

You have to create an expression to cast the field and compare it to a in-memory double. Some examples:

http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=16373&StartAtMessage=0&#91460

http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=17413&StartAtMessage=0&#97520