当前文件路径：LinqDemo/App_Data/DutyDemo.sql

		            
 1SET ANSI_NULLS ON
 2GO
 3SET QUOTED_IDENTIFIER ON
 4GO
 5IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[DutyStaff]') AND type in (N'U'))
 6BEGIN
 7CREATE TABLE [dbo].[DutyStaff](
 8    [ID] [int] IDENTITY(1,1) NOT NULL,
 9    [StaffName] [nvarchar](50) NOT NULL,
10    [StaffAge] [int] NOT NULL,
11 CONSTRAINT [PK_DutyStaff] PRIMARY KEY CLUSTERED 
12(
13    [ID] ASC
14)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
15) ON [PRIMARY]
16END
17--Download from 51aspx.com/cv/LinqDemo