AI 助理
文档备案控制台
开发者社区 数据库 文章 正文

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

2016-11-28 2135
版权
版权声明：
本文内容由阿里云实名注册用户自发贡献，版权归原作者所有，阿里云开发者社区不拥有其著作权，亦不承担相应法律责任。具体规则请查看《 阿里云开发者社区用户服务协议》和 《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容，填写 侵权投诉表单进行举报，一经查实，本社区将立刻删除涉嫌侵权内容。
简介：

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数据库
长征6号
目录
相关文章
追逐时光者
|
C# Android开发 iOS开发
2025年全面的.NET跨平台应用框架推荐
2025年全面的.NET跨平台应用框架推荐
追逐时光者
701 23
Net分享
|
消息中间件 开发框架 监控
NET任务调度框架Hangfire使用指南
Hangfire 是一个用于 .NET 应用程序的开源任务调度框架，支持长时间运行任务、定时任务等。通过简单的安装配置，即可将任务从主线程分离，提升应用性能。支持多种数据库，提供丰富的任务类型如立即执行、延迟执行和周期性任务，并有可视化管理界面 Hangfire Dashboard。还支持安全性配置及扩展插件，如 Hangfire.HttpJob，适合各种复杂场景下的任务调度需求。
Net分享
1505 1
NET任务调度框架Hangfire使用指南
追逐时光者
|
监控 前端开发 API
一款基于 .NET MVC 框架开发、功能全面的MES系统
一款基于 .NET MVC 框架开发、功能全面的MES系统
追逐时光者
567 5
游客54bz4h3flp7ai
|
数据库 C# 开发者
ADO.NET连接到南大通用GBase 8s数据库
ADO.NET连接到南大通用GBase 8s数据库
游客54bz4h3flp7ai
301 6
土木林森
|
开发框架 安全 .NET
在数字化时代，.NET 技术凭借跨平台兼容性、丰富的开发工具和框架、高效的性能及强大的安全稳定性，成为软件开发的重要支柱
在数字化时代，.NET 技术凭借跨平台兼容性、丰富的开发工具和框架、高效的性能及强大的安全稳定性，成为软件开发的重要支柱。它不仅加速了应用开发进程，提升了开发质量和可靠性，还促进了创新和业务发展，培养了专业人才和技术社区，为软件开发和数字化转型做出了重要贡献。
土木林森
379 5
东方睿赢
|
传感器 人工智能 供应链
.NET开发技术在数字化时代的创新作用，从高效的开发环境、强大的性能表现、丰富的库和框架资源等方面揭示了其关键优势。
本文深入探讨了.NET开发技术在数字化时代的创新作用，从高效的开发环境、强大的性能表现、丰富的库和框架资源等方面揭示了其关键优势。通过企业级应用、Web应用及移动应用的创新案例，展示了.NET在各领域的广泛应用和巨大潜力。展望未来，.NET将与新兴技术深度融合，拓展跨平台开发，推动云原生应用发展，持续创新。
东方睿赢
201 4
土木林森
|
开发框架 .NET C#
.NET 技术凭借高效开发环境、强大框架支持及跨平台特性，在软件开发中占据重要地位
.NET 技术凭借高效开发环境、强大框架支持及跨平台特性，在软件开发中占据重要地位。从企业应用到电子商务，再到移动开发，.NET 均展现出卓越性能，助力开发者提升效率与项目质量，推动行业持续发展。
土木林森
410 4
游客54bz4h3flp7ai
|
数据库连接 数据库 C#
Windows下C# 通过ADO.NET方式连接南大通用GBase 8s数据库（上）
Windows下C# 通过ADO.NET方式连接南大通用GBase 8s数据库（上）
游客54bz4h3flp7ai
489 0
游客54bz4h3flp7ai
|
数据库连接 数据库 C#
Windows下C# 通过ADO.NET方式连接南大通用GBase 8s数据库（下）
本文接续前文，深入讲解了在Windows环境下使用C#和ADO.NET操作南大通用GBase 8s数据库的方法。通过Visual Studio 2022创建项目，添加GBase 8s的DLL引用，并提供了详细的C#代码示例，涵盖数据库连接、表的创建与修改、数据的增删查改等操作，旨在帮助开发者提高数据库管理效率。
游客54bz4h3flp7ai
317 0
二二*一一
|
开发框架 前端开发 JavaScript
ASP.NET MVC 教程
ASP.NET 是一个使用 HTML、CSS、JavaScript 和服务器脚本创建网页和网站的开发框架。
二二*一一
331 7

热门文章

最新文章

  • 1
    如何编写.NET Core Global Tools (附两个案例)
  • 2
    .NET Core多平台开发体验[4]: Docker
  • 3
    在C#中选择“.NET研究”正确的集合进行编码
  • 4
    ASP.NET随机码生成示例
  • 5
    一起谈.NET技术，asp.net控件开发基础(4)
  • 6
    Asp.Net MVC 3.0 使用Gzip压缩
  • 7
    ASP.NET开源MVC框架Vici MVC（二）Controllers和templates基础
  • 8
    asp.net mvc 实体类成员变量标识示例
  • 9
    微软称Google Android可以使用.NET,徐汇区网站设计
  • 10
    ASP.NET-FineUI开发实践-10
  • 1
    现代化实时数仓 SelectDB 再次登顶 ClickBench 全球数据库分析性能排行榜！
    872
  • 2
    Python 操作 MySQL 数据库
    359
  • 3
    为什么数据库字符编码不一致会导致索引失效
    587
  • 4
    关系型数据库考虑索引的选择性
    385
  • 5
    关系型数据库选择正确的索引类型
    488
  • 6
    关系型数据库识别常查询字段
    461
  • 7
    SQL DB - 关系型数据库是如何工作的
    207
  • 8
    认识常见的一些数据库分类
    1679
  • 9
    关系型数据库中对索引的数目
    377
  • 10
    关系型数据库针对常查询的字段建立索引
    265

    • 相关课程

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

    • 相关电子书

    更多
  • 开源数据库工作室推广计划
  • 国产数据库研制人才培养实践
  • 阿里云&信通院《Serverless数据库技术研究报告》
    • 下一篇
    狂揽7.5k星！这款开源API网关彻底解放开发者：一键聚合GPT-4、Suno、Midjourney，还能在线充值！