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
Here is the generated code.:
DECLARE IDENTITY Number;
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) );
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?