Oracle Data Access Component (ODAC) Full name: Oracle Access Components
Advantages: Because Microsoft will System.Data.OracleClient.dll deprecated in. NET Framework4, and in terms of access efficiency and speed, System.Data.OracleClient.dll Oracle.DataAccess.dll, Microsoft does not have the advantage of Oracle's class library, so I gave up the use of System.Data.OracleClient.dll for many years and replaced it with Odp.net.
1. Installation of ODAC
Serv
Tags: out soft Microsoft File connection IMA package Control PACThe first step: Step Two: Step Three: Fourth step: Enter commands in the console (1)install-package microsoft.entityframeworkcore (2)install-package Microsoft.EntityFrameworkCore.SqlServer (3)install-package Microsoft.EntityFrameworkCore.Tools (4)install-package Microsoft.EntityFrameworkCore.SqlServer.Design Fifth Step: Create a models folder in your project project also use the command to generate the EF context from the d
Connect to the aboveAfter the database is installed, you can also test the statement.Below we write a console program in C #, connect to the database, and read the data.Download the drive NET version of the next Cubrid ADO Provider 9.3.0.0001.zip This can be. After the decompression there is a CUBRID.Data.dllTwo create the console, add a reference to the CUBRID.D
One, configure the Oracle port on the serverEnter the NETCA command on the command line to open the related configuration default port number is 1521Second, after configuring the port, use the Telnet tool to debug the port.Enter the Telnet server IP port number at the command lineThird, find the net Manager self-bringing toolCustomizing a service NameConfigure the IP and port number you need to connect to t
connection string.2. Inserting data contains garbled characters in Chinese.This question on the Internet, change this configuration to change that configuration. Then the egg will be found after the change. I inserted the Chinese after the use of the MySQL console to view the data garbled, using navicat viewing is normal. So this question is still in the observation, if you have any good solution can leave a message:)3. A few days ago, a friend asked a question, he used Miniprofiler monitor EF
. Onmodelcreating (ModelBuilder); - varEtperson = Modelbuilder.entity"t_persons"); -Etperson.property (e = e.age). IsRequired ();//do not write isrequired, default is nullable -Etperson.property (E =e.gender). IsRequired (); +Etperson.property (e = e.name). Hasmaxlength ( -). IsRequired (); - } + A } at}Where the configuration for database columns is similar to the. NET Framework's EFThen add the following code to the program:
There are two ways to connect to SQL Server via ODBC:One, by loading the SQL Server drive mode;Second, by configuring the DSN name; stringConstr ="driver={sql Server};d atabase="+ databasename+"; server="+ Server address +";the//sql Server driver Constr+="Uid=invuser; pwd=1;"OdbcCommand cmd_s=NewOdbcCommand (sSQL, CONN_ODBC); OdbcDataReader reader_s= Cmd_s.executereader ();//Execute Query intICZ =0; while(Reader_s.read ()) {jlb
1.64-bit Oracle client on 64-bit machine.Then install the PL/SQL Developer, but connect the Oracle old newspaper with this error:Workaround: Install the 32-bit Oracle client on a 64-bit machine. This will make the connection successful.Basis:From the installation point of view, the 32bit platform (operating system and hardware system) only support 32bitORACLE installation;64bit platform supports installation of both 32bitORACLE and 64-bit Oracle2. Rei
The. NET remote connection Oracle database looks pretty simple, but there are still a lot of problems. Let me share the experience of tossing this thing today.
There are many ways to access Oracle database, I use OleDbConnection, this is nothing to say, the code is as follows:
1. Connection Code
_OleDbConnection = new OleDbConnection(connectionString); _OleDbConnection.Open();
2. Connection string
The connection string for a remote connection can
Tags: path install bracket can identify share Ann SQL ONSThe following prompts appear when Plsql is installed:According to the error message prompt, initially thought oarcle because the installation path problem causes the recognition not to be able to identify, later discovered. is the Plsql installation path with parentheses to make such an errorSuch as:Modify the installation path for the Plsql, and select the installation path without parentheses. This error can be resolved.The installation
=192.168.121.130) (port=1521)) (CONNECT_DATA= (SERVICE_NAME=ORCL))); Persist Security info=true; User Id=scott; Password=tiger; ";where Oracle database server ip:192.168.121.130Servicename:orclUser name: ScottPassword: Tiger4. View the instance name of Oracle, log in with SYS as DBA, execute the statement select name from V$database;5,c# CodeUsing system;using system.collections.generic;using system.configuration;using Oracle.ManagedDataAccess.Client; Using system.linq;using System.text;n
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.