Ado. NET and Oracle operations database how to assign Parameters

In use. NET when using OracleParameter for Oracle database operations, because Oracle and SQL Server have different syntax for query parameterization,

When you operate SQL Server, you are using @ParameterName.

And Oracle is using :P arametername .

and the SQL pseudo-statement also has a corresponding change, compare the difference between SQL Server and Oracle:

String sql = "Delete from PostInfo where [email protected]";

SqlParameter p1 = new SqlParameter("@id", id);

String sql = "Delete from PostInfo where id=:id";

OracleParameter P1 = new OracleParameter("id", id);

It is also necessary to check that the data types are consistent, with the data type comparison table for Oracle and SQL Server in C #.

Oracle data type comparison in C #

SQL Server data type comparison in C #