net core3.0 EF连接数据库

基本信息

源码名称：net core3.0 EF连接数据库

源码大小：8.78M

文件格式：.rar

开发语言：C#

更新时间：2021-03-20

友情提示：（无需注册或充值，赞助后即可获取资源下载链接）

嘿，亲！知识可是无价之宝呢，但咱这精心整理的资料也耗费了不少心血呀。小小地破费一下，绝对物超所值哦！如有下载和支付问题，请联系我们QQ(微信同号)：78630559

本次赞助数额为： 2 元　

源码介绍

本压缩包含有，数据库，表信息，链接数据库方式、实体类、api调用说明，以及startup详细配置，可以参考学习！

sqlserver 连接
1.创建数据库管理类
1.注意引用：using Microsoft.EntityFrameworkCore;
using Microsoft.EntityFrameworkCore.SqlServer;
2.管理实体类和数据库连接管理
2.创建实体
1.自定义实体类名称，实体中的类型和名称必须与数据库一致
3.编写api控制器
1.demo中编写了一个查询和删除，里面有详细说明
4.startup.cs
public void ConfigureServices(IServiceCollection services)
{
//这里一定要注册控制器，不然不运行控制器
services.AddControllers();
}

1.数据库表名称：myDatabase，自定义，注意修改数据库连接字符串
2.送上创建数据库库表
CREATE TABLE [dbo].[Student](
[ID] [int] IDENTITY(1,1) NOT NULL,
[LastName] [nvarchar](50) NULL,
[FirstMidName] [nvarchar](50) NULL,
[EnrollmentDate] [datetime] NULL,
CONSTRAINT [PK_Student] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

net core3.0 EF连接数据库

├── Datas
│ └── StudentContext.cs
├── Models
│ └── Students.cs
├── Program.cs
├── Properties
│ └── launchSettings.json
├── Startup.cs
├── appsettings.Development.json
├── appsettings.json
├── bin
│ └── Debug
│ └── netcoreapp3.1
│ ├── Microsoft.AspNetCore.Razor.Language.dll
│ ├── Microsoft.Bcl.AsyncInterfaces.dll
│ ├── Microsoft.Bcl.HashCode.dll
│ ├── Microsoft.CodeAnalysis.CSharp.Workspaces.dll
│ ├── Microsoft.CodeAnalysis.CSharp.dll
│ ├── Microsoft.CodeAnalysis.Razor.dll
│ ├── Microsoft.CodeAnalysis.Workspaces.dll
│ ├── Microsoft.CodeAnalysis.dll
│ ├── Microsoft.Data.SqlClient.dll
│ ├── Microsoft.EntityFrameworkCore.Abstractions.dll
│ ├── Microsoft.EntityFrameworkCore.Relational.dll
│ ├── Microsoft.EntityFrameworkCore.SqlServer.dll
│ ├── Microsoft.EntityFrameworkCore.dll
│ ├── Microsoft.Extensions.Caching.Abstractions.dll
│ ├── Microsoft.Extensions.Caching.Memory.dll
│ ├── Microsoft.Extensions.Configuration.Abstractions.dll
│ ├── Microsoft.Extensions.Configuration.Binder.dll
│ ├── Microsoft.Extensions.Configuration.dll
│ ├── Microsoft.Extensions.DependencyInjection.Abstractions.dll
│ ├── Microsoft.Extensions.DependencyInjection.dll
│ ├── Microsoft.Extensions.Logging.Abstractions.dll
│ ├── Microsoft.Extensions.Logging.dll
│ ├── Microsoft.Extensions.Options.dll
│ ├── Microsoft.Extensions.Primitives.dll
│ ├── Microsoft.Identity.Client.dll
│ ├── Microsoft.VisualStudio.Web.CodeGeneration.Contracts.dll
│ ├── Microsoft.VisualStudio.Web.CodeGeneration.Core.dll
│ ├── Microsoft.VisualStudio.Web.CodeGeneration.EntityFrameworkCore.dll
│ ├── Microsoft.VisualStudio.Web.CodeGeneration.Templating.dll
│ ├── Microsoft.VisualStudio.Web.CodeGeneration.Utils.dll
│ ├── Microsoft.VisualStudio.Web.CodeGeneration.dll
│ ├── Microsoft.VisualStudio.Web.CodeGenerators.Mvc.dll
│ ├── Newtonsoft.Json.dll
│ ├── NuGet.Frameworks.dll
│ ├── Properties
│ │ └── launchSettings.json
│ ├── System.Composition.AttributedModel.dll
│ ├── System.Composition.Convention.dll
│ ├── System.Composition.Hosting.dll
│ ├── System.Composition.Runtime.dll
│ ├── System.Composition.TypedParts.dll
│ ├── System.Configuration.ConfigurationManager.dll
│ ├── System.Runtime.Caching.dll
│ ├── System.Security.Cryptography.ProtectedData.dll
│ ├── appsettings.Development.json
│ ├── appsettings.json
│ ├── cs
│ │ ├── Microsoft.CodeAnalysis.CSharp.Workspaces.resources.dll
│ │ ├── Microsoft.CodeAnalysis.CSharp.resources.dll
│ │ ├── Microsoft.CodeAnalysis.Workspaces.resources.dll
│ │ └── Microsoft.CodeAnalysis.resources.dll
│ ├── de
│ │ ├── Microsoft.CodeAnalysis.CSharp.Workspaces.resources.dll
│ │ ├── Microsoft.CodeAnalysis.CSharp.resources.dll
│ │ ├── Microsoft.CodeAnalysis.Workspaces.resources.dll
│ │ └── Microsoft.CodeAnalysis.resources.dll
│ ├── demo1-api.deps.json
│ ├── demo1-api.dll
│ ├── demo1-api.exe
│ ├── demo1-api.pdb
│ ├── demo1-api.runtimeconfig.dev.json
│ ├── demo1-api.runtimeconfig.json
│ ├── dotnet-aspnet-codegenerator-design.dll
│ ├── es
│ │ ├── Microsoft.CodeAnalysis.CSharp.Workspaces.resources.dll
│ │ ├── Microsoft.CodeAnalysis.CSharp.resources.dll
│ │ ├── Microsoft.CodeAnalysis.Workspaces.resources.dll
│ │ └── Microsoft.CodeAnalysis.resources.dll
│ ├── fr
│ │ ├── Microsoft.CodeAnalysis.CSharp.Workspaces.resources.dll
│ │ ├── Microsoft.CodeAnalysis.CSharp.resources.dll
│ │ ├── Microsoft.CodeAnalysis.Workspaces.resources.dll
│ │ └── Microsoft.CodeAnalysis.resources.dll
│ ├── it
│ │ ├── Microsoft.CodeAnalysis.CSharp.Workspaces.resources.dll
│ │ ├── Microsoft.CodeAnalysis.CSharp.resources.dll
│ │ ├── Microsoft.CodeAnalysis.Workspaces.resources.dll
│ │ └── Microsoft.CodeAnalysis.resources.dll
│ ├── ja
│ │ ├── Microsoft.CodeAnalysis.CSharp.Workspaces.resources.dll
│ │ ├── Microsoft.CodeAnalysis.CSharp.resources.dll
│ │ ├── Microsoft.CodeAnalysis.Workspaces.resources.dll
│ │ └── Microsoft.CodeAnalysis.resources.dll
│ ├── ko
│ │ ├── Microsoft.CodeAnalysis.CSharp.Workspaces.resources.dll
│ │ ├── Microsoft.CodeAnalysis.CSharp.resources.dll
│ │ ├── Microsoft.CodeAnalysis.Workspaces.resources.dll
│ │ └── Microsoft.CodeAnalysis.resources.dll
│ ├── pl
│ │ ├── Microsoft.CodeAnalysis.CSharp.Workspaces.resources.dll
│ │ ├── Microsoft.CodeAnalysis.CSharp.resources.dll
│ │ ├── Microsoft.CodeAnalysis.Workspaces.resources.dll
│ │ └── Microsoft.CodeAnalysis.resources.dll
│ ├── pt-BR
│ │ ├── Microsoft.CodeAnalysis.CSharp.Workspaces.resources.dll
│ │ ├── Microsoft.CodeAnalysis.CSharp.resources.dll
│ │ ├── Microsoft.CodeAnalysis.Workspaces.resources.dll
│ │ └── Microsoft.CodeAnalysis.resources.dll
│ ├── ru
│ │ ├── Microsoft.CodeAnalysis.CSharp.Workspaces.resources.dll
│ │ ├── Microsoft.CodeAnalysis.CSharp.resources.dll
│ │ ├── Microsoft.CodeAnalysis.Workspaces.resources.dll
│ │ └── Microsoft.CodeAnalysis.resources.dll
│ ├── runtimes
│ │ ├── unix
│ │ │ └── lib
│ │ │ ├── netcoreapp2.0
│ │ │ │ └── System.Runtime.Caching.dll
│ │ │ └── netcoreapp2.1
│ │ │ └── Microsoft.Data.SqlClient.dll
│ │ ├── win
│ │ │ └── lib
│ │ │ ├── netcoreapp2.0
│ │ │ │ └── System.Runtime.Caching.dll
│ │ │ ├── netcoreapp2.1
│ │ │ │ └── Microsoft.Data.SqlClient.dll
│ │ │ └── netstandard2.0
│ │ │ └── System.Security.Cryptography.ProtectedData.dll
│ │ ├── win-arm64
│ │ │ └── native
│ │ │ └── sni.dll
│ │ ├── win-x64
│ │ │ └── native
│ │ │ └── sni.dll
│ │ └── win-x86
│ │ └── native
│ │ └── sni.dll
│ ├── tr
│ │ ├── Microsoft.CodeAnalysis.CSharp.Workspaces.resources.dll
│ │ ├── Microsoft.CodeAnalysis.CSharp.resources.dll
│ │ ├── Microsoft.CodeAnalysis.Workspaces.resources.dll
│ │ └── Microsoft.CodeAnalysis.resources.dll
│ ├── web.config
│ ├── zh-Hans
│ │ ├── Microsoft.CodeAnalysis.CSharp.Workspaces.resources.dll
│ │ ├── Microsoft.CodeAnalysis.CSharp.resources.dll
│ │ ├── Microsoft.CodeAnalysis.Workspaces.resources.dll
│ │ └── Microsoft.CodeAnalysis.resources.dll
│ └── zh-Hant
│ ├── Microsoft.CodeAnalysis.CSharp.Workspaces.resources.dll
│ ├── Microsoft.CodeAnalysis.CSharp.resources.dll
│ ├── Microsoft.CodeAnalysis.Workspaces.resources.dll
│ └── Microsoft.CodeAnalysis.resources.dll
├── controllers
│ └── DefaultController.cs
├── demo1-api.csproj
├── demo1-api.csproj.user
├── demo1-api.sln
├── obj
│ ├── Debug
│ │ └── netcoreapp3.1
│ │ ├── demo1-api.AssemblyInfo.cs
│ │ ├── demo1-api.AssemblyInfoInputs.cache
│ │ ├── demo1-api.MvcApplicationPartsAssemblyInfo.cache
│ │ ├── demo1-api.RazorTargetAssemblyInfo.cache
│ │ ├── demo1-api.assets.cache
│ │ ├── demo1-api.csproj.CopyComplete
│ │ ├── demo1-api.csproj.CoreCompileInputs.cache
│ │ ├── demo1-api.csproj.FileListAbsolute.txt
│ │ ├── demo1-api.dll
│ │ ├── demo1-api.exe
│ │ ├── demo1-api.genruntimeconfig.cache
│ │ ├── demo1-api.pdb
│ │ └── staticwebassets
│ │ ├── demo1-api.StaticWebAssets.Manifest.cache
│ │ └── demo1-api.StaticWebAssets.xml
│ ├── demo1-api.csproj.nuget.dgspec.json
│ ├── demo1-api.csproj.nuget.g.props
│ ├── demo1-api.csproj.nuget.g.targets
│ ├── project.assets.json
│ └── project.nuget.cache
├── web.config
└── 说明文件.txt

41 directories, 145 files