LINQ to JSON

Question

I am trying the execute the sample code of LINQ to JSON (mentioned below) but it is giving me following error

Stack Trace:

[InvalidOperationException: Lambda Parameter not in scope]

Code I am executing is:

      JObject rss =
          new JObject(

                new JProperty("id", "James Newton-King"),
                new JProperty("name", "http://james.newtonking.com"),
                new JProperty("data", "James Newton-King's blog."),
                new JProperty("children",
                  new JArray(
                    from p in mwsysbot.Software
                    where p.SoftwareName == name
                    select new JObject(                            
                      new JProperty("id",p.SoftwareUUID),
                      new JProperty("name", p.SoftwareName)         
                    )
                  )
                 )
               );

Also when I remove line "new JProperty("name", p.SoftwareName) " the code executes perfectly.

I am not able to figure out why. Can someone please help me out ?

Let me know if you require more information ? Also can any one provide me some tutorial links to LINQ to JSON ?

Answer 1

Linq could try to lazy-load the SoftwareName. Try using a DTO and eager-load the parameter name before creating the new object.

Answer 2

I tried this and it worked for me...

     IQueryable<Software> soft = (from s in mwsysbot.Software
                                                     select s).ToList();

JObject rss =
           new JObject(
                     new JProperty("id", "James Newton-King"),
                     new JProperty("name", "http://james.newtonking.com"),
                     new JProperty("data", "James Newton-King's blog."),
                     new JProperty("children", new JArray(
                         from m in soft
                         select new JObject(
                             new JProperty("id",m.SoftwareName),
                             new JProperty("name", m.SoftwareName),
                             new JProperty("children",new JArray())
                             )
                         ))


             );

I dont know the reason !

Is it like we can use only the "List " data structure in the above place ?