Returning multiple attributes query asp.net

Question

In function below I am trying to return multiple attributes form multiple tables.

Parent table > Child table

AspNetUser > Ad

Ad > MobileAd

public async Task<IHttpActionResult> GetAd(int id)
{
    Ad add = await db.Ads.FindAsync(id);
    if (add == null)
    {
        return NotFound();
    }
    
    var ret = (from ad in db.Ads
               where ad.Id.Equals(id)
               orderby ad.time
               select new
               {
                   title = ad.title,
                   postedById = ad.AspNetUser.Id,
                   postedByName = ad.AspNetUser.UserName,
                   description = ad.description,
                   mobilead = ad.MobileAds.FirstOrDefault(x => x.adId == ad.Id),
               });
    return Ok(ret);
}

In ajax request to fetch data I got Internal Server Error and below is the figure of debugging.

Why it is fetching objects instead of data?

Updated:

When I click on refresh icon in Results View during debugging. Its shows data! but not returning it.

I didn't get exception. Internal Server Error is the error in console window — Irfan Y
– Irfan Y, Commented Aug 11, 2015 at 9:15

Halis S. · Accepted Answer · 2015-08-11 11:51:35Z

1

You may consider using

 return Ok(ret.ToArray());

instead of

 return Ok(ret);

otherwise linq query above will not be evaluated.

answered Aug 11, 2015 at 11:51

Halis S.

4462 silver badges11 bronze badges

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

16 Comments

Irfan Y Over a year ago

1. Have you see image attached in question. You can see its not returning values(data). 2.I am returning single record so there is no need to use ToArray 3.I used used ToArray but no success. Request always go to `ajax().fail() function.

Halis S. Over a year ago

1. Of course I have seen the attached image, but the debug line over the variable "ret" was not expanded, so could not get enough info. 2. in order to enumarate and execute a linq query, ToArray, ToList or a loop statement must be used; otherwise it only stands as a statement only.

Irfan Y Over a year ago

On expand its shows non public members and results view which I think was of no use.

Halis S. Over a year ago

there must be a refresh icon near to "results view". By clicking on it Linq query is executed and results are shown below it.

Halis S. Over a year ago

Can you try .FirstOrDefault() at the end of the Linq?

|

Collectives™ on Stack Overflow

Returning multiple attributes query asp.net

1 Answer 1

16 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

16 Comments

Your Answer

Sign up or log in

Post as a guest

Related