Cannot insert explicit value for identity column in table 'PhotoAlbumTable' when IDEN

Katsune · March 22nd, 2014, 06:43 PM

I've been trying to figure out how to fix this for 4 hours now,.

I have my table's primary keys set to is identity YES for automatic assignment of a unique number, yet I'm still having this problem here's a part of my code:

HTML Code:

<asp:DetailsView ID="DetailsView1" runat="server" AutoGenerateRows="False" DataKeyNames="ID" DataSourceID="EntityDataSource1" DefaultMode="Insert" Height="50px" Width="125px">
        <Fields>
            <asp:BoundField DataField="ID" HeaderText="ID" ReadOnly="True" SortExpression="ID" InsertVisible="false"/>
            <asp:BoundField DataField="Name" HeaderText="Name" SortExpression="Name"  />
            <asp:CommandField ShowInsertButton="True" />
        </Fields>
    </asp:DetailsView>
    <asp:EntityDataSource ID="EntityDataSource1" runat="server" ConnectionString="name=AnimeCoffeeEntities" DefaultContainerName="AnimeCoffeeEntities" EnableFlattening="False" EntitySetName="PhotoAlbumTables" OnInserted="EntityDataSource1_Inserted" EnableInsert="True">
    </asp:EntityDataSource>

Here's my codebehind:

Code:

 protected void EntityDataSource1_Inserted(object sender, EntityDataSourceChangedEventArgs e)
    {
        if (e.Entity != null)
        {
            PhotoAlbumTable myPhotoAlbum = (PhotoAlbumTable)e.Entity;
            Response.Redirect(string.Format("~/Demos/ManagePhotoAlbum.aspx?PhotoAlbumID={0}", myPhotoAlbum.ID.ToString()));
        }
    }

By the way the naming of my tables are modified a little bit in a way that I can understand it better, like the PhotoAlbum to PhotoAlbumTable.

Thanks,

Imar · March 22nd, 2014, 06:51 PM

Can you provide the *full* code (markup and Code Behind) of both pages? Also, can you post the full URL from the browser's address bar for the page that raises the error?

Imar

Katsune · March 22nd, 2014, 07:46 PM

Here's the full aspx file:

HTML Code:

<%@ Page Title="Create Photo Album" Language="C#" MasterPageFile="~/MasterPages/Thread.master" AutoEventWireup="true" CodeFile="NewPhotoAlbum.aspx.cs" Inherits="Demos_NewPhotoAlbum" %>

<asp:Content ID="Content1" ContentPlaceHolderID="Thread" Runat="Server">

    <asp:DetailsView ID="DetailsView1" runat="server" AutoGenerateRows="False" DataKeyNames="ID" DataSourceID="EntityDataSource1" DefaultMode="Insert" Height="50px" Width="125px">
        <Fields>
            <%--<asp:BoundField DataField="ID" HeaderText="ID" ReadOnly="True" SortExpression="ID" InsertVisible="false"/>--%>
            <asp:BoundField DataField="Name" HeaderText="Name" SortExpression="Name"  />
            <asp:CommandField ShowInsertButton="true" />
        </Fields>
    </asp:DetailsView>
    <asp:EntityDataSource ID="EntityDataSource1" EnableInsert="true" runat="server" ConnectionString="name=AnimeCoffeeEntities" DefaultContainerName="AnimeCoffeeEntities" EnableFlattening="False" EntitySetName="PhotoAlbumTables" OnInserted="EntityDataSource1_Inserted">
    </asp:EntityDataSource>

</asp:Content>

Here's the codebehind:

HTML Code:

using AnimeCoffeeModel;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

public partial class Demos_NewPhotoAlbum : BasePage
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void EntityDataSource1_Inserted(object sender, EntityDataSourceChangedEventArgs e)
    {
        if (e.Entity != null)
        {
            PhotoAlbumTable myPhotoAlbum = (PhotoAlbumTable)e.Entity;
            Response.Redirect(string.Format("~/Demos/ManagePhotoAlbum.aspx?PhotoAlbumID={3}", myPhotoAlbum.ID.ToString()));



        }
    }
}

Here's the browser link on error:
http://localhost:49261/Demos/NewPhotoAlbum.aspx

also here's the full error:
Cannot insert explicit value for identity column in table 'PhotoAlbumTable' when IDENTITY_INSERT is set to OFF.

AnimeCoffee is the name of my mdf file by the way and my masterpage is nested from SuperPage.master(for header,nav, footer) to a masterpage for specific webforms, with this one it is Thread.master So it's like SuperPage.master->Thread.master

Imar · March 23rd, 2014, 08:55 AM

Did you set the Identity for the Id column before you created the EF diagram? Looks like EF thinks it needs to supply an explicit value. If you set the identity afterwards, go to the EF diagram, right-click and choose Update from database and then try again.

Cheers,

Imar

Katsune · March 23rd, 2014, 10:22 AM

Quote:

Originally Posted by Imar

Did you set the Identity for the Id column before you created the EF diagram? Looks like EF thinks it needs to supply an explicit value. If you set the identity afterwards, go to the EF diagram, right-click and choose Update from database and then try again.

Cheers,

Imar

Holy beast,... that was quick, it worked,.. I never tried to touch the diagram because I was afraid of ruining my relations..