This project is read-only.

INSERT new record

Jan 30, 2009 at 9:12 AM
Hi,

first of all, I have to say "you have done great job with this project". Everithing is working fine, but I get little stuck with inserting new record.
I didnt use mapping generator at all, because I'd like to understant how does it work, so the following problem is : When I'm trying insert new record
I get error ORA-00904 which is "invalid identifier" during checking  SQL query which was generated by LINQ statement, I've find out bug inside of
converting method.

Here is the generated code.:
DECLARE IDENTITY Number;
BEGIN
INSERT INTO my_tb ( Last_Name, First_Name ) VALUES ( :p0, :p1 );
SELECT EMP_SQ.CURRVAL INTO IDENTITY FROM DUAL;
OPEN :p2 FOR SELECT t0.Employee_Id FROM my_tb t0 WHERE t0.Employee_Id = ( CONVERT ( Int32, IDENTITY) );
END;

As you see the problem is inside of WHERE clause, where is bad data type Int32.
The property Employee_Id is data type int and has this attribute [Column(Storage = "employee_id", DBType="NUMBER NOT NULL ENP_SQ" Id=true, AutoGen=true)].

Could anyone give me some advice with that?
Regards n00by