Results from query different in client to DBservice.

    General discussion

  • This is my service query:

    public IQueryable<ImportedProduct> GetOtherDbProducts(string connectionString)
        List<ImportedProduct> output = new List<ImportedProduct>();
        OtherDbEntities context = null;
            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

    Wednesday, January 25, 2012 4:41 AM

All replies

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

    Thursday, January 26, 2012 7:40 PM
  • Could you give us the full definition of ImportedProduct?

    Wednesday, February 29, 2012 8:01 PM
  • We have been unable to reproduce this issue.  Without a detailed repro, we won't be able to investigate this any further.

    Jeff Handley

    Monday, March 26, 2012 9:40 PM