c#杀人游戏源代码LINQ加SQL

CREATE DATABASE [killperson] .Net SqlClient Data Provider: Changed database context to 'killperson'.. SET ARITHABORT ON CREATE TABLE [dbo].[Activity]( [ActivityNo] Int NOT NULL IDENTITY, [GameNo] Int NOT NULL, [ActivityTypeID] Int, [RoundCount] Int NOT NULL, CONSTRAINT [PK_dbo.Activity] PRIMARY KEY ([ActivityNo]) ) CREATE TABLE [dbo].[Role]( [RoleID] Int NOT NULL, [Name] NVarChar(50) NOT NULL, CONSTRAINT [PK_dbo.Role] PRIMARY KEY ([RoleID]) ) CREATE TABLE [dbo].[ActivityType]( [ActivityTypeID] Int NOT NULL, [ActivityTypeName] NVarChar(50) NOT NULL, [TimeCollapse] Int NOT NULL, CONSTRAINT [PK_dbo.ActivityType] PRIMARY KEY ([ActivityTypeID]) ) CREATE TABLE [dbo].[Game]( [GameNo] Int NOT NULL IDENTITY, [StartTime] DateTime NOT NULL, [EndTime] DateTime, [WhoWin] Int, [CivilianNum] Int, [KillerNum] Int, [PoliceNum] Int, [GameName] NVarChar(50) NOT NULL, [GameStatus] Int, [EndpointAddress] NVarChar(200) NOT NULL, CONSTRAINT [PK_dbo.Game] PRIMARY KEY ([GameNo]) ) CREATE TABLE [dbo].[User]( [UserID] NVarChar(50) NOT NULL, [Name] NVarChar(50) NOT NULL, [IsOnline] Int NOT NULL, [WinNum] Int NOT NULL, [PlayNum] Int NOT NULL, [IP] NVarChar(200), [Password] NVarChar(4000) NOT NULL, CONSTRAINT [PK_dbo.User] PRIMARY KEY ([UserID]) ) CREATE TABLE [dbo].[Player]( [UserID] NVarChar(50) NOT NULL, [GameNo] Int NOT NULL, [IsActive] Int NOT NULL, [RoleID] Int NOT NULL, [DeadActivityNo] Int NOT NULL, CONSTRAINT [PK_dbo.Player] PRIMARY KEY ([UserID], [GameNo]) ) CREATE TABLE [dbo].[Vote]( [ActivityNo] Int NOT NULL, [RoundNo] Int NOT NULL, [Voter] NVarChar(50) NOT NULL, [Candidate] NVarChar(50) NOT NULL, CONSTRAINT [PK_dbo.Vote] PRIMARY KEY ([ActivityNo], [RoundNo], [Voter]) ) CREATE TABLE [GameStatus]( [StatusID] Int, [StatusName] NVarChar(50) NOT NULL, CONSTRAINT [PK_GameStatus] PRIMARY KEY ([StatusID]) ) ALTER TABLE [dbo].[Activity] ADD CONSTRAINT [ActivityType_Activity] FOREIGN KEY ([ActivityTypeID]) REFERENCES [dbo].[ActivityType]([ActivityTypeID]) ALTER TABLE [dbo].[Activity] ADD CONSTRAINT [Game_Activity] FOREIGN KEY ([GameNo]) REFERENCES [dbo].[Game]([GameNo]) ALTER TABLE [dbo].[Game] ADD CONSTRAINT [GameStatus_Game] FOREIGN KEY ([GameStatus]) REFERENCES [GameStatus]([StatusID]) ALTER TABLE [dbo].[Player] ADD CONSTRAINT [Game_Player] FOREIGN KEY ([GameNo]) REFERENCES [dbo].[Game]([GameNo]) ALTER TABLE [dbo].[Player] ADD CONSTRAINT [User_Player] FOREIGN KEY ([UserID]) REFERENCES [dbo].[User]([UserID]) ALTER TABLE [dbo].[Player] ADD CONSTRAINT [Role_Player] FOREIGN KEY ([RoleID]) REFERENCES [dbo].[Role]([RoleID]) ALTER TABLE [dbo].[Vote] ADD CONSTRAINT [Activity_Vote] FOREIGN KEY ([ActivityNo]) REFERENCES [dbo].[Activity]([ActivityNo]) ALTER TABLE [dbo].[Vote] ADD CONSTRAINT [User_Vote] FOREIGN KEY ([Voter]) REFERENCES [dbo].[User]([UserID]) ALTER TABLE [dbo].[Vote] ADD CONSTRAINT [User_Vote1] FOREIGN KEY ([Candidate]) REFERENCES [dbo].[User]([UserID]) INSERT INTO [dbo].[User]([UserID], [Name], [IsOnline], [WinNum], [PlayNum], [IP], [Password]) VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6) -- @p0: Input NVarChar (Size = 3; Prec = 0; Scale = 0) [tom] -- @p1: Input NVarChar (Size = 3; Prec = 0; Scale = 0) [tom] -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [0] -- @p3: Input Int (Size = 0; Prec = 0; Scale = 0) [0] -- @p4: Input Int (Size = 0; Prec = 0; Scale = 0) [0] -- @p5: Input NVarChar (Size = 0; Prec = 0; Scale = 0) [Null] -- @p6: Input NVarChar (Size = 3; Prec = 0; Scale = 0) [tom] -- Context: SqlProvider(Sql2005) Model: AttributedMetaModel Build: 3.5.20917.0 INSERT INTO [dbo].[User]([UserID], [Name], [IsOnline], [WinNum], [PlayNum], [IP], [Password]) VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6) -- @p0: Input NVarChar (Size = 5; Prec = 0; Scale = 0) [boler] -- @p1: Input NVarChar (Size = 5; Prec = 0; Scale = 0) [boler] -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [0] -- @p3: Input Int (Size = 0; Prec = 0; Scale = 0) [0] -- @p4: Input Int (Size = 0; Prec = 0; Scale = 0) [0] -- @p5: Input NVarChar (Size = 0; Prec = 0; Scale = 0) [Null] -- @p6: Input NVarChar (Size = 5; Prec = 0; Scale = 0) [boler] -- Context: SqlProvider(Sql2005) Model: AttributedMetaModel Build: 3.5.20917.0 INSERT INTO [dbo].[User]([UserID], [Name], [IsOnline], [WinNum], [PlayNum], [IP], [Password]) VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6) -- @p0: Input NVarChar (Size = 5; Prec = 0; Scale = 0) [peter] -- @p1: Input NVarChar (Size = 5; Prec = 0; Scale = 0) [peter] -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [0] -- @p3: Input Int (Size = 0; Prec = 0; Scale = 0) [0] -- @p4: Input Int (Size = 0; Prec = 0; Scale = 0) [0] -- @p5: Input NVarChar (Size = 0; Prec = 0; Scale = 0) [Null] -- @p6: Input NVarChar (Size = 5; Prec = 0; Scale = 0) [peter] -- Context: SqlProvider(Sql2005) Model: AttributedMetaModel Build: 3.5.20917.0 INSERT INTO [dbo].[User]([UserID], [Name], [IsOnline], [WinNum], [PlayNum], [IP], [Password]) VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6) -- @p0: Input NVarChar (Size = 4; Prec = 0; Scale = 0) [sean] -- @p1: Input NVarChar (Size = 4; Prec = 0; Scale = 0) [sean] -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [0] -- @p3: Input Int (Size = 0; Prec = 0; Scale = 0) [0] -- @p4: Input Int (Size = 0; Prec = 0; Scale = 0) [0] -- @p5: Input NVarChar (Size = 0; Prec = 0; Scale = 0) [Null] -- @p6: Input NVarChar (Size = 4; Prec = 0; Scale = 0) [sean] -- Context: SqlProvider(Sql2005) Model: AttributedMetaModel Build: 3.5.20917.0 INSERT INTO [dbo].[User]([UserID], [Name], [IsOnline], [WinNum], [PlayNum], [IP], [Password]) VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6) -- @p0: Input NVarChar (Size = 6; Prec = 0; Scale = 0) [cloudy] -- @p1: Input NVarChar (Size = 6; Prec = 0; Scale = 0) [cloudy] -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [0] -- @p3: Input Int (Size = 0; Prec = 0; Scale = 0) [0] -- @p4: Input Int (Size = 0; Prec = 0; Scale = 0) [0] -- @p5: Input NVarChar (Size = 0; Prec = 0; Scale = 0) [Null] -- @p6: Input NVarChar (Size = 6; Prec = 0; Scale = 0) [cloudy] -- Context: SqlProvider(Sql2005) Model: AttributedMetaModel Build: 3.5.20917.0 INSERT INTO [dbo].[Role]([RoleID], [Name]) VALUES (@p0, @p1) -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [1] -- @p1: Input NVarChar (Size = 8; Prec = 0; Scale = 0) [Civilian] -- Context: SqlProvider(Sql2005) Model: AttributedMetaModel Build: 3.5.20917.0 INSERT INTO [dbo].[Role]([RoleID], [Name]) VALUES (@p0, @p1) -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [2] -- @p1: Input NVarChar (Size = 6; Prec = 0; Scale = 0) [Killer] -- Context: SqlProvider(Sql2005) Model: AttributedMetaModel Build: 3.5.20917.0 INSERT INTO [dbo].[Role]([RoleID], [Name]) VALUES (@p0, @p1) -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [4] -- @p1: Input NVarChar (Size = 6; Prec = 0; Scale = 0) [Police] -- Context: SqlProvider(Sql2005) Model: AttributedMetaModel Build: 3.5.20917.0 INSERT INTO [GameStatus]([StatusID], [StatusName]) VALUES (@p0, @p1) -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [1] -- @p1: Input NVarChar (Size = 3; Prec = 0; Scale = 0) [Run] -- Context: SqlProvider(Sql2005) Model: AttributedMetaModel Build: 3.5.20917.0 INSERT INTO [GameStatus]([StatusID], [StatusName]) VALUES (@p0, @p1) -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [2] -- @p1: Input NVarChar (Size = 4; Prec = 0; Scale = 0) [Wait] -- Context: SqlProvider(Sql2005) Model: AttributedMetaModel Build: 3.5.20917.0 INSERT INTO [GameStatus]([StatusID], [StatusName]) VALUES (@p0, @p1) -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [4] -- @p1: Input NVarChar (Size = 4; Prec = 0; Scale = 0) [Dead] -- Context: SqlProvider(Sql2005) Model: AttributedMetaModel Build: 3.5.20917.0 INSERT INTO [dbo].[ActivityType]([ActivityTypeID], [Activi