DevForce Community Forum : Getting entity back but skipping some fields http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2010 : Getting entity back but skipping some fields Mon, 13 Apr 2026 00:09:04 -700 Mon, 28 Nov 2011 14:26:48 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=3109 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ Getting entity back but skipping some fields : I already split actual table,... http://www.ideablade.com/forum/forum_posts.asp?TID=3109&PID=12128#12128 Author: katit
Subject: 3109
Posted: 28-Nov-2011 at 2:26pm

I already split actual table, it will be better in a long run I think. Splitting entity will be problematic if I want to regenerate model from scratch. Right now I can do it easily.]]> Mon, 28 Nov 2011 14:26:48 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3109&PID=12128#12128 Getting entity back but skipping some fields : Just found out that you don't... http://www.ideablade.com/forum/forum_posts.asp?TID=3109&PID=12127#12127 Author: DenisK
Subject: 3109
Posted: 28-Nov-2011 at 2:22pm

Just found out that you don't have to create a separate table for this. You can map a table to multiple entities. This concept is called Table Splitting in EF.

http://www.deveducate.com/blog/post/2010/12/14/Entity-Framework-Modeling-Table-Splitting.aspx

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

http://msdn.microsoft.com/en-us/library/cc716698.aspx


]]> Mon, 28 Nov 2011 14:22:58 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3109&PID=12127#12127 Getting entity back but skipping some fields : You actually need to create a... http://www.ideablade.com/forum/forum_posts.asp?TID=3109&PID=12126#12126 Author: DenisK
Subject: 3109
Posted: 28-Nov-2011 at 12:56pm

You actually need to create a separate table and entity for this. The main entity will have this binary data entity as a navigation entity which, when you do your queries, you can choose to not include this entity, thus reducing your payload.]]> Mon, 28 Nov 2011 12:56:26 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3109&PID=12126#12126 Getting entity back but skipping some fields : Right. I was also thinking... http://www.ideablade.com/forum/forum_posts.asp?TID=3109&PID=12114#12114 Author: katit
Subject: 3109
Posted: 23-Nov-2011 at 7:57pm

Right. I was also thinking about moving it into separate table in SQL Server.
 
Or do you mean I can separate this into entity with Entity designer?
]]> Wed, 23 Nov 2011 19:57:43 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3109&PID=12114#12114 Getting entity back but skipping some fields : Hmm, the only way I can think... http://www.ideablade.com/forum/forum_posts.asp?TID=3109&PID=12113#12113 Author: DenisK
Subject: 3109
Posted: 23-Nov-2011 at 7:51pm

Hmm, the only way I can think of is to separate that binary data field into another entity. So you will have a 1:1 or 0,1:1 relationship with the binary data entity.

This is probably be better as well in the long run as downloading large chunks of binary data can consume large memory.
]]> Wed, 23 Nov 2011 19:51:04 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3109&PID=12113#12113 Getting entity back but skipping some fields : I have some entities which... http://www.ideablade.com/forum/forum_posts.asp?TID=3109&PID=12107#12107 Author: katit
Subject: 3109
Posted: 23-Nov-2011 at 7:00pm

I have some entities which contain binary data. I'd like to query this data but skip that binary field so I can download it later on demand. Is that possible somehow?
 
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?
]]> Wed, 23 Nov 2011 19:00:57 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3109&PID=12107#12107