【免费】.NetCorE+EFCore+Oracle项目代码_webapi+oracle资源-CSDN文库

共700个文件

dll：448个

cs：71个

json：65个

oracle

.NetCore

EFCore

需积分: 0 75 浏览量 2023-03-27 16:01:58 上传评论 1 收藏 51.35MB RAR 举报

标题中的".Net Core + EFCore + Oracle项目代码"揭示了一个基于.NET Core框架的Web API项目，其中使用了Entity Framework Core（EF Core）作为ORM（对象关系映射）工具，并且数据库后端是Oracle。这个项目从零开始构建，涵盖了整个项目的生命周期，包括设计、开发、测试到运行。 .NET Core是Microsoft开发的一个开源、跨平台的框架，用于构建各种类型的应用，如Web应用、APIs以及桌面应用等。它的主要优势包括高性能、模块化、可移植性和跨平台支持，使得开发者可以在Windows、Linux和macOS等操作系统上进行开发。 EF Core是EF（Entity Framework）的轻量级、高性能版本，是.NET Core生态中的主流ORM工具。它允许开发者使用面向对象的编程方式来操作数据库，避免了直接编写SQL语句的繁琐工作。EF Core提供了数据模型映射、数据库迁移、查询优化等功能，简化了数据库操作，提高了开发效率。 Oracle数据库是全球知名的商业数据库管理系统，以其稳定性、安全性及高性能著称。在.NET Core项目中使用Oracle，意味着该项目可能涉及大型企业级应用，需要处理大量数据和复杂的事务处理。描述中提到的"从0到整个项目运行"暗示了这个项目代码包含了一系列步骤，从初始化项目、配置环境、安装必要的依赖库，到创建数据库模型、实现业务逻辑、设置路由和控制器，再到连接Oracle数据库、执行数据库迁移、测试API以及部署运行等。在这个项目中，开发者可能经历了以下步骤： 1. **项目初始化**：使用Visual Studio或命令行工具创建.NET Core Web API项目。 2. **添加依赖**：安装Oracle的.NET Core驱动程序，如Oracle.ManagedDataAccess.Core，以及EF Core的相关包，如Microsoft.EntityFrameworkCore、Microsoft.EntityFrameworkCore.SqlServer和Microsoft.EntityFrameworkCore.Tools。 3. **数据库配置**：在项目中配置Oracle数据库连接字符串，设置DbContext类以定义数据模型和数据库上下文。 4. **实体模型设计**：创建POCO（Plain Old C# Object）类，代表数据库表的实体。 5. **数据库迁移**：使用EF Core的迁移功能创建初始迁移，将模型变化同步到数据库结构。 6. **业务逻辑实现**：在控制器中编写API方法，处理HTTP请求，通过EF Core操作数据库。 7. **测试与调试**：使用Postman或其他工具测试API，确保数据的正确读写和业务逻辑的正常执行。 8. **部署**：将项目发布到IIS服务器或云平台，完成部署。标签中的"软件/插件"可能表示项目中可能使用了一些辅助工具或插件，如日志记录、性能监控、身份验证和授权等。这个项目提供了从零开始构建.NET Core + EF Core + Oracle应用程序的实践示例，对于学习和理解这些技术的集成应用具有很高的参考价值。开发者可以通过研究这个项目，学习如何在.NET Core环境中有效地管理Oracle数据库，以及如何构建高性能、可扩展的Web API服务。

资源推荐

资源详情

资源评论

收起资源包目录

.Net CorE+EFCore+Oracle项目代码（700个子文件）

WMSAPI.csproj.AssemblyReference.cache 189KB

WMSAPI.assets.cache 62KB

WMSAPI.assets.cache 55KB

Models.assets.cache 49KB

project.nuget.cache 22KB

project.nuget.cache 18KB

project.nuget.cache 16KB

WMSAPI.RazorTargetAssemblyInfo.cache 42B

WMSAPI.AssemblyInfoInputs.cache 42B

WMSAPI.genruntimeconfig.cache 42B

WMSAPI.csproj.CoreCompileInputs.cache 42B

WMSAPI.AssemblyInfoInputs.cache 42B

WMSAPI.RazorTargetAssemblyInfo.cache 42B

WMSAPI.genruntimeconfig.cache 42B

WMSAPI.AssemblyInfoInputs.cache 42B

WMSAPI.RazorTargetAssemblyInfo.cache 42B

WMSAPI.csproj.CoreCompileInputs.cache 42B

WMSAPI.genruntimeconfig.cache 42B

Models.genruntimeconfig.cache 42B

Models.csproj.CoreCompileInputs.cache 42B

Models.AssemblyInfoInputs.cache 42B

Models.csproj.CoreCompileInputs.cache 42B

Models.genruntimeconfig.cache 42B

Models.AssemblyInfoInputs.cache 42B

WMSAPI.csproj.AssemblyReference.cache 11B

Models.csproj.AssemblyReference.cache 11B

WMSAPI.MvcApplicationPartsAssemblyInfo.cache 0B

WMSAPI.StaticWebAssets.Manifest.cache 0B

WMSAPI.MvcApplicationPartsAssemblyInfo.cache 0B

WMSAPI.StaticWebAssets.Manifest.cache 0B

applicationhost.config 78KB

web.config 550B

web.config 531B

WMSAPI.csproj.CopyComplete 0B

SRMService.cs 42KB

WMSDBContext.cs 39KB

OracleHelper.cs 29KB

TblDocBill.cs 10KB

ASNParams.cs 7KB

TblItemNatur.cs 7KB

Startup.cs 6KB

WebActionAttribute.cs 6KB

UserController.cs 5KB

SRMController.cs 5KB

TblDocBill.cs 4KB

CTHParams.cs 4KB

TblSysTransOuter.cs 4KB

LoginService.cs 3KB

TblDocBillDtl.cs 3KB

HttpUtil.cs 3KB

TblPOLine.cs 3KB

Logger.cs 3KB

TblPO.cs 3KB

TblLotInfo.cs 2KB

ResultModel.cs 2KB

TblRecLabel.cs 2KB

TimeConvertUtil.cs 2KB

PLMController.cs 1KB

TblTransSysDtlOuter.cs 1KB

JsonToolUtil.cs 1KB

BaseModel.cs 1KB

ListConvertTable.cs 1KB

TableUtil.cs 1KB

LoginController.cs 1KB

PLMService.cs 1KB

DataTableUtil.cs 1KB

WMSAPI.AssemblyInfo.cs 1003B

Models.AssemblyInfo.cs 1003B

WMSAPI.AssemblyInfo.cs 1001B

Models.AssemblyInfo.cs 1001B

ISRMService.cs 901B

UserService.cs 888B

TableUtil.cs 882B

IModel.cs 835B

IModel.cs 828B

WMSAPI.MvcApplicationPartsAssemblyInfo.cs 752B

Program.cs 714B

JsonToolUtil.cs 667B

SRMResult.cs 563B

TBLLOCKINVDTL_PLM.cs 557B

TblWebApiRequestDtl.cs 555B

共 700 条

E:\.netcode学习20230109\JPT.WMS.WebApi\WMSAPI\bin\Release\netcoreapp3.1\appsettings.Development.json E:\.netcode学习20230109\JPT.WMS.WebApi\WMSAPI\bin\Release\netcoreapp3.1\appsettings.json E:\.netcode学习20230109\JPT.WMS.WebApi\WMSAPI\bin\Release\netcoreapp3.1\WMSAPI.exe E:\.netcode学习20230109\JPT.WMS.WebApi\WMSAPI\bin\Release\netcoreapp3.1\WMSAPI.deps.json E:\.netcode学习20230109\JPT.WMS.WebApi\WMSAPI\bin\Release\netcoreapp3.1\WMSAPI.runtimeconfig.json E:\.netcode学习20230109\JPT.WMS.WebApi\WMSAPI\bin\Release\netcoreapp3.1\WMSAPI.runtimeconfig.dev.json E:\.netcode学习20230109\JPT.WMS.WebApi\WMSAPI\bin\Release\netcoreapp3.1\WMSAPI.dll E:\.netcode学习20230109\JPT.WMS.WebApi\WMSAPI\bin\Release\netcoreapp3.1\WMSAPI.pdb E:\.netcode学习20230109\JPT.WMS.WebApi\WMSAPI\bin\Release\netcoreapp3.1\Autofac.dll E:\.netcode学习20230109\JPT.WMS.WebApi\WMSAPI\bin\Release\netcoreapp3.1\Autofac.Extensions.DependencyInjection.dll E:\.netcode学习20230109\JPT.WMS.WebApi\WMSAPI\bin\Release\netcoreapp3.1\Humanizer.dll E:\.netcode学习20230109\JPT.WMS.WebApi\WMSAPI\bin\Release\netcoreapp3.1\Microsoft.EntityFrameworkCore.dll E:\.netcode学习20230109\JPT.WMS.WebApi\WMSAPI\bin\Release\netcoreapp3.1\Microsoft.EntityFrameworkCore.Abstractions.dll E:\.netcode学习20230109\JPT.WMS.WebApi\WMSAPI\bin\Release\netcoreapp3.1\Microsoft.EntityFrameworkCore.Design.dll E:\.netcode学习20230109\JPT.WMS.WebApi\WMSAPI\bin\Release\netcoreapp3.1\Microsoft.EntityFrameworkCore.Relational.dll E:\.netcode学习20230109\JPT.WMS.WebApi\WMSAPI\bin\Release\netcoreapp3.1\Microsoft.Extensions.Caching.Abstractions.dll E:\.netcode学习20230109\JPT.WMS.WebApi\WMSAPI\bin\Release\netcoreapp3.1\Microsoft.Extensions.Caching.Memory.dll E:\.netcode学习20230109\JPT.WMS.WebApi\WMSAPI\bin\Release\netcoreapp3.1\Microsoft.Extensions.Configuration.Abstractions.dll E:\.netcode学习20230109\JPT.WMS.WebApi\WMSAPI\bin\Release\netcoreapp3.1\Microsoft.Extensions.DependencyInjection.dll E:\.netcode学习20230109\JPT.WMS.WebApi\WMSAPI\bin\Release\netcoreapp3.1\Microsoft.Extensions.DependencyInjection.Abstractions.dll E:\.netcode学习20230109\JPT.WMS.WebApi\WMSAPI\bin\Release\netcoreapp3.1\Microsoft.Extensions.Logging.dll E:\.netcode学习20230109\JPT.WMS.WebApi\WMSAPI\bin\Release\netcoreapp3.1\Microsoft.Extensions.Logging.Abstractions.dll E:\.netcode学习20230109\JPT.WMS.WebApi\WMSAPI\bin\Release\netcoreapp3.1\Microsoft.Extensions.Options.dll E:\.netcode学习20230109\JPT.WMS.WebApi\WMSAPI\bin\Release\netcoreapp3.1\Microsoft.Extensions.PlatformAbstractions.dll E:\.netcode学习20230109\JPT.WMS.WebApi\WMSAPI\bin\Release\netcoreapp3.1\Microsoft.Extensions.Primitives.dll E:\.netcode学习20230109\JPT.WMS.WebApi\WMSAPI\bin\Release\netcoreapp3.1\Microsoft.OpenApi.dll E:\.netcode学习20230109\JPT.WMS.WebApi\WMSAPI\bin\Release\netcoreapp3.1\Newtonsoft.Json.dll E:\.netcode学习20230109\JPT.WMS.WebApi\WMSAPI\bin\Release\netcoreapp3.1\Oracle.EntityFrameworkCore.dll E:\.netcode学习20230109\JPT.WMS.WebApi\WMSAPI\bin\Release\netcoreapp3.1\Oracle.ManagedDataAccess.dll E:\.netcode学习20230109\JPT.WMS.WebApi\WMSAPI\bin\Release\netcoreapp3.1\Swashbuckle.AspNetCore.Swagger.dll E:\.netcode学习20230109\JPT.WMS.WebApi\WMSAPI\bin\Release\netcoreapp3.1\Swashbuckle.AspNetCore.SwaggerGen.dll E:\.netcode学习20230109\JPT.WMS.WebApi\WMSAPI\bin\Release\netcoreapp3.1\Swashbuckle.AspNetCore.SwaggerUI.dll E:\.netcode学习20230109\JPT.WMS.WebApi\WMSAPI\bin\Release\netcoreapp3.1\System.Collections.Immutable.dll E:\.netcode学习20230109\JPT.WMS.WebApi\WMSAPI\bin\Release\netcoreapp3.1\System.ComponentModel.Annotations.dll E:\.netcode学习20230109\JPT.WMS.WebApi\WMSAPI\bin\Release\netcoreapp3.1\System.Configuration.ConfigurationManager.dll E:\.netcode学习20230109\JPT.WMS.WebApi\WMSAPI\bin\Release\netcoreapp3.1\System.Diagnostics.DiagnosticSource.dll E:\.netcode学习20230109\JPT.WMS.WebApi\WMSAPI\bin\Release\netcoreapp3.1\System.Diagnostics.PerformanceCounter.dll E:\.netcode学习20230109\JPT.WMS.WebApi\WMSAPI\bin\Release\netcoreapp3.1\System.DirectoryServices.dll E:\.netcode学习20230109\JPT.WMS.WebApi\WMSAPI\bin\Release\netcoreapp3.1\System.DirectoryServices.Protocols.dll E:\.netcode学习20230109\JPT.WMS.WebApi\WMSAPI\bin\Release\netcoreapp3.1\System.Security.Cryptography.ProtectedData.dll E:\.netcode学习20230109\JPT.WMS.WebApi\WMSAPI\bin\Release\netcoreapp3.1\System.Text.Json.dll E:\.netcode学习20230109\JPT.WMS.WebApi\WMSAPI\bin\Release\netcoreapp3.1\runtimes\win\lib\netcoreapp2.0\System.Diagnostics.PerformanceCounter.dll E:\.netcode学习20230109\JPT.WMS.WebApi\WMSAPI\bin\Release\netcoreapp3.1\runtimes\win\lib\netcoreapp2.0\System.DirectoryServices.dll E:\.netcode学习20230109\JPT.WMS.WebApi\WMSAPI\bin\Release\netcoreapp3.1\runtimes\win\lib\netcoreapp2.0\System.DirectoryServices.Protocols.dll E:\.netcode学习20230109\JPT.WMS.WebApi\WMSAPI\bin\Release\netcoreapp3.1\runtimes\win\lib\netstandard2.0\System.Security.Cryptography.ProtectedData.dll E:\.netcode学习20230109\JPT.WMS.WebApi\WMSAPI\bin\Release\netcoreapp3.1\Models.dll E:\.netcode学习20230109\JPT.WMS.WebApi\WMSAPI\bin\Release\netcoreapp3.1\Models.pdb E:\.netcode学习20230109\JPT.WMS.WebApi\WMSAPI\bin\Release\netcoreapp3.1\Microsoft.AspNetCore.Authentication.JwtBearer.dll E:\.netcode学习20230109\JPT.WMS.WebApi\WMSAPI\bin\Release\netcoreapp3.1\Microsoft.IdentityModel.JsonWebTokens.dll E:\.netcode学习20230109\JPT.WMS.WebApi\WMSAPI\bin\Release\netcoreapp3.1\Microsoft.IdentityModel.Logging.dll E:\.netcode学习20230109\JPT.WMS.WebApi\WMSAPI\bin\Release\netcoreapp3.1\Microsoft.IdentityModel.Protocols.dll E:\.netcode学习20230109\JPT.WMS.WebApi\WMSAPI\bin\Release\netcoreapp3.1\Microsoft.IdentityModel.Protocols.OpenIdConnect.dll E:\.netcode学习20230109\JPT.WMS.WebApi\WMSAPI\bin\Release\netcoreapp3.1\Microsoft.IdentityModel.Tokens.dll E:\.netcode学习20230109\JPT.WMS.WebApi\WMSAPI\bin\Release\netcoreapp3.1\System.IdentityModel.Tokens.Jwt.dll E:\.netcode学习20230109\JPT.WMS.WebApi\WMSAPI\bin\netcoreapp3.1\appsettings.Development.json E:\.netcode学习20230109\JPT.WMS.WebApi\WMSAPI\bin\netcoreapp3.1\appsettings.json E:\.netcode学习20230109\JPT.WMS.WebApi\WMSAPI\bin\netcoreapp3.1\WMSAPI.exe E:\.netcode学习20230109\JPT.WMS.WebApi\WMSAPI\bin\netcoreapp3.1\WMSAPI.deps.json E:\.netcode学习20230109\JPT.WMS.WebApi\WMSAPI\bin\netcoreapp3.1\WMSAPI.runtimeconfig.json E:\.netcode学习20230109\JPT.WMS.WebApi\WMSAPI\bin\netcoreapp3.1\WMSAPI.runtimeconfig.dev.json E:\.netcode学习20230109\JPT.WMS.WebApi\WMSAPI\bin\netcoreapp3.1\WMSAPI.dll E:\.netcode学习20230109\JPT.WMS.WebApi\WMSAPI\bin\netcoreapp3.1\WMSAPI.pdb E:\.netcode学习20230109\JPT.WMS.WebApi\WMSAPI\bin\netcoreapp3.1\WMSAPI.xml E:\.netcode学习20230109\JPT.WMS.WebApi\WMSAPI\bin\netcoreapp3.1\Autofac.dll E:\.netcode学习20230109\JPT.WMS.WebApi\WMSAPI\bin\netcoreapp3.1\Autofac.Extensions.DependencyInjection.dll E:\.netcode学习20230109\JPT.WMS.WebApi\WMSAPI\bin\netcoreapp3.1\Humanizer.dll E:\.netcode学习20230109\JPT.WMS.WebApi\WMSAPI\bin\netcoreapp3.1\Microsoft.AspNetCore.Authentication.JwtBearer.dll E:\.netcode学习20230109\JPT.WMS.WebApi\WMSAPI\bin\netcoreapp3.1\Microsoft.EntityFrameworkCore.dll E:\.netcode学习20230109\JPT.WMS.WebApi\WMSAPI\bin\netcoreapp3.1\Microsoft.EntityFrameworkCore.Abstractions.dll E:\.netcode学习20230109\JPT.WMS.WebApi\WMSAPI\bin\netcoreapp3.1\Microsoft.EntityFrameworkCore.Design.dll E:\.netcode学习20230109\JPT.WMS.WebApi\WMSAPI\bin\netcoreapp3.1\Microsoft.EntityFrameworkCore.Relational.dll E:\.netcode学习20230109\JPT.WMS.WebApi\WMSAPI\bin\netcoreapp3.1\Microsoft.Extensions.Caching.Abstractions.dll E:\.netcode学习20230109\JPT.WMS.WebApi\WMSAPI\bin\netcoreapp3.1\Microsoft.Extensions.Caching.Memory.dll E:\.netcode学习20230109\JPT.WMS.WebApi\WMSAPI\bin\netcoreapp3.1\Microsoft.Extensions.Configuration.Abstractions.dll E:\.netcode学习20230109\JPT.WMS.WebApi\WMSAPI\bin\netcoreap

评论收藏

内容反馈