I can not create a new table in C #

1

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
    
asked by Jhon Bohorquez 27.11.2018 в 22:05
source

0 answers