sort alphanumeric string using LINQ

Hi,

Does anyone know how to sort using linq-entity.


i use the following code:
from i in objEntities.Items
where ....
orderby i.Name
select i

The result is a1,a10,a11,a2,a3, b2,b21, b22,  c3....  But, i want it to be like a1,a2,a3,a10,a11, b2,b21,b22, c3...

This is very urgent. Please help me.

Hi,

Try to give this short discussion a read: http://stackoverflow.com/questions/5093842/alphanumeric-sorting-using-linq-c