JSON LInq Query

Question

I am looking at trying to use a Linq query to determine if the following JSON is true if it contains a product that has a SKU of 12345 OR a TypeCode of "C".

"[{\"SKU\":\"12345\",\"Description\":\"Test Part 12345\",\"TypeCode\":\"A\",\"Cost\":24.99},{\"SKU\":\"54567\",\"Description\":\"Test Part 54567\",\"TypeCode\":\"B\",\"Cost\":9.99},{\"SKU\":\"QWZ2342\",\"Description\":\"Test Part QWZ2342\",\"TypeCode\":\"C\",\"Cost\":19.99}]"

I have been working with the Json.net (http://james.newtonking.com/projects/json-net.aspx)

sagala · Accepted Answer · 2011-11-29 02:16:28Z

2

At first, you have to deserialize the JSON into a C# object, lets say Product.

class Product
{
    public int SKU { get; set; }
    public string Desc { get; set; }
    public string TypeCode { get; set; }
    public decimal Cost { get; set; }
}

then, using .NET's JavaScriptSerializer (System.Web.Script.Serialization), convert the json string to become List of your custom objects.

string json = "[{\"SKU\":\"12345\",\"Description\":\"Test Part 12345\",\"TypeCode\":\"A\",\"Cost\":24.99},{\"SKU\":\"54567\",\"Description\":\"Test Part 54567\",\"TypeCode\":\"B\",\"Cost\":9.99},{\"SKU\":\"QWZ2342\",\"Description\":\"Test Part QWZ2342\",\"TypeCode\":\"C\",\"Cost\":19.99}]"

JavaScriptSerializer jsonSerializer = new JavaScriptSerializer();
List<Product> productList = new List<Product>();
productList = jsonSerializer.Deserialize<List<Product>>(json);

the last step, using simple linq query, you cant check whether your product exist on the list:

var Found = from o in productList
                    where o.SKU == 12345
                    select o.SKU;
if (Found.Count() > 0)
    return true;
else
    return false;

edited Nov 29, 2011 at 2:16

answered Nov 28, 2011 at 8:22

sagala

316 bronze badges

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

3 Comments

econner Over a year ago

When I run the linq query I am getting back all results and not what is filtered by the where statement. My List<Products> contains 80 items. When I add a where clause and specify a value that does not exist (such as o.SKU == "ZZZZZ") I still get a var Found that is not null and the count is 80 items.

econner Over a year ago

I noticed the Sourc count = 80 but the Results View is empty if the query where condition is not true. However, checking if Found != null is is returning true even if the Result View is empty. How might be the best way to determine if the query returned any results?

econner Over a year ago

Ok I think I have it. I am using the Count() method such as int count = Found.Count();

Collectives™ on Stack Overflow

JSON LInq Query

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related