备案控制台
探索云世界
开发者社区 数据库 文章 正文

[翻译]ADO.NET Entity Framework Beta2(六)/快速入门（实体框架）（1）/创建学校演示数据库

2016-11-28 2004
版权
版权声明：
本文内容由阿里云实名注册用户自发贡献，版权归原作者所有，阿里云开发者社区不拥有其著作权，亦不承担相应法律责任。具体规则请查看《 阿里云开发者社区用户服务协议》和 《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容，填写 侵权投诉表单进行举报，一经查实，本社区将立刻删除涉嫌侵权内容。
本文涉及的产品
云数据库 RDS SQL Server，独享型 2核4GB
推荐场景：
SQL Server性能诊断案例分析
简介：

In this task, you will create the schema for the School database and load data into the database. To do this, you use SQL Server Management Studio or SQL Server Management Studio Express to execute a Transact-SQL script. The resulting School database is used as the relational data store in the rest of the tasks in this quickstart.

在本任务中，你将创建学校数据库架构并填充数据。你要使用SQL Server 管理中心或 SQL Server Express管理中心来执行一个TSQL脚本。生成的数据库将在剩下的快速入门任务中作为关系型数据库被使用。

To create the School database and schema/创建数据库及架构

  1. On the File menu, point to New, and then click Database Engine Query. 在文件菜单，点击新建，然后单击数据库引擎查询。

  2. In the Connect to Database Engine dialog box, type either localhost or the name of the local SQL Server instance, and then click Connect.在连接到数据库引擎对话框，输入Loccalhost或者本地SQL Server的实例名，然后单击连接

  3. Paste the following Transact-SQL script in the query window and then click Execute.粘贴以下TSQL脚本到查询窗口并单击工具栏上的执行按钮。


    		 
    SET ANSI_NULLS ON
    
GO
    
SET QUOTED_IDENTIFIER ON
    
GO

    
USE [master];
    
GO

    
IF EXISTS (SELECT * FROM sys.databases WHERE name = 'School')
    
DROP DATABASE School;
    
GO

    
-- Create the School database.
    
CREATE DATABASE School;
    
GO

    
USE School;
    
GO

    
-- Create the Course table.
    
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = 
    
OBJECT_ID(N'[dbo].[Course]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
    
BEGIN
    
CREATE TABLE [dbo].[Course](
    
[CourseID] [int] NOT NULL,
    
[Title] [nvarchar](100) NOT NULL,
    
[StartDate] [datetime] NULL,
    
[EndDate] [datetime] NULL,
    
[Credits] [int] NULL,
    
CONSTRAINT [PK_School.Course] PRIMARY KEY CLUSTERED 
    
(
    
[CourseID] ASC
    
) ON [PRIMARY]
    
) ON [PRIMARY]
    
END
    
GO

    
-- Create the Person table.
    
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = 
    
OBJECT_ID(N'[dbo].[Person]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
    
BEGIN
    
CREATE TABLE [dbo].[Person](
    
[PersonID] [int] IDENTITY(1,1) NOT NULL,
    
[LastName] [nvarchar](50) NOT NULL,
    
[FirstName] [nvarchar](50) NOT NULL,
    
[HireDate] [datetime] NULL,
    
[EnrollmentDate] [datetime] NULL,
    
CONSTRAINT [PK_School.Student] PRIMARY KEY CLUSTERED 
    
(
    
[PersonID] ASC
    
) ON [PRIMARY]
    
) ON [PRIMARY]
    
END
    
GO

    
-- Create the Enrollment table.
    
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = 
    
OBJECT_ID(N'[dbo].[Enrollment]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
    
BEGIN
    
CREATE TABLE [dbo].[Enrollment](
    
[EnrollmentID] [int] IDENTITY(1,1) NOT NULL,
    
[CourseID] [int] NOT NULL,
    
[StudentPersonID] [int] NOT NULL,
    
[Grade] [decimal](3, 2) NULL,
    
CONSTRAINT [PK_Enrollment] PRIMARY KEY CLUSTERED 
    
(
    
[EnrollmentID] ASC
    
) ON [PRIMARY]
    
) ON [PRIMARY]
    
END
    
GO

    
-- Create the CourseInstructor table.
    
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[CourseInstructor]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
    
BEGIN
    
CREATE TABLE [dbo].[CourseInstructor](
    
[CourseInstructorID] [int] IDENTITY(1,1) NOT NULL,
    
[CourseID] [int] NOT NULL,
    
[PersonID] [int] NOT NULL,
    
CONSTRAINT [PK_CourseInstructor] PRIMARY KEY CLUSTERED 
    
(
    
[CourseInstructorID] ASC
    
) ON [PRIMARY]
    
) ON [PRIMARY]
    
END
    
GO

    
-- Define the relationship between Enrollment and Course.
    
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_Enrollment_Course]') AND type = 'F')
    
ALTER TABLE [dbo].[Enrollment]  WITH CHECK ADD  CONSTRAINT [FK_Enrollment_Course] FOREIGN KEY([CourseID])
    
REFERENCES [dbo].[Course] ([CourseID])
    
GO

    
ALTER TABLE [dbo].[Enrollment] CHECK CONSTRAINT [FK_Enrollment_Course]
    
GO

    
-- Define the relationship between Enrollment and Person.
    
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_Enrollment_Student]') AND type = 'F')
    
ALTER TABLE [dbo].[Enrollment]  WITH CHECK ADD  CONSTRAINT [FK_Enrollment_Student] FOREIGN KEY([StudentPersonID])
    
REFERENCES [dbo].[Person] ([PersonID])
    
GO

    
ALTER TABLE [dbo].[Enrollment] CHECK CONSTRAINT [FK_Enrollment_Student]
    
GO

    
-- Define the relationship between CourseInstructor and Course.
    
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_CourseInstructor_Course]') AND type = 'F')
    
ALTER TABLE [dbo].[CourseInstructor]  WITH CHECK ADD  CONSTRAINT [FK_CourseInstructor_Course] FOREIGN KEY([CourseID])
    
REFERENCES [dbo].[Course] ([CourseID])
    
GO

    
ALTER TABLE [dbo].[CourseInstructor] CHECK CONSTRAINT [FK_CourseInstructor_Course]
    
GO

    
-- Define the relationship between CourseInstructor and Person.
    
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_CourseInstructor_Person]') AND type = 'F')
    
ALTER TABLE [dbo].[CourseInstructor]  WITH CHECK ADD  CONSTRAINT [FK_CourseInstructor_Person] FOREIGN KEY([PersonID])
    
REFERENCES [dbo].[Person] ([PersonID])
    
GO

    
ALTER TABLE [dbo].[CourseInstructor] CHECK CONSTRAINT [FK_CourseInstructor_Person]
    
GO

    
-- Insert data into the Person table.
    
USE School
    
GO
    
SET IDENTITY_INSERT dbo.Person ON
    
GO
    
INSERT INTO dbo.Person (PersonID, LastName, FirstName, HireDate, EnrollmentDate)
    
VALUES (1, 'Abercrombie', 'Kim', '1995-03-11', null);
    
INSERT INTO dbo.Person (PersonID, LastName, FirstName, HireDate, EnrollmentDate)
    
VALUES (2, 'Barzdukas', 'Gytis', null, '2005-09-01');
    
INSERT INTO dbo.Person (PersonID, LastName, FirstName, HireDate, EnrollmentDate)
    
VALUES (3, 'Justice', 'Peggy', null, '2001-09-01');
    
INSERT INTO dbo.Person (PersonID, LastName, FirstName, HireDate, EnrollmentDate)
    
VALUES (4, 'Fakhouri', 'Fadi', '2002-08-06', null);
    
INSERT INTO dbo.Person (PersonID, LastName, FirstName, HireDate, EnrollmentDate)
    
VALUES (5, 'Harui', 'Roger', '1998-07-01', null);
    
INSERT INTO dbo.Person (PersonID, LastName, FirstName, HireDate, EnrollmentDate)
    
VALUES (6, 'Li', 'Yan', null, '2002-09-01');
    
INSERT INTO dbo.Person (PersonID, LastName, FirstName, HireDate, EnrollmentDate)
    
VALUES (7, 'Norman', 'Laura', null, '2003-09-01');
    
INSERT INTO dbo.Person (PersonID, LastName, FirstName, HireDate, EnrollmentDate)
    
VALUES (8, 'Olivotto', 'Nino', null, '2005-09-01');
    
INSERT INTO dbo.Person (PersonID, LastName, FirstName, HireDate, EnrollmentDate)
    
VALUES (9, 'Tang', 'Wayne', null, '2005-09-01');
    
INSERT INTO dbo.Person (PersonID, LastName, FirstName, HireDate, EnrollmentDate)
    
VALUES (10, 'Alonso', 'Meredith', null, '2002-09-01');
    
INSERT INTO dbo.Person (PersonID, LastName, FirstName, HireDate, EnrollmentDate)
    
VALUES (11, 'Lopez', 'Sophia', null, '2004-09-01');
    
INSERT INTO dbo.Person (PersonID, LastName, FirstName, HireDate, EnrollmentDate)
    
VALUES (12, 'Browning', 'Meredith', null, '2000-09-01');
    
INSERT INTO dbo.Person (PersonID, LastName, FirstName, HireDate, EnrollmentDate)
    
VALUES (13, 'Anand', 'Arturo', null, '2003-09-01');
    
INSERT INTO dbo.Person (PersonID, LastName, FirstName, HireDate, EnrollmentDate)
    
VALUES (14, 'Walker', 'Alexandra', null, '2000-09-01');
    
INSERT INTO dbo.Person (PersonID, LastName, FirstName, HireDate, EnrollmentDate)
    
VALUES (15, 'Powell', 'Carson', null, '2004-09-01');
    
INSERT INTO dbo.Person (PersonID, LastName, FirstName, HireDate, EnrollmentDate)
    
VALUES (16, 'Jai', 'Damien', null, '2001-09-01');
    
INSERT INTO dbo.Person (PersonID, LastName, FirstName, HireDate, EnrollmentDate)
    
VALUES (17, 'Carlson', 'Robyn', null, '2005-09-01');
    
INSERT INTO dbo.Person (PersonID, LastName, FirstName, HireDate, EnrollmentDate)
    
VALUES (18, 'Zheng', 'Roger', '2004-02-12', null);
    
INSERT INTO dbo.Person (PersonID, LastName, FirstName, HireDate, EnrollmentDate)
    
VALUES (19, 'Bryant', 'Carson', null, '2001-09-01');
    
INSERT INTO dbo.Person (PersonID, LastName, FirstName, HireDate, EnrollmentDate)
    
VALUES (20, 'Suarez', 'Robyn', null, '2004-09-01');
    
INSERT INTO dbo.Person (PersonID, LastName, FirstName, HireDate, EnrollmentDate)
    
VALUES (21, 'Holt', 'Roger', null, '2004-09-01');
    
INSERT INTO dbo.Person (PersonID, LastName, FirstName, HireDate, EnrollmentDate)
    
VALUES (22, 'Alexander', 'Carson', null, '2005-09-01');
    
INSERT INTO dbo.Person (PersonID, LastName, FirstName, HireDate, EnrollmentDate)
    
VALUES (23, 'Morgan', 'Isaiah', null, '2001-09-01');
    
INSERT INTO dbo.Person (PersonID, LastName, FirstName, HireDate, EnrollmentDate)
    
VALUES (24, 'Martin', 'Randall', null, '2005-09-01');
    
INSERT INTO dbo.Person (PersonID, LastName, FirstName, HireDate, EnrollmentDate)
    
VALUES (25, 'Kapoor', 'Candace', '2001-01-15', null);
    
INSERT INTO dbo.Person (PersonID, LastName, FirstName, HireDate, EnrollmentDate)
    
VALUES (26, 'Rogers', 'Cody', null, '2002-09-01');
    
INSERT INTO dbo.Person (PersonID, LastName, FirstName, HireDate, EnrollmentDate)
    
VALUES (27, 'Serrano', 'Stacy', '1999-06-01', null);
    
INSERT INTO dbo.Person (PersonID, LastName, FirstName, HireDate, EnrollmentDate)
    
VALUES (28, 'White', 'Anthony', null, '2001-09-01');
    
INSERT INTO dbo.Person (PersonID, LastName, FirstName, HireDate, EnrollmentDate)
    
VALUES (29, 'Griffin', 'Rachel', null, '2004-09-01');
    
INSERT INTO dbo.Person (PersonID, LastName, FirstName, HireDate, EnrollmentDate)
    
VALUES (30, 'Shan', 'Alicia', null, '2003-09-01');
    
INSERT INTO dbo.Person (PersonID, LastName, FirstName, HireDate, EnrollmentDate)
    
VALUES (31, 'Stewart', 'Jasmine', '2000-02-12', null);
    
GO
    
SET IDENTITY_INSERT dbo.Person OFF
    
GO

    
-- Insert data into the Course table.
    
INSERT INTO dbo.Course (CourseID, Title, StartDate, EndDate, Credits)
    
VALUES (4050, 'Math', '2007-09-01', '2007-09-01', 4);
    
INSERT INTO dbo.Course (CourseID, Title, StartDate, EndDate, Credits)
    
VALUES (4051, 'Science', '2007-09-01', '2007-09-01', 4);
    
INSERT INTO dbo.Course (CourseID, Title, StartDate, EndDate, Credits)
    
VALUES (3030, 'Art', '2007-09-01', '2007-09-01', 3);
    
INSERT INTO dbo.Course (CourseID, Title, StartDate, EndDate, Credits)
    
VALUES (2021, 'Woodshop', '2007-09-01', '2007-09-01', 2);
    
INSERT INTO dbo.Course (CourseID, Title, StartDate, EndDate, Credits)
    
VALUES (2022, 'Cooking', '2007-09-01', '2007-09-01', 2);
    
INSERT INTO dbo.Course (CourseID, Title, StartDate, EndDate, Credits)
    
VALUES (4041, 'History', '2007-09-01', '2007-09-01', 4);
    
INSERT INTO dbo.Course (CourseID, Title, StartDate, EndDate, Credits)
    
VALUES (4042, 'Literature', '2007-09-01', '2007-09-01', 4);
    
GO

    
-- Insert data into the CourseInstructor table.
    
SET IDENTITY_INSERT dbo.CourseInstructor ON
    
GO
    
INSERT INTO dbo.CourseInstructor(CourseInstructorID, CourseID, PersonID)
    
VALUES (1, 4051, 1);
    
INSERT INTO dbo.CourseInstructor(CourseInstructorID, CourseID, PersonID)
    
VALUES (2, 2021, 31);
    
INSERT INTO dbo.CourseInstructor(CourseInstructorID, CourseID, PersonID)
    
VALUES (3, 2022, 5);
    
INSERT INTO dbo.CourseInstructor(CourseInstructorID, CourseID, PersonID)
    
VALUES (4, 3030, 4);
    
INSERT INTO dbo.CourseInstructor(CourseInstructorID, CourseID, PersonID)
    
VALUES (5, 4041, 27);
    
INSERT INTO dbo.CourseInstructor(CourseInstructorID, CourseID, PersonID)
    
VALUES (6, 4042, 25);
    
INSERT INTO dbo.CourseInstructor(CourseInstructorID, CourseID, PersonID)
    
VALUES (7, 4050, 18);
    
GO
    
SET IDENTITY_INSERT dbo.CourseInstructor OFF
    
GO

    
-- Insert data into the Enrollment table.
    
INSERT INTO dbo.Enrollment (CourseID, StudentPersonID, Grade)
    
VALUES (2021, 2, 4);
    
INSERT INTO dbo.Enrollment (CourseID, StudentPersonID, Grade)
    
VALUES (2021, 3, 3);
    
INSERT INTO dbo.Enrollment (CourseID, StudentPersonID, Grade)
    
VALUES (2022, 6, 2.5);
    
INSERT INTO dbo.Enrollment (CourseID, StudentPersonID, Grade)
    
VALUES (2022, 7, 3.5);
    
INSERT INTO dbo.Enrollment (CourseID, StudentPersonID, Grade)
    
VALUES (2022, 8, 3);
    
INSERT INTO dbo.Enrollment (CourseID, StudentPersonID, Grade)
    
VALUES (4041, 9, 3.5);
    
INSERT INTO dbo.Enrollment (CourseID, StudentPersonID, Grade)
    
VALUES (4041, 10, null);
    
INSERT INTO dbo.Enrollment (CourseID, StudentPersonID, Grade)
    
VALUES (4041, 11, 2.5);
    
INSERT INTO dbo.Enrollment (CourseID, StudentPersonID, Grade)
    
VALUES (4041, 12, null);
    
INSERT INTO dbo.Enrollment (CourseID, StudentPersonID, Grade)
    
VALUES (4041, 13, 4);
    
INSERT INTO dbo.Enrollment (CourseID, StudentPersonID, Grade)
    
VALUES (4042, 14, 3);
    
INSERT INTO dbo.Enrollment (CourseID, StudentPersonID, Grade)
    
VALUES (4050, 15, 2.5);
    
INSERT INTO dbo.Enrollment (CourseID, StudentPersonID, Grade)
    
VALUES (4050, 16, 2);
    
INSERT INTO dbo.Enrollment (CourseID, StudentPersonID, Grade)
    
VALUES (4050, 17, null);
    
INSERT INTO dbo.Enrollment (CourseID, StudentPersonID, Grade)
    
VALUES (4050, 19, 3.5);
    
INSERT INTO dbo.Enrollment (CourseID, StudentPersonID, Grade)
    
VALUES (4050, 20, 4);
    
INSERT INTO dbo.Enrollment (CourseID, StudentPersonID, Grade)
    
VALUES (4050, 21, 2);
    
INSERT INTO dbo.Enrollment (CourseID, StudentPersonID, Grade)
    
VALUES (4050, 22, 3);
    
INSERT INTO dbo.Enrollment (CourseID, StudentPersonID, Grade)
    
VALUES (4041, 22, 3.5);
    
INSERT INTO dbo.Enrollment (CourseID, StudentPersonID, Grade)
    
VALUES (2022, 22, 2.5);
    
INSERT INTO dbo.Enrollment (CourseID, StudentPersonID, Grade)
    
VALUES (4051, 22, 3);
    
INSERT INTO dbo.Enrollment (CourseID, StudentPersonID, Grade)
    
VALUES (4051, 23, 1.5);
    
INSERT INTO dbo.Enrollment (CourseID, StudentPersonID, Grade)
    
VALUES (4051, 24, 4);
    
INSERT INTO dbo.Enrollment (CourseID, StudentPersonID, Grade)
    
VALUES (4051, 26, 3.5);
    
INSERT INTO dbo.Enrollment (CourseID, StudentPersonID, Grade)
    
VALUES (4051, 28, 2.5);
    
INSERT INTO dbo.Enrollment (CourseID, StudentPersonID, Grade)
    
VALUES (4051, 29, 3);
    
INSERT INTO dbo.Enrollment (CourseID, StudentPersonID, Grade)
    
VALUES (3030, 30, 3.5);
    
GO

Next Steps/下一H

You have successfully created the School database. Next, you will create the class scheduling application:

你已经成功创建了学校数据库，下面你将创建ClassScheduling用程序。

Creating the Class Schedule Application/创建ClassSchedule应用程序.

See Also/请参考

作者： 徐少侠
出处： http://www.cnblogs.com/Chinese-xu/

本文版权归作者和博客园共有，欢迎转载，但未经作者同意必须保留此段声明，且在文章页面明显位置给出原文连接。
如有问题，可以通过 Chinese_Xu@126.com 联系我，非常感谢。

分享家:Addthis中文版

本文转自徐少侠博客园博客，原文链接：http://www.cnblogs.com/Chinese-xu/archive/2007/09/21/901232.html，如需转载请自行联系原作者
文章标签：
云数据库 RDS SQL Server 版
Go
数据库
SQL
关键词：
.NET框架
数据库ado.net
ado.net数据库
数据库快速入门
.NET entityframework
相关实践学习
使用SQL语句管理索引
本次实验主要介绍如何在RDS-SQLServer数据库中，使用SQL语句管理索引。
SQL Server on Linux入门教程
SQL Server数据库一直只提供Windows下的版本。2016年微软宣布推出可运行在Linux系统下的SQL Server数据库，该版本目前还是早期预览版本。本课程主要介绍SQLServer On Linux的基本知识。 相关的阿里云产品：云数据库RDS SQL Server版 RDS SQL Server不仅拥有高可用架构和任意时间点的数据恢复功能，强力支撑各种企业应用，同时也包含了微软的License费用，减少额外支出。 了解产品详情: https://www.aliyun.com/product/rds/sqlserver
长征6号
目录
相关文章
追逐时光者
|
16天前
|
数据可视化 网络协议 C#
C#/.NET/.NET Core优秀项目和框架2024年3月简报
公众号每月定期推广和分享的C#/.NET/.NET Core优秀项目和框架（每周至少会推荐两个优秀的项目和框架当然节假日除外），公众号推文中有项目和框架的介绍、功能特点、使用方式以及部分功能截图等（打不开或者打开GitHub很慢的同学可以优先查看公众号推文，文末一定会附带项目和框架源码地址）。注意：排名不分先后，都是十分优秀的开源项目和框架，每周定期更新分享（欢迎关注公众号：追逐时光者，第一时间获取每周精选分享资讯🔔）。
追逐时光者
44 1
穆雄雄.
|
1月前
|
SQL 数据库连接 数据库
你不知道ADo.Net中操作数据库的步骤【超详细整理】
你不知道ADo.Net中操作数据库的步骤【超详细整理】
穆雄雄.
16 0
GoodTime
|
1月前
|
SQL 数据库 C#
C# .NET面试系列十一：数据库SQL查询（附建表语句）
#### 第1题 用一条 SQL 语句 查询出每门课都大于80 分的学生姓名 建表语句： ```sql create table tableA ( name varchar(10), kecheng varchar(10), fenshu int(11) ) DEFAULT CHARSET = 'utf8'; ``` 插入数据 ```sql insert into tableA values ('张三', '语文', 81); insert into tableA values ('张三', '数学', 75); insert into tableA values ('李四',
GoodTime
65 2
C# .NET面试系列十一：数据库SQL查询（附建表语句）
众所周知
|
1月前
|
SQL 开发框架 JavaScript
在 Vue 中进行数据持久化时，有哪些常用的数据库框架？
在 Vue 中进行数据持久化时，有哪些常用的数据库框架？
众所周知
49 3
追逐时光者
|
2月前
|
开发框架 JavaScript 前端开发
5个.NET开源且强大的快速开发框架（帮助你提高生产效率）
5个.NET开源且强大的快速开发框架（帮助你提高生产效率）
追逐时光者
91 4
源码星辰
|
2月前
|
开发框架 Oracle 关系型数据库
ASP.NET实验室LIS系统源码 Oracle数据库
LIS是HIS的一个组成部分，通过与HIS的无缝连接可以共享HIS中的信息资源，使检验科能与门诊部、住院部、财务科和临床科室等全院各部门之间协同工作。　
源码星辰
37 4
Zh.晨光
|
3月前
|
存储 Java 数据库
JAVAEE框架数据库技术之13_oracle 之PLSQL技术及存储过程和函数（二）
JAVAEE框架数据库技术之13_oracle 之PLSQL技术及存储过程和函数
Zh.晨光
38 0
Zh.晨光
|
3月前
|
SQL Oracle 关系型数据库
JAVAEE框架数据库技术之12_oracle常用函数和高级查询子查询
JAVAEE框架数据库技术之12_oracle常用函数和高级查询子查询
Zh.晨光
66 0
JAVAEE框架数据库技术之12_oracle常用函数和高级查询子查询
穆雄雄.
|
1月前
|
开发框架 网络协议 .NET
深入.net框架
深入.net框架
穆雄雄.
11 0
GoodTime
|
1月前
|
SQL 存储 关系型数据库
C# .NET面试系列十：数据库概念知识
#### 1. 为什么要一定要设置主键? 设置主键是数据库设计中的一个重要概念，有几个主要原因： 1、唯一性 ```c# 主键必须保证表中的每一行都有唯一的标识。这样可以避免数据冗余和不一致性。如果没有主键或者主键不唯一，就可能出现数据混乱或错误。 ``` 2、查询性能 ```c# 数据库系统通常会使用主键来加速数据检索。主键通常会被索引，这样可以更快速地找到特定行的数据，提高查询效率。 ``` 3、关联性 ```c# 主键常常用于建立表与表之间的关系。在关系数据库中，一个表的主键通常与其他表中的外键建立关联，这种关系对于数据的一致性和完整性非常重要。 ``` 4、数据完
GoodTime
131 1
C# .NET面试系列十：数据库概念知识

热门文章

最新文章

  • 1
    成都晨云信息技术完成阿里云PolarDB数据库产品生态集成认证
  • 2
    一文搞懂数据库中的“锁”（图文详解）
  • 3
    【C/C++ 数据库 sqlite3】SQLite C语言API返回值深入解析
  • 4
    Perl 教程 之 Perl 数据库连接 1
  • 5
    阿里云数据库服务器价格表，数据库创建、连接和使用教程
  • 6
    在业务处理分析一体化的背景下，开发者如何平衡OLTP和OLAP数据库的技术需求与选型？
  • 7
    在Python Web开发过程中：数据库与缓存，MySQL和NoSQL数据库的主要差异是什么？
  • 8
    轻松入门MySQL：深入探究MySQL的ER模型，数据库设计的利器与挑战（22）
  • 9
    【MySQL技术专题】「问题实战系列」深入探索和分析MySQL数据库的数据备份和恢复实战开发指南（8.0版本升级篇）
  • 10
    MySQL数据库，可以使用二进制日志（binary log）进行时间点恢复
  • 1
    r语言中对LASSO回归，Ridge岭回归和弹性网络Elastic Net模型实现-4
    32
  • 2
    r语言中对LASSO回归，Ridge岭回归和弹性网络Elastic Net模型实现-3
    10
  • 3
    r语言中对LASSO回归，Ridge岭回归和弹性网络Elastic Net模型实现-1
    17
  • 4
    对象存储oss使用问题之OSS SDK .net 使用下载例程报错如何解决
    23
  • 5
    r语言中对LASSO回归，Ridge岭回归和Elastic Net模型实现
    15
  • 6
    r语言中对LASSO，Ridge岭回归和Elastic Net模型实现
    12
  • 7
    采用C#.Net +JavaScript 开发的云LIS系统源码 二级医院应用案例有演示
    13
  • 8
    中科院二区7.4分｜NET基因肿瘤分型+生存预后模型+分子对接
    17
  • 9
    .NET开源快速、强大、免费的电子表格组件
    20
  • 10
    .NET开源免费的Windows快速文件搜索和应用程序启动器
    23

    • 相关课程

    更多
  • 数据库的前世今生
  • 数据库核心概念
  • 从传统数据库到云数据库演进
  • 数据库常见问题排查
  • 数据库及SQL/MySQL基础
  • 高校精品课-西安交通大学 -数据库理论与技术

    • 相关电子书

    更多
  • 2022 DTCC-阿里云一站式数据库上云最佳实践
  • 云时代的数据库技术趋势
  • 超大型金融机构国产数据库全面迁移成功实践

    • 相关实验场景

    更多
  • PolarDB for AI：在数据库中通过SQL实现AI能力
  • 云原生HTAP数据库，让你的交易和分析一库搞定
  • Excel文件转存到RDS数据库
  • 快速体验PolarDB开源数据库
  • 手把手教你把IoT传感器数据存储到数据库
  • WorkBench操作云上数据库
    • 下一篇
    部署LAMP环境（Alibaba Cloud Linux 3）