113 lines
3.7 KiB
C#
113 lines
3.7 KiB
C#
#region License
|
|
// Copyright (c) 2007 James Newton-King
|
|
//
|
|
// Permission is hereby granted, free of charge, to any person
|
|
// obtaining a copy of this software and associated documentation
|
|
// files (the "Software"), to deal in the Software without
|
|
// restriction, including without limitation the rights to use,
|
|
// copy, modify, merge, publish, distribute, sublicense, and/or sell
|
|
// copies of the Software, and to permit persons to whom the
|
|
// Software is furnished to do so, subject to the following
|
|
// conditions:
|
|
//
|
|
// The above copyright notice and this permission notice shall be
|
|
// included in all copies or substantial portions of the Software.
|
|
//
|
|
// THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND,
|
|
// EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES
|
|
// OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND
|
|
// NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT
|
|
// HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY,
|
|
// WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING
|
|
// FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR
|
|
// OTHER DEALINGS IN THE SOFTWARE.
|
|
#endregion
|
|
|
|
using Newtonsoft.Json.Linq;
|
|
using System;
|
|
using System.Collections.Generic;
|
|
#if NET20
|
|
using Newtonsoft.Json.Utilities.LinqBridge;
|
|
#else
|
|
using System.Linq;
|
|
#endif
|
|
using System.Text;
|
|
#if DNXCORE50
|
|
using Xunit;
|
|
using Test = Xunit.FactAttribute;
|
|
using Assert = Newtonsoft.Json.Tests.XUnitAssert;
|
|
#else
|
|
using NUnit.Framework;
|
|
|
|
#endif
|
|
|
|
namespace Newtonsoft.Json.Tests.Documentation.Samples.Linq
|
|
{
|
|
[TestFixture]
|
|
public class QueryJsonLinq : TestFixtureBase
|
|
{
|
|
[Test]
|
|
public void Example()
|
|
{
|
|
#region Usage
|
|
string json = @"{
|
|
'channel': {
|
|
'title': 'James Newton-King',
|
|
'link': 'http://james.newtonking.com',
|
|
'description': 'James Newton-King\'s blog.',
|
|
'item': [
|
|
{
|
|
'title': 'Json.NET 1.3 + New license + Now on CodePlex',
|
|
'description': 'Announcing the release of Json.NET 1.3, the MIT license and the source on CodePlex',
|
|
'link': 'http://james.newtonking.com/projects/json-net.aspx',
|
|
'category': [
|
|
'Json.NET',
|
|
'CodePlex'
|
|
]
|
|
},
|
|
{
|
|
'title': 'LINQ to JSON beta',
|
|
'description': 'Announcing LINQ to JSON',
|
|
'link': 'http://james.newtonking.com/projects/json-net.aspx',
|
|
'category': [
|
|
'Json.NET',
|
|
'LINQ'
|
|
]
|
|
}
|
|
]
|
|
}
|
|
}";
|
|
|
|
JObject rss = JObject.Parse(json);
|
|
|
|
var postTitles =
|
|
from p in rss["channel"]["item"]
|
|
select (string)p["title"];
|
|
|
|
foreach (var item in postTitles)
|
|
{
|
|
Console.WriteLine(item);
|
|
}
|
|
//LINQ to JSON beta
|
|
//Json.NET 1.3 + New license + Now on CodePlex
|
|
|
|
var categories =
|
|
from c in rss["channel"]["item"].Children()["category"].Values<string>()
|
|
group c by c
|
|
into g
|
|
orderby g.Count() descending
|
|
select new { Category = g.Key, Count = g.Count() };
|
|
|
|
foreach (var c in categories)
|
|
{
|
|
Console.WriteLine(c.Category + " - Count: " + c.Count);
|
|
}
|
|
//Json.NET - Count: 2
|
|
//LINQ - Count: 1
|
|
//CodePlex - Count: 1
|
|
#endregion
|
|
|
|
Assert.AreEqual(3, categories.Count());
|
|
}
|
|
}
|
|
} |