When I test inserting a new photo album, the record gets added to the table in the database just fine. And I see the ID in the table. But PhotoAlbumId in the query string always shows 0.

http://localhost:50829/ManagePhotoAlbum?PhotoAlbumId=0

Any ideas at what to look at?
Note: there is no space after the ? in the query string below. It just appears that way in this forum post. Don't know why.


Public Sub DetailsView1_InsertItem()

Dim photoAlbum As New PHOTOALBUM()

TryUpdateModel(photoAlbum)

If ModelState.IsValid Then
Using myEntities As New PlanetWroxEntities()
myEntities.PHOTOALBUMs.Add(photoAlbum)
myEntities.SaveChanges()
End Using

Response.Redirect(String.Format("ManagePhotoAlbum? PhotoAlbumId={0}", photoAlbum.ID.ToString()))
End If

End Sub

Is ID the column in the database that has an identity? I.e. is that the column that auto-increments? Did you maybe make the column an identity in the database after you created the model? In that case, you have to regenerate the model as it may not be aware that the database generates the values for it.

Imar

__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!

Yes, the ID column does auto-increment. It works fine in the database. The record gets created with the next number for the ID. I also just executed "Update Model from Database" and tried it again but it didn't help.

I got it. I noticed in the model that the StoreGeneratedPattern property for the ID column was set to None. So I changed this to Identity and it works now. I'm using Oracle so it seems that the integration with VS is not so great as compared with SQL Server. I assume with SQL Server, this StoreGeneratedPattern property is automatically set?

Anyway .... it's working now. Thank you for your response. Much appreciated.

And this is a really good book by the way.

Ah, yes, that explains it. Didn't know you were using Oracle.

>> I assume with SQL Server, this StoreGeneratedPattern property is automatically set?

Yep.

Imar

__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!