sort alphanumeric values

[dha lak]

Hi,

Does anyone know how to sort using linq-entity.


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

The result is item1,item2,ite m21, item22, item3. But, i want it to be like item1, item2, item3, item21, item22

Thanks

[Sivaranjani]

Your linq-entity Coadings are correct. The Field "Name" is Varchar.So,
item21 came first.

[dha lak]

Thanks for the reply!

I do not have much in-depth knowledge in Linq or generics but i am good in the basics level.

Is it possible to use generics with Linq to override the default sorting in linq?