StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
14483576
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
1
CommunityOwnedDate
CreationDate
2013-01-23T15:47:12.533
FavoriteCount
0
LastActivityDate
2013-01-23T15:47:12.533
LastEditDate
LastEditorUserId
0
OwnerUserId
298830
ParentId
14470457
PostTypeId
2
Score
0
ViewCount
0
LastEditorDisplayName
text
Body
To answer your first question: Why isn't Attribute and AttributeValue merged? Can an AttributeValue have more Attributes? I guess it is the Item that can have multiple Attributes. Item {ID, Name} Attribute {ID, ItemID, Name, Type, Value} <hr> I was trying to write you an answer to you question, but as I dug down into your problem, I began to be unsure of what you are doing. Are you trying to create a dynamic table in your database?* Here is the rest of my answer: <hr> You need to figure out where your performance bottleneck is. Is it retrieving data or is it showing data. 15 seconds sound like a lot for data being shown. It should not take more than 1 to 2 seconds, IMHO. Here is a couple of tips: DataGrid is a heavy weight control that can do a lot of things. I would suggest you to use a ListView with a GridView and customize you out of what ever requirement you must have. ListView is virtualized by default. In 4.0 if you apply grouping virtualizatiion will be disabled. In 4.5 virtualization with grouping can be applied. Optimize the database query by using SQL Profiler. See which queries is executed. If a lot of queries are execute this could lead to bad performance. Doing eager loading in EF (with .Include) could help speed things up. Remember the proper indexes. To comment on Ladislav Mmka's comment it is not the whole truth. WPF controls does not support data virtualization (data is only fetched when shown). They only support normal virtualization where all data is present, but only the viewable part of the items are rendered. Big difference between the two. There are solutions out there that tries to do data virtualization in WPF. 
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POCaching large number of entities in WPF
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USMichael
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. COIn my opinion they shouldn't be merged. I explained it in more detail in my edited post. I will have a look into the ListView and the SQL Profiler
 singulars
 PostPostId
 PO
 UserUserId
 UStomfroehle

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.