Chapter 14, Page 509

N_B · July 7th, 2017, 01:04 PM

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

Imar · July 9th, 2017, 03:38 PM

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

N_B · July 10th, 2017, 01:37 PM

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.

N_B · July 10th, 2017, 03:28 PM

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.

Imar · July 13th, 2017, 03:41 AM

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