1.**entityframework Add Oracle EF-related NuGet package Oracle.ManagedDataAccess.EntityFramework (Auto add oracle.manageddataaccess)
2.**web Add Oracle.ManagedDataAccess.EntityFramework (Auto add oracle.manageddataaccess)
Overriding onmodelcreating methods under 3.**entityframework
protected Override void onmodelcreating (Dbmodelbuilder modelBuilder) { Modelbuilder.hasdefaultschema ("ORCL"); // be sure to capitalize Base . Onmodelcreating (ModelBuilder); }
4. Modify the Web. config under **web
<oracle.manageddataaccess.client> <version Number="*"> <datasources> <DataSourcealias= "ORCL"Descriptor= "(Description= (address= (protocol=tcp) (Host=localhost) (port=1521)) (Connect_data= (SERVICE_NAME=ORCL)))" /> </datasources> </version> </oracle.manageddataaccess.client>
< connectionStrings > < name= "Default" providerName= "Oracle.ManagedDataAccess.Client" connectionString= "User id=orcl; Password=orcl;data SOURCE=ORCL; Persist Security info=true "/> </connectionStrings>
5. Package Management Console
5.1 Default Project Options Select **entityframework
5.2 Execute add-migration command
5.3 Execute update-database command
Note: encountered a pit, did not do the above steps, executed the NuGet command, resulting in the generation of Sqlerver resource files, so has been reported no dbo user error
ABP Connects to Oracle database