LINQ Sorting List<T> based on string Name property

Question

I have the following:

public void ProcessRequest(HttpContext context)
{
    string query = context.Request.QueryString["term"];
    System.Web.Script.Serialization.JavaScriptSerializer JsonSerializer =
        new System.Web.Script.Serialization.JavaScriptSerializer();

    List<Category> Categs = Category.getAll();
    var result = from c in Categs where Categs.Contains(c.Name) select c;
    context.Response.ContentType = "application/json";
    context.Response.Write(JsonSerializer.Serialize(result));
}

Trying to return a list of [ { label: "Choice1", value: "value1" }, ... ] for jQuery UI autocomplete. I have Categories which have ID and Name properties and I want to filter the List based on the "term" in the querystring and Name property. How should i do that?

Thanks in advance.

FWIW, .NET naming conventions say that JsonSerializer should be jsonSerializer, Categs should be categs, and getAll() should be GetAll(). Also you could avoid typing out System.Web.Script.Serialization.JavaScriptSerializer twice by replacing the first occurance with var. — Joel Mueller
– Joel Mueller, Commented Jul 8, 2012 at 17:02

Paul Phillips · Accepted Answer · 2012-07-08 16:24:02Z

2

If your end goal is making that list of [ { label: "Choice1", value: "value1" }, ... ] and have it sorted by name, then this should work:

result
  .OrderBy(x => x.Name)
  .Select(x => new { label: x.Name, value: x.Id }); // create an anonymous type

Edit: Your current query:

var result = from c in Categs where Categs.Contains(c.Name) select c;

Looks wrong. I think that query is the same as just selecting all Categs. If you want to query based on the term they sent, replace c.Name with query in that linq expression:

var result = from c in Categs where Categs.Contains(query) select c;

edited Jul 8, 2012 at 16:24

answered Jul 8, 2012 at 16:18

Paul Phillips

6,28928 silver badges35 bronze badges

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

Comments

greg84 · Accepted Answer · 2012-07-08 16:19:27Z

0

string upperTerm = term.ToUpper();

var result = Category.getAll()
  .Where(c => c.Name.ToUpper().Contains(upperTerm))
  .Select(c => new { label = c.Name, value = c.Id });

Then JSON serialize result.

answered Jul 8, 2012 at 16:19

greg84

7,6293 gold badges39 silver badges45 bronze badges

Collectives™ on Stack Overflow

LINQ Sorting List<T> based on string Name property

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related