I installed the latest versions 6.50.250 and 6.50.244 because those fixed the previous ticket 'ORA-01400 for 6.5 on Oracle 10gEE 10.2.0.4.0 64bit'. However, I’m experiencing various mapping problems that were not present in the 6.50.228 version. These are independent from the Oracle DB version.
I have isolated a simple one here. The code makes an insert for a new CONFIG_PARM row (see the code below for the table definition). The insert is performed without errors, but the RECORD_STATUS_CD value is actually stored in the wrong column (LAST_MAINT_NM).
Code: Select all
using System;
using System.Collections.Generic;
using System.Linq;
using ONE2ONEXEContext;
/*
*
CREATE TABLE ONE2ONE.CONFIG_PARM
(
CONFIG_PARM NVARCHAR2(50),
CONFIG_PARM_DESCR NVARCHAR2(500),
ADD_DT DATE,
ADD_NM NVARCHAR2(50),
LAST_MAINT_DT DATE,
LAST_MAINT_NM NVARCHAR2(50),
RECORD_STATUS_CD NVARCHAR2(1) DEFAULT 'A'
);
ALTER TABLE ONE2ONE.CONFIG_PARM ADD (CONSTRAINT PK_CONFIG_PARM PRIMARY KEY (CONFIG_PARM));
*/
namespace O2OOracleTest
{
class Program
{
static void Main(string[] args)
{
ONE2ONEXEDataContext context = new ONE2ONEXEDataContext();
CONFIG_PARM dm = new CONFIG_PARM() { CONFIG_PARM1 = "TestConfig", CONFIG_PARM_DESCR = "This is a test", RECORD_STATUS_CD = "A" };
context.CONFIG_PARMs.InsertOnSubmit(dm);
context.SubmitChanges();
context.Dispose();
}
}
}
- uses Direct Mode
- no custom mapping is defined in the data context
- the SQL code generated is
Code: Select all
INSERT INTO ONE2ONE.CONFIG_PARM (CONFIG_PARM, CONFIG_PARM_DESCR, ADD_DT, ADD_NM, LAST_MAINT_DT, LAST_MAINT_NM, RECORD_STATUS_CD) VALUES (:p1, :p2, :p3, :p4, :p5, :p6, :p7)
-- p1: Input NVarChar (Size = 10; DbType = String) [TestConfig]
-- p2: Input NVarChar (Size = 14; DbType = String) [This is a test]
-- p3: Input Date (Size = 0; DbType = DateTime) []
-- p4: Input NVarChar (Size = 0; DbType = String) []
-- p5: Input Date (Size = 0; DbType = DateTime) []
-- p6: Input NVarChar (Size = 0; DbType = String) []
-- p7: Input NVarChar (Size = 1; DbType = String) [A]
-- Context: Devart.Data.Oracle.Linq.Provider.OracleDataProvider Model: an Build: 3.0.16.0
Many thanks