C#如何链接本地Oracle数据库 ConnectionString & BadImageError报错

如果你已经创建好了用户名密码、并且已经有了一个可以调用的table，直接跳到第3部分

1. 创建数据库用户名密码

Create the user

create user TENANT01
identified by “”
default tablespace USERS
temporary tablespace TEMP
profile DEFAULT
password expire;

Grant/Revoke role privileges

grant aq_administrator_role to TENANT01 with admin option;
grant dba to TENANT01 with admin option;
grant mgmt_user to TENANT01;

Grant/Revoke system privileges

grant unlimited tablespace to TENANT01 with admin option;

2. 创建一个table

create table userinfo(
userid varchar(48),
userpassword varchar(48),
crdt date,
cruser varchar(48));

录入信息

insert into userinfo(
userid, userpassword, crdt, cruser)
values(,,sys.date(),created_user);

3. VS里修改App.config

<configuration>
	
    <startup> 
        <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.7.2" />
    </startup>
	<connectionStrings>