I want to sort IP-Address information by the last number. The IP-Address is stored as a nvarchar in the database.

I´ve tried the following:

Func<string, int> Host = s => Int32.Parse(s.Split('.')[3]);
var q = from c in meta.Terminal orderby Host(c.Ipaddr) select c;

EntityCollection<TerminalEntity> terminals = ((ILLBLGenProQuery)q).Execute<EntityCollection<TerminalEntity>>();

the orderby doesn´t work

Any suggestions?

Kind regards, Carlo

That func is a 'delegate' at runtime, so isn't convertable to sql. To do what you want please try FunctionMappings.

daelmo wrote:

That func is a 'delegate' at runtime, so isn't convertable to sql. To do what you want please try FunctionMappings.

Thank you, I will give it a try.

My workaround for now is to sort the result:

Func<string, int> Host = s => Int32.Parse(s.Split('.')[3]);
var terminals = from c in Terminal.GetTerminals() orderby Host(c.Ipaddr) select c; 

Terminal.GetTerminals() returns EntityCollection<TerminalEntity>().

Kind regards, Carlo