- 浏览: 257318 次
- 性别:
- 来自: 北京
文章分类
- 全部博客 (293)
- web (1)
- [随笔分类]项目管理 (30)
- [随笔分类]WCF (14)
- 未分类 (1)
- [随笔分类]Linq (4)
- [随笔分类]C#基础 (24)
- 项目 (1)
- [网站分类]3.非技术区(技术之外的文章,但不要涉及任何政治内容) (8)
- [网站分类]1.首页原创精华.NET区(包含架构设计、设计模式)(对首页文章的要求:原创、高质量、经过认真思考并精心写作) (9)
- [随笔分类]Ubuntu (4)
- ASP.Net (1)
- [网站分类]2..NET新手区(用于发表不合适发表在首页的.NET技术文章,包括小经验、小技巧) (30)
- [随笔分类]ASP.NET MVC (20)
- [随笔分类]ASP.NET (3)
- [随笔分类]程序员厨房 (4)
- [随笔分类]英语学习 (28)
- [网站分类]4.其他技术区 (1)
- [随笔分类]Silverlight (12)
- [随笔分类]CodeSmith (8)
- [随笔分类]其他 (4)
- [随笔分类]Ruby (4)
- [发布至博客园首页] (34)
- [网站分类]其他技术区 (3)
- [随笔分类]Ruby on Rails (2)
- [网站分类].NET新手区 (33)
- [随笔分类]TDD (1)
- [随笔分类]不谈技术 (2)
- [网站分类]非技术区 (7)
最新评论
-
yicone:
You make a mistake when paste t ...
WCF步步为营(一):简单示例 -
jinweijie:
你好,这个实现不错,但是在用了scriptmanager以后就 ...
在服务器端保存ViewState
根据上一节的对象,我们创建数据库如下:
Book Shop Database script
<!---->SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Admin]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[Admin](
[AdminId] [int] IDENTITY(1,1) NOT NULL,
[AdminEmail] [nvarchar](100) NOT NULL,
[AdminName] [nvarchar](50) NOT NULL,
[AdminIsBlocked] [bit] NULL,
[AdminIsDeleted] [bit] NULL,
CONSTRAINT [PK_Admin] PRIMARY KEY CLUSTERED
(
[AdminId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Author]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[Author](
[AuthorId] [int] IDENTITY(1,1) NOT NULL,
[AuthorName] [nvarchar](100) NOT NULL,
[AuthorDescription] [nvarchar](200) NULL,
CONSTRAINT [PK_Author] PRIMARY KEY CLUSTERED
(
[AuthorId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Category]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[Category](
[CategoryId] [int] IDENTITY(1,1) NOT NULL,
[CategoryName] [nvarchar](200) NOT NULL,
CONSTRAINT [PK_Category] PRIMARY KEY CLUSTERED
(
[CategoryId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[User]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[User](
[UserId] [bigint] IDENTITY(1,1) NOT NULL,
[UserName] [nvarchar](100) NOT NULL,
[UserEmail] [nvarchar](100) NOT NULL,
[UserIsBlocked] [bit] NULL,
[UserIsDeleted] [bit] NULL,
[UserIntroduction] [nvarchar](200) NULL,
[UserJoinDate] [datetime] NOT NULL,
[UserPassword] [nvarchar](50) NOT NULL,
CONSTRAINT [PK_User] PRIMARY KEY CLUSTERED
(
[UserId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Book]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[Book](
[BookId] [bigint] IDENTITY(1,1) NOT NULL,
[BookName] [nvarchar](200) NOT NULL,
[BookAuthor] [int] NOT NULL,
[BookISBN] [nvarchar](100) NOT NULL,
[BookPictureAddress] [nvarchar](100) NULL,
[BookDescription] [nvarchar](200) NULL,
[BookPublishDate] [datetime] NULL,
[BookCategoryId] [int] NOT NULL,
CONSTRAINT [PK_Book] PRIMARY KEY CLUSTERED
(
[BookId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Book]') AND name = N'IX_Book')
CREATE NONCLUSTERED INDEX [IX_Book] ON [dbo].[Book]
(
[BookId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Comment]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[Comment](
[CommentId] [int] IDENTITY(1,1) NOT NULL,
[CommentContent] [nvarchar](200) NOT NULL,
[CommentDate] [datetime] NOT NULL,
[CommentIsDeleted] [bit] NULL,
[CommentUserId] [bigint] NOT NULL,
[CommentBookId] [bigint] NOT NULL,
CONSTRAINT [PK_Comment] PRIMARY KEY CLUSTERED
(
[CommentId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[OrderDetail]') AND type in (N'U'))
BEGIN
<!---->SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Admin]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[Admin](
[AdminId] [int] IDENTITY(1,1) NOT NULL,
[AdminEmail] [nvarchar](100) NOT NULL,
[AdminName] [nvarchar](50) NOT NULL,
[AdminIsBlocked] [bit] NULL,
[AdminIsDeleted] [bit] NULL,
CONSTRAINT [PK_Admin] PRIMARY KEY CLUSTERED
(
[AdminId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Author]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[Author](
[AuthorId] [int] IDENTITY(1,1) NOT NULL,
[AuthorName] [nvarchar](100) NOT NULL,
[AuthorDescription] [nvarchar](200) NULL,
CONSTRAINT [PK_Author] PRIMARY KEY CLUSTERED
(
[AuthorId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Category]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[Category](
[CategoryId] [int] IDENTITY(1,1) NOT NULL,
[CategoryName] [nvarchar](200) NOT NULL,
CONSTRAINT [PK_Category] PRIMARY KEY CLUSTERED
(
[CategoryId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[User]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[User](
[UserId] [bigint] IDENTITY(1,1) NOT NULL,
[UserName] [nvarchar](100) NOT NULL,
[UserEmail] [nvarchar](100) NOT NULL,
[UserIsBlocked] [bit] NULL,
[UserIsDeleted] [bit] NULL,
[UserIntroduction] [nvarchar](200) NULL,
[UserJoinDate] [datetime] NOT NULL,
[UserPassword] [nvarchar](50) NOT NULL,
CONSTRAINT [PK_User] PRIMARY KEY CLUSTERED
(
[UserId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Book]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[Book](
[BookId] [bigint] IDENTITY(1,1) NOT NULL,
[BookName] [nvarchar](200) NOT NULL,
[BookAuthor] [int] NOT NULL,
[BookISBN] [nvarchar](100) NOT NULL,
[BookPictureAddress] [nvarchar](100) NULL,
[BookDescription] [nvarchar](200) NULL,
[BookPublishDate] [datetime] NULL,
[BookCategoryId] [int] NOT NULL,
CONSTRAINT [PK_Book] PRIMARY KEY CLUSTERED
(
[BookId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Book]') AND name = N'IX_Book')
CREATE NONCLUSTERED INDEX [IX_Book] ON [dbo].[Book]
(
[BookId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Comment]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[Comment](
[CommentId] [int] IDENTITY(1,1) NOT NULL,
[CommentContent] [nvarchar](200) NOT NULL,
[CommentDate] [datetime] NOT NULL,
[CommentIsDeleted] [bit] NULL,
[CommentUserId] [bigint] NOT NULL,
[CommentBookId] [bigint] NOT NULL,
CONSTRAINT [PK_Comment] PRIMARY KEY CLUSTERED
(
[CommentId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[OrderDetail]') AND type in (N'U'))
BEGIN
发表评论
-
ASP.NET MVC+LINQ开发一个图书销售站点(1):需求分析
2008-03-25 13:41 810需求分析阶段 我们说先 ... -
ASP.NET MVC+LINQ开发一个图书销售站点(2):对象及其关系
2008-03-25 17:17 833经过对需求分析的提取,我们得到如下的对象及关系图 对象:目录对 ... -
ASP.NET MVC+LINQ开发一个图书销售站点(3):建立数据库
2008-03-25 17:57 942根据上一节的对象,我们创建数据库如下: Book Sh ... -
ASP.NET MVC+LINQ开发一个图书销售站点(4):创建一个ASP.NET MVC应用的原型
2008-03-26 14:09 761建完数据库,我们就可以开发了 1. 新建一个BookShop的 ... -
ASP.NET MVC+LINQ开发一个图书销售站点(6):创建数据层
2008-03-26 14:10 8061. 我们在Model下存放我们系统需要的数据,首先我们创建一 ... -
ASP.NET MVC+LINQ开发一个图书销售站点(5):创建逻辑层接口
2008-03-26 14:10 954我们先来用管理员界面的目录管理来熟悉一下流程 1. 我们希望同 ... -
ASP.NET MVC+LINQ开发一个图书销售站点(7):图书分类管理
2008-03-26 14:12 7341、浏览分类 a. 修改Contoller的为如下 using ... -
ASP.NET MVC+LINQ开发一个图书销售站点(8):表单验证
2008-03-26 17:32 757我们用AddCategory(添加图书目录这个页面来举例),我 ... -
ASP.NET MVC+LINQ开发一个图书销售站点(9):编辑目录
2008-03-28 17:57 930编辑目录和新建类似,这里我们用MVC提供的辅助类 1.在Mod ... -
ASP.NET MVC+LINQ开发一个图书销售站点(10):作者管理
2008-03-29 17:03 698作者添加、删除、修改,基本和前面的目录管理类似,这里我们更多的 ... -
ASP.NET MVC+LINQ开发一个图书销售站点(1):需求分析
2008-03-25 13:41 1892需求分析阶段 我们说先 ... -
ASP.NET MVC+LINQ开发一个图书销售站点(2):对象及其关系
2008-03-25 17:17 760经过对需求分析的提取,我们得到如下的对象及关系图 对象:目录对 ... -
ASP.NET MVC+LINQ开发一个图书销售站点(4):创建一个ASP.NET MVC应用的原型
2008-03-26 14:09 820建完数据库,我们就可以开发了 1. 新建一个BookShop的 ... -
ASP.NET MVC+LINQ开发一个图书销售站点(6):创建数据层
2008-03-26 14:10 8481. 我们在Model下存放我们系统需要的数据,首先我们创建一 ... -
ASP.NET MVC+LINQ开发一个图书销售站点(5):创建逻辑层接口
2008-03-26 14:10 745我们先来用管理员界面的目录管理来熟悉一下流程 1. 我们希望同 ... -
ASP.NET MVC+LINQ开发一个图书销售站点(7):图书分类管理
2008-03-26 14:12 9061、浏览分类 a. 修改Contoller的为如下 using ... -
ASP.NET MVC+LINQ开发一个图书销售站点(8):表单验证
2008-03-26 17:32 684我们用AddCategory(添加图书目录这个页面来举例),我 ... -
ASP.NET MVC+LINQ开发一个图书销售站点(9):编辑目录
2008-03-28 17:57 812编辑目录和新建类似,这里我们用MVC提供的辅助类 1.在Mod ... -
ASP.NET MVC+LINQ开发一个图书销售站点(10):作者管理
2008-03-29 17:03 745作者添加、删除、修改,基本和前面的目录管理类似,这里我们更多的 ...
相关推荐
这个压缩包文件"ASP.NET 3.5 开发大全+项目设计"可能包含了一本全面介绍ASP.NET 3.5开发的书籍或教程,以及相关的项目实例,旨在帮助学习者深入理解和实践ASP.NET 3.5的开发技术。 ASP.NET 3.5的关键特性包括: 1....
《ASP.NET2.0电子商务开发实战》是一本深入探讨如何使用ASP.NET 2.0框架进行电子商务网站构建的专业书籍。本书以C#编程语言为基础,为开发者提供了丰富的实践指导,旨在帮助读者掌握ASP.NET 2.0在电商领域的应用。 ...
《精通ASP.NET 4.0》是一本深入探讨ASP.NET技术的专业书籍,其配书源代码包含多个章节的实例,帮助读者更好地理解和实践所学知识。这些章节包括第11章、第13章、第7章、第10章、第5章、第6章、第4章、第9章、第14...
1.1.3 要点3:ASP.NET支持多语言 1.1.4 要点4:ASP.NET运行在公共语言运行库内 1.1.5 要点5:ASP.NET是面向对象的 1.1.6 要点6:ASP.NET支持所有的浏览器 1.1.7 要点7:ASP.NET易于部署和配置 1.2 ASP...
首先,ASP.NET 4.5是微软.NET Framework的一个重要组成部分,它为Web应用程序开发提供了丰富的工具和库。书中详细介绍了这个版本的新特性和改进,如异步处理模型的增强,这使得Web应用能够更好地处理高并发请求,...
【ASP.NET网站设计实例通】是一本专注于ASP.NET技术的实战型书籍,旨在帮助初学者和有一定基础的开发者深入理解并掌握ASP.NET平台下的网站设计与开发。书中的实例丰富,涵盖了许多实际项目中可能遇到的问题和解决...
4. ASP.NET MVC框架:虽然本书主要聚焦于ASP.NET Web Forms,但ASP.NET 3.5也引入了MVC(Model-View-Controller)框架,为开发者提供了一种替代Web Forms的开发模式,更适合大型、复杂应用的开发,强调分层架构和...
1.1.3 要点3:ASP.NET支持多语言 4 1.1.4 要点4:ASP.NET运行在公共语言运行库内 6 1.1.5 要点5:ASP.NET是面向对象的 7 1.1.6 要点6:ASP.NET支持所有的浏览器 8 1.1.7 要点7:ASP.NET易于部署和配置 8 ...
ASP.NET是微软公司推出的用于构建动态网站、Web应用和服务的开发平台,3.5版本是其一个重要里程碑,带来了许多新特性、改进和优化,为开发者提供了更强大的工具和更高效的开发环境。 ASP.NET 3.5基于.NET Framework...
4. MVC模式的引入:*** MVC是***的一个新框架,它引入了模型-视图-控制器设计模式,提供了更清晰的架构来开发Web应用程序。 知识点二:实战案例分析 1. MVC架构应用案例:通过实例讲解*** MVC在实际开发中的应用,...