Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1762
  • Last Modified:

WCF RIA Silverlight 4 Domain Service Key Attribute

I am getting the below error when trying to add a stored procedure to my project. It is asking for a key to be defined. I have never had to do this for a stored proc. How would I go about this?

I am using Linq To Sql with WCF RIA

Error      1      The entity 'SP_Role_AreasResult' in DomainService 'Operations_DS' does not have a key defined. Entities exposed by DomainService operations must have at least one public property marked with the KeyAttribute.      Operations_Client_Silverlight
0
jimseiwert
Asked:
jimseiwert
  • 2
1 Solution
 
tovvenkiCommented:
Hi,
you need to add the metadata containing the key in a separate class
check this http://forums.silverlight.net/forums/p/163636/369183.aspx

Thanks and regards,
Venki
0
 
jimseiwertAuthor Commented:
Maybe I am missing something but below is my code and the meta data but i still get the same error. What am i missing?
*************Meta Data
 <MetadataTypeAttribute(GetType(sp_role_areasresult.sp_role_areasresultMetadata))> _
    Partial Public Class sp_role_areasresult
        Friend NotInheritable Class sp_role_areasresultMetadata
            Private Sub New()
            End Sub

            <Key()> Public Area As String
            Public AreaOrder As Integer
        End Class
    End Class

************** My stored proc called in the domain service

    Public Function Role_Areas_Select(ByVal roleid As Integer) As IList(Of SP_Role_AreasResult)
        Return Me.DataContext.SP_Role_Areas(roleid).ToList()
    End Function

Open in new window

0
 
vbighamCommented:
Someone had this problem and found that they were referencing the wrong version of System.ComponentModel.DataAnnotations

See this forum:
http://forums.silverlight.net/forums/p/148346/370241.aspx

That being said.  I will usually specify the primary key in the database or in the edmx model, and not use DomainService metadata (or very little).  Are either of those an option (PK in db or Model)?
0
 
jimseiwertAuthor Commented:
After playing with this solution (way too long) I finally got it to work using the key function
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now