.netcore+ef+oracle+内置ioc容器搭建简单小项目

首先添加引用

在程序包管理器控制台输入：Scaffold-DbContext "Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=IP地址)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=服务名称)));User Id=用户名;Password=密码;" Oracle.EntityFrameworkCore -O Models -F

回车后便可，生成modelcontext文件和数据库映射模型

3.配置appsettings.json

"ConnectionStrings": {
"OraCon": "Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=IP地址)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=服务名称)));User Id=用户名;Passwordf=;"
}

配置startup

public Startup(IConfiguration configuration)

{

Configuration = configuration;

var path = Directory.GetCurrentDirectory();

new ConfigurationBuilder().SetBasePath(path).AddJsonFile("appsettings.json", optional: true, reloadOnChange: true).AddEnvironmentVariables().Build();

}

public void ConfigureServices(IServiceCollection services)

{

services.AddControllersWithViews();

services.AddSession();

services.AddDbContext<ModelContext>(opt => opt.UseOracle(Configuration.GetConnectionString("OraCon")));//加载数据库连接