need help to build linq query

Question

I am facing problem to create Linq query following is example following are some data which is available in Db

and i have another number like which i need to search in above data like

1) 76041010 this number should take 76041010 code from above data
2) 760458688 this number should take 7604 code from above data
3) 7505110022 this number should take 750511 code from above data ,

I need to retrieve maximum matched number from db, I need query please help me to build linq query.

Are you using EntityFramework? What is the name of your db context? Can you post your models & controllers? — jon.r
– jon.r, Commented Nov 2, 2017 at 12:24
yes i am using entity framework, my db context is TradeComplianceContext — kushal
– kushal, Commented Nov 2, 2017 at 12:25
The return in the third scenario is 7505. Shouldn't it be 750511? — Peter Szekeli
– Peter Szekeli, Commented Nov 2, 2017 at 12:57

Peter Szekeli · Accepted Answer · 2017-11-02 12:28:36Z

1

Not the most elegant solution, but produces the result you're expecting:

var result = data.Select(x => x.ToString())
                 .Where(x => input.ToString().StartsWith(x))
                 .OrderByDescending(x => x.Length)
                 .FirstOrDefault();

answered Nov 2, 2017 at 12:28

Peter Szekeli

2,8003 gold badges36 silver badges48 bronze badges

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

6 Comments

kushal Over a year ago

Thanks for replay , but it should match 4 digit ,

kushal Over a year ago

your Linq query seems if 1st or 2nd digit match then also it return data

Peter Szekeli Over a year ago

@kushalpawar how do you mean? could you give an example when it doesn't produce your expected result?

kushal Over a year ago

suppose 76111010 will return 76041010 becoz first 2 digits match with number , but it should return null because 7611 number not available in db , it should check start with 4 digit or greater than 4 digit

Peter Szekeli Over a year ago

@kushalpawar if you search for 76111010, using the data from your question (with the 4 values), this code will return null

|

Collectives™ on Stack Overflow

need help to build linq query

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related