StoreGeneratedPattern = Identity but still get asked to provide a value RSS

• • Reply
  

  PuzzledGeek

  Member

  1 Points

  33 Posts

  StoreGeneratedPattern = Identity but still get asked to provide a value

  Dec 21, 2012 06:15 PM|LINK

  Hi, in the designer view I've set the StoreGeneratedPattern property of my userID field to Identity as I believe this makes it an auto number?

   

  Yet the EF code that was generated requires me to provide a value:
   

  public static tblUser CreatetblUser(global::System.Int32 userID, global::System.String email)

     {tblUser tblUser = new tblUser();

              tblUser.UserID = userID;

              tblUser.Email = email;

  return tblUser;  }

   

  What am I doing wrong?

• • Reply
  

  eric2820

  Contributor

  2777 Points

  1161 Posts

  Re: StoreGeneratedPattern = Identity but still get asked to provide a value

  Dec 21, 2012 09:33 PM|LINK

  Your need these on your key field if you want it to autogenerate:

      [Key]
      [DatabaseGenerated(DatabaseGeneratedOption.Identity)]
    decimal id {get; set;}
    ...

  Eric
  
  http://www.my-msi.net/Admin
  blog
  
  If a post helps you, please mark it as Ansered, thank-you.
  • Marked as answer by decker dong - msft on Dec 27, 2012 02:55 AM
• • Reply
  

  Decker Dong ...

  All-Star

  118619 Points

  18779 Posts

  Re: StoreGeneratedPattern = Identity but still get asked to provide a value

  Dec 22, 2012 08:08 AM|LINK

  PuzzledGeek

  in the designer view I've set the StoreGeneratedPattern property of my userID field to Identity as I believe this makes it an auto number?

  Yes, but please make sure that your real db's column's DefaultValue should be also set to newid().

  What's more, if you are using EF(Code-first), you cann take 2nd man's advice.

  Reguards!