order by len() but in linq with c#

Question

this is my query in sql server and everything works fine

select * from DetalleNotas
order by len(ColProduct), ColProduct

PROCT1
PROCT2
PROCT3
PROCT4
PROCT5
PROCT6
PROCT7
PROCT8
PROCT9
PROCT10

but i want my query in linq c#

I tried this and it does not work

var product = (from d in db.Product
                orderby len(d.ColProduct), d.ColProduct
                select new
                {
                    product= d.product
                });

the name "len" does not exist in the real context

only this query works

var product = (from d in db.DetalleNotas
                orderby d.ColProduct
                select new
                {
                    product= d.product
                });

This is the result of my functional query

PROCT1
PROCT10
PROCT2
PROCT3
PROCT4
PROCT5
PROCT6
PROCT7
PROCT8
PROCT9

"does not work" in what way does it not work? Do you see errors? — DavidG
– DavidG, Commented May 4, 2018 at 15:58
mi error is the name "len" does not exist in the real context — rodrigo.rodriguez
– rodrigo.rodriguez, Commented May 4, 2018 at 16:08
Possible duplicate of LINQ to SQL - Checking the field length — Seano666
– Seano666, Commented May 4, 2018 at 16:14

DavidG · Accepted Answer · 2018-05-04 16:05:35Z

5

Remember that in C# Linq code, everything is still C#. As you're working with strings you need to order by string.Length. For example:

var results = from d in db.DetalleNotas
              orderby d.ColProduct.Length
              select d;

answered May 4, 2018 at 16:05

DavidG

120k13 gold badges232 silver badges239 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Slaven Tojić · Accepted Answer · 2018-05-04 16:21:26Z

5

You could order it by the number on the end of your strings:

var result = db.DetalleNotas.OrderBy(d => Convert.ToInt32(d.ColProduct.Substring(5)))
                            .ToArray();

edited May 4, 2018 at 16:21

answered May 4, 2018 at 16:06

Slaven Tojić

3,0142 gold badges18 silver badges33 bronze badges

Collectives™ on Stack Overflow

order by len() but in linq with c#

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related