Getting entity back but skipping some fields

 

var query =
                from mi in this.entityManager.SYSMailItems
                    .Include(SYSMailItem.PathFor(x => x.MEMUser))
                    .Include("SYSMailRecipients.MEMUser")
                    .Include(SYSMailItem.PathFor(x => x.SYSMailAttachments))
                orderby mi.MailItemKey descending
                select mi;

 

I'm talking about SYSMailAttachments.

I understand I can brake this query into 2 and make projection into custom/anon object but I really like to get all this info in one shot and then get binary data separately. Any magic I can use within DevForce?

 

Or do you mean I can separate this into entity with Entity designer?

There's also the opposite concept called Entity Splitting where you can map an entity to multiple tables.