Results from query different in client to DBservice.

Question

This is my service query:

[Query]
public IQueryable<ImportedProduct> GetOtherDbProducts(string connectionString)
{
    List<ImportedProduct> output = new List<ImportedProduct>();

    OtherDbEntities context = null;
    try
    {
        context = new OtherDbEntities(connectionString);
    }
    catch (Exception e)
    {
        throw new Exception("The connection to the database failed.", e);
    }

    foreach(OtherDb.Product p in context.Products)
        output.Add(new ImportedProduct()
        {
            Id = p.ProductId,
            Name = p.ProductName,
            ShortName = p.ProductShortName
        });

    return output.AsQueryable();
}

When I put a break point on the return, I can see the data I expect. However when I put a break point in the Load Operation result I get slightly different results. Some of the rows show 'Unknown' for the Name and '???' for the ShortName. The Id, however, is correct.

This issue occurs on WCF RIA Service V1.0 SP2 but NOT on SP1

Answer 1

Thanks for reporting this, we'll investigate and let you know.

Answer 2

Could you give us the full definition of ImportedProduct?

Answer 3

We have been unable to reproduce this issue.  Without a detailed repro, we won't be able to investigate this any further.

Thanks,
Jeff Handley