StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
10371359
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2012-04-29T10:21:20.337
FavoriteCount
0
LastActivityDate
2012-04-29T10:21:20.337
LastEditDate
LastEditorUserId
0
OwnerUserId
600188
ParentId
10362333
PostTypeId
2
Score
3
ViewCount
0
LastEditorDisplayName
text
Body
Think i have part of my answer. By reading a lot more about TextTemplatesTransformations i have modified my Model1.tt to include: <pre><code>System.ComponentModel.DataAnnotations; </code></pre> i have also modified the WriteProperty method to accept an EdmPropertyType. The code now generates multiline annotations for all strings which came from a specified length > 60 or max defined strings. It also generates a maxlength annotation which should hopefully help prevent overflow. If using you will need to modify both the existing WriteProperty overloads as below. <pre><code>void WriteProperty(CodeGenerationTools code, EdmProperty edmProperty) { WriteProperty(Accessibility.ForProperty(edmProperty), code.Escape(edmProperty.TypeUsage), code.Escape(edmProperty), code.SpaceAfter(Accessibility.ForGetter(edmProperty)), code.SpaceAfter(Accessibility.ForSetter(edmProperty)),edmProperty); } void WriteProperty(string accessibility, string type, string name, string getterAccessibility, string setterAccessibility,EdmProperty edmProperty = null) { if (type =="string") { int maxLength = 0;//66 bool bres = (edmProperty != null && Int32.TryParse(edmProperty.TypeUsage.Facets["MaxLength"].Value.ToString(), out maxLength)); if (maxLength > 60) // want to display as a TextArea in html { #> [DataType(DataType.MultilineText)] [MaxLength(<#=maxLength#>)] <#+ } else if (maxLength < 61 && maxLength > 0) { #> [MaxLength(<#=maxLength#>)] <#+ } else if(maxLength <=0) //varchar(max) { #> [DataType(DataType.MultilineText)] <#+ } } #> <#=accessibility#> <#=type#> <#=name#> { <#=getterAccessibility#>get; <#=setterAccessibility#>set; } <#+ } </code></pre> Ensure that the <#+ lines and the #> lines start at the begining of the line as i think this is a requirement of the TT syntax. Tim
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POHtml.EditorFor and multiline textboxes in mvc4 and EF
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USTim
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. POHtml.EditorFor and multiline textboxes in mvc4 and EF
 singulars
 PostTypePostTypeId
 PTQuestion
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTAcceptedByOriginator
2. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
3. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. This table or related slice is empty.

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.