Last post May 25, 2011 09:51 PM by Lannie
May 25, 2011 11:54 AM|clemilsoncorreia|LINK
I'm a .NET developer and I've always worked with SQL SERVER as my database. I've never worked with Oracle before and I have the following situation:
1) An E-Commerce portal completelly developed with .NET + SQL Server;
2) An Internal ERP completelly developed with DELPHY + Oracle;
We need to integrate the ERP and the WEBSITE (e-Commerce). All information about customers, orders, products must be integrated. So, please, help me answer the issues listed below:
I. Once the ERP uses Oracle, I almost decided to use the same ERP's Oracle database on my .NET Website. I know I will need to re-write everything, but a) the work will be lesser than changing the ERP database to SQL and b) in this way I will integrate the
ERP and Website easily. Am I right? Or there's another option like keeping booth database an Sync them periodically?
II. Are there problems using Oracle plus .NET?
III. To avoid "SQL Injection" I'm using Linq to SQL. Are there something like that with Oracle? Are there something like "Oracle Injection"????
IV. Are there any adidiontal point that I need to know before changing my Data Base to Oracle?
Thanks in advance
May 25, 2011 09:51 PM|Lannie|LINK
You can call both databases from ASP.NET.
use Oracle ODP.NET Oracle.DataAccess.dll.
Oracle does not support Linq, although I heard it may be in beta now or soon.
but to mitigate SQL injection in Oracle, use Oracle BIND VARIABLES.
Issues porting MSSQL to Oracle.
Oracle does not have a boolean datatype in oracle Tables and oracle SQL.
I have found doing this works best for compatibility with ASP.NET
Convert MSSQL Boolean to Oracle VARCHAR2(5) and store values 'True' and 'False' (case sensitive) then ASP.NET treats it as boolean in EVAL statements
Oracle only has one date data type, but all MSSQL datatypes can be converted.
Oracle users most often store integers as NUMBER(x) and decimals as NUMBER(x,y)
The MSSQL GUID is not the same as the Oracle GUID.
And of course, you will find the ORacle syntax for SQL may differ from MSSQL,
and at times has advanced features and capabilites you will learn to love!!