DevForce Community Forum : Selecting certain properties of a DF/EF object. http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2010 : Selecting certain properties of a DF/EF object. Mon, 13 Apr 2026 14:40:37 -700 Wed, 20 Oct 2010 10:18:18 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=2245 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ Selecting certain properties of a DF/EF object. : geo, you can try: . . ... http://www.ideablade.com/forum/forum_posts.asp?TID=2245&PID=8855#8855 Author: sbelini
Subject: 2245
Posted: 20-Oct-2010 at 10:18am

geo,
 
you can try:
  .
  .
  .
  .Select(e => new { id = e.Employee_ID, fname = e.Person.FirstName, lname = e.Person.LastName })
  .
  .
  .
  foreach (var item in op.Results){
    Employee.Employee_ID = item.id;
    Employee.Person.FirstName = item.fname;
    Employee.Person.LastName = item.lname;
  }
 
 
]]> Wed, 20 Oct 2010 10:18:18 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2245&PID=8855#8855 Selecting certain properties of a DF/EF object. : How can I select certain properties... http://www.ideablade.com/forum/forum_posts.asp?TID=2245&PID=8837#8837 Author: geo
Subject: 2245
Posted: 19-Oct-2010 at 5:56pm

How can I select certain properties to return without creating a new anonymous object? My goal is to use the Employee object I would normally get back but only fill certain properties in an effort to reduce the data going across my WCF service. Is this possible? With this code I get this error where I set Employee=item within my foreach loop.

Cannot implicitly convert type 'AnonymousType#1' to 'AmberStream.Model.Payroll.Employee'

            var query = _entityManager
                .Employees
                .AddIncludePaths("Person")
                .Where(col => col.Employee_ID == id)
                .Select(e => new { e.Employee_ID, e.Person.FirstName, e.Person.LastName })
                .ExecuteAsync(op => {
                    if (op.HasError)
                        throw op.Error;

                    foreach (var item in op.Results)
                    {
                        Employee = item; 
                    }
                    
                    // debugging log
                    ObjectDumper.Write(Employee);
                    ObjectDumper.Write(Employee.Person.FirstName);
                    ObjectDumper.Write(Employee.Person.LastName);
                });
]]> Tue, 19 Oct 2010 17:56:28 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2245&PID=8837#8837