EntityMapping Error.
От: EyfelFenk Россия  
Дата: 25.03.10 10:38
Оценка:
Во время маппинга вот такие ошибки вылезают:

Error 4 Error 2016: Condition cannot be specified for Column member 'player_id_1' because it is marked with a 'Computed' or 'Identity' StoreGeneratedPattern. C:\WorkFiles\Juggers\VS\RoomOfInquisitor\roi\ROIServerDLL\ServerDBModel.edmx 1223 13 ROIServerDLL
Error 5 Error 2016: Condition cannot be specified for Column member 'player_id_2' because it is marked with a 'Computed' or 'Identity' StoreGeneratedPattern. C:\WorkFiles\Juggers\VS\RoomOfInquisitor\roi\ROIServerDLL\ServerDBModel.edmx 1232 13 ROIServerDLL
Error 6 Error 2016: Condition cannot be specified for Column member 'command_id_1' because it is marked with a 'Computed' or 'Identity' StoreGeneratedPattern. C:\WorkFiles\Juggers\VS\RoomOfInquisitor\roi\ROIServerDLL\ServerDBModel.edmx 1249 13 ROIServerDLL
Error 7 Error 2016: Condition cannot be specified for Column member 'command_id_2' because it is marked with a 'Computed' or 'Identity' StoreGeneratedPattern. C:\WorkFiles\Juggers\VS\RoomOfInquisitor\roi\ROIServerDLL\ServerDBModel.edmx 1258 13 ROIServerDLL


Табличка у меня следюущая:
USE [jugger]
GO

/****** Object:  Table [dbo].[tr_fights]    Script Date: 03/25/2010 13:37:00 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[tr_fights](
    [id] [int] IDENTITY(1,1) NOT NULL,
    [part_id] [int] NOT NULL,
    [command_id_1] [int] NULL,
    [command_id_2] [int] NULL,
    [player_id_1] [int] NULL,
    [player_id_2] [int] NULL,
    [winner_id] [int] NOT NULL,
    [guid] [varchar](50) NOT NULL,
    [linktolog] [varchar](100) NULL,
    [seria_guid] [varchar](50) NOT NULL,
 CONSTRAINT [PK_tr_fights] PRIMARY KEY CLUSTERED 
(
    [id] 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

SET ANSI_PADDING OFF
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Ссылка на лог боя' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tr_fights', @level2type=N'COLUMN',@level2name=N'linktolog'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Идентификатор серии боев.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tr_fights', @level2type=N'COLUMN',@level2name=N'seria_guid'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Собственно сами бои' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tr_fights'
GO

ALTER TABLE [dbo].[tr_fights]  WITH CHECK ADD  CONSTRAINT [FK_tr_fights_players] FOREIGN KEY([player_id_1])
REFERENCES [dbo].[players] ([id])
GO

ALTER TABLE [dbo].[tr_fights] CHECK CONSTRAINT [FK_tr_fights_players]
GO

ALTER TABLE [dbo].[tr_fights]  WITH CHECK ADD  CONSTRAINT [FK_tr_fights_players1] FOREIGN KEY([player_id_2])
REFERENCES [dbo].[players] ([id])
GO

ALTER TABLE [dbo].[tr_fights] CHECK CONSTRAINT [FK_tr_fights_players1]
GO

ALTER TABLE [dbo].[tr_fights]  WITH CHECK ADD  CONSTRAINT [FK_tr_fights_players2] FOREIGN KEY([winner_id])
REFERENCES [dbo].[players] ([id])
GO

ALTER TABLE [dbo].[tr_fights] CHECK CONSTRAINT [FK_tr_fights_players2]
GO

ALTER TABLE [dbo].[tr_fights]  WITH CHECK ADD  CONSTRAINT [FK_tr_fights_tr_commands] FOREIGN KEY([command_id_1])
REFERENCES [dbo].[tr_commands] ([id])
GO

ALTER TABLE [dbo].[tr_fights] CHECK CONSTRAINT [FK_tr_fights_tr_commands]
GO

ALTER TABLE [dbo].[tr_fights]  WITH CHECK ADD  CONSTRAINT [FK_tr_fights_tr_commands1] FOREIGN KEY([command_id_2])
REFERENCES [dbo].[tr_commands] ([id])
GO

ALTER TABLE [dbo].[tr_fights] CHECK CONSTRAINT [FK_tr_fights_tr_commands1]
GO

ALTER TABLE [dbo].[tr_fights]  WITH CHECK ADD  CONSTRAINT [FK_tr_fights_tr_part] FOREIGN KEY([part_id])
REFERENCES [dbo].[tr_part] ([id])
GO

ALTER TABLE [dbo].[tr_fights] CHECK CONSTRAINT [FK_tr_fights_tr_part]
GO


Получается, что у меня в одной таблице не может быть 3 ссылки на одну и туже таблицу?
... << RSDN@Home 1.2.0 alpha 4 rev. 1446>>
 
Подождите ...
Wait...
Пока на собственное сообщение не было ответов, его можно удалить.