vs2012中EF6的BUG

BUG不怕，只要开源

 

1、无主键表序列化时会自动将所有非空列均设为主键列

 

 

-- Creating table 't_b_Camera'
CREATE TABLE [dbo].[t_b_Camera] (
    [f_CameraId] int IDENTITY(1,1) NOT NULL,
    [f_CameraName] nvarchar(255)  NOT NULL,
    [f_CameraIP] nvarchar(255)  NOT NULL,
    [f_CameraPort] int  NOT NULL,
    [f_CameraChannel] int  NOT NULL,
    [f_Enabled] int  NOT NULL,
    [f_CameraUser] nvarchar(255)  NULL,
    [f_CameraPassword] nvarchar(255)  NULL,
    [f_Type] int  NOT NULL,
    [f_Notes] nvarchar(max)  NULL
);
GO

  

 

-- Creating primary key on [f_CameraId], [f_CameraName], [f_CameraIP], [f_CameraPort], [f_CameraChannel], [f_Enabled], [f_Type] in table 't_b_Camera'
ALTER TABLE [dbo].[t_b_Camera]
ADD CONSTRAINT [PK_t_b_Camera]
    PRIMARY KEY CLUSTERED ([f_CameraId], [f_CameraName], [f_CameraIP], [f_CameraPort], [f_CameraChannel], [f_Enabled], [f_Type] ASC);
GO