Databases
StackOverflow2013
Postsdbo
POWebApi with Linq "Extra content at the end of the document" error
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POWebApi with Linq "Extra content at the end of the document" error
    text
    copied!<p>I have the following error when I try to query my MVC 4 WebApi service </p> <pre><code>Extra content at the end of the document Below is a rendering of the page up to the first error. 55Author Namehttp://images.myserver.com/authorspictures/nophoto.jpg </code></pre> <p>I looked into the Author class generated by Linq To Sql and found out that the next property of the Author object just after the image URL is this one:</p> <pre><code> [Association(Name = "Author_Quote", Storage = "_Quotes", ThisKey = "Id", OtherKey = "AuthorId")] public EntitySet&lt;Quote&gt; Quotes { get; set; } </code></pre> <p>My undertanding is that there is some problem when generating the XML for this property causing the above error. However I don't know how I can prevent that and make it working correctly. Most examples I found regarding webApi were using POCO lists so they can't help me on this matter.</p> <p>Any advices?</p> <p>Below is my code </p> <pre><code>public class AuthorController : ApiController { IAuthorRepository repository; public AuthorController(IAuthorRepository repository) { this.repository = repository; } [ResultLimit(20)] public IQueryable&lt;Author&gt; GetAuthors(){ return repository.GetAuthors(); } } public class DBAuthorRepository : IAuthorRepository { public IQueryable&lt;Author&gt; GetAuthors() { using (var context = new QuotesDataContext()) { return context.Authors.ToList().AsQueryable(); } } } </code></pre>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload