I can not integrate a new table in my database because when I add it to my application of C#
I get the following error:
Severity Code Description Project File Line Status suppressed Error Error 75: Key part: 'EsReverso' for the type StatisticsConciliation is not valid. No part of the key must accept values NULL KonciliaEntities D: \ Projects2017 \ PopularTx \ KonciliaATM \ KonciliaEntities \ KonciliaTx.edmx 2434
Can someone help me?
This is the script I'm using to create the table:
CREATE TABLE [dbo].[Canje]( [IdCanje] [uniqueidentifier] NOT NULL, [NombreCanje] nvarchar NOT NULL, [CodigoCanje] [int] NOT NULL, CONSTRAINT [PK_Canje] PRIMARY KEY CLUSTERED ( [IdCanje] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY]
GO
Additional this is the script
of the table EstadisticaConcicliacion
:
CREATE TABLE [dbo].[EstadisticasConciliacion](
[ConjuntoProcesos] [varchar](100) NULL,
[NombreProceso] [varchar](100) NULL,
[FechaCompensacion] [smalldatetime] NOT NULL,
[FechaProceso] [smalldatetime] NOT NULL,
[Dispositivo] [varchar](20) NOT NULL,
[NoTx] [numeric](18, 0) NOT NULL,
[Valor] [numeric](18, 2) NULL,
[EsReverso] [bit] NULL,
[TipoTx] [varchar](100) NOT NULL,
[Autorizador] [varchar](50) NOT NULL,
[Adquiriente] [varchar](50) NOT NULL,
[TipoMovimiento] [varchar](30) NOT NULL,
[Aprobado] [bit] NULL,
[EsConsulta] [bit] NULL,
[EsConsistente] [bit] NULL,
[TipoTarjeta] [varchar](20) NULL,
CONSTRAINT [PK_EstadisticasConciliacion] PRIMARY KEY CLUSTERED
(
[FechaCompensacion] ASC,
[FechaProceso] ASC,
[Dispositivo] ASC,
[NoTx] ASC,
[TipoTx] ASC,
[Autorizador] ASC,
[Adquiriente] ASC,
[TipoMovimiento] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO