I need to express following queru.

select * from table1 where value=function(parameter1,'ssss')

The parameter1 value is passed and the sss value is always the same.

I read in the doc I have to create an expresion, but I dont know where to start.

Thanks in advance.

You should be able to do something like

IPredicate functionFilter = new EntityField("OrderMonth", new DbFunctionCall("dbo.function({0},{1})", new object[] {parameter1,"ssss"})

and use this as the filter on a query to retrieve a dynamic or typed list.

Hmm I've tried your code

IPredicate functionFilter = new EntityField("OrderMonth",new DbFunctionCall("dbo.function({0},{1})",new object[] {"aaa", "ssss"});

but intelisense says:

Cannot convert source type 'SD.LLBLGen.Pro.ORMSupportClasses.EntityField' to target type 'SD.LLBLGen.Pro.ORMSupportClasses.IPredicate'

select * from table1 where function(parameter1,'ssss')=value

I guess he meant the following:

var field = new EntityField("OrderMonth",new DbFunctionCall("dbo.function({0},{1})",new object[] {"aaa", "ssss"});

var filter = new PredicateExpression(field == value);

Yes, this worked perfect! Thank you both guys!