Why does a newly created EF-entity throw an ID is null exception when trying to save?

Posted by Richard on Stack Overflow See other posts from Stack Overflow or by Richard
Published on 2010-05-15T03:42:53Z Indexed on 2010/05/15 3:54 UTC
Read the original article Hit count: 504

I´m trying out entity framework included in VS2010 but ´ve hit a problem with my database/model generated from the graphical interface.

When I do:

user = dataset.UserSet.CreateObject();
user.Id = Guid.NewGuid();
dataset.UserSet.AddObject(user);
dataset.SaveChanges();

{"Cannot insert the value NULL into column 'Id', table 'BarSoc2.dbo.UserSet'; column does not allow nulls. INSERT fails.\r\nThe statement has been terminated."}

The table i´m inserting into looks like so:

-- Creating table 'UserSet'
CREATE TABLE [dbo].[UserSet] (
    [Id] uniqueidentifier  NOT NULL,
    [Name] nvarchar(max)  NOT NULL,
    [Username] nvarchar(max)  NOT NULL,
    [Password] nvarchar(max)  NOT NULL
);
GO

-- Creating primary key on [Id] in table 'UserSet'
ALTER TABLE [dbo].[UserSet]
ADD CONSTRAINT [PK_UserSet]
    PRIMARY KEY CLUSTERED ([Id] ASC);
GO

Am I creating the object in the wrong way or doing something else basic wrong?

© Stack Overflow or respective owner

Related posts about entity-framework

Related posts about c#