Console Appl- Data file and Database update

[TopNotchBuddy]

Console application to read .dat file
data in .dat file pipe limited.

Input file layout is delimited by '|':
fileA
fileB
fileC
fileD
fileE
fileF
fileG
fileH
fileI
fileJ
fileK

Output Table Layout is:
• TYPE_1 (VARCHAR2(20))
• ENTITY_2 (VARCHAR2(100))
• ENTITY_3 (VARCHAR2(100))
• ENTITY_4 (VARCHAR2(4000))
• ACTIVE_5 (VARCHAR2(2))
• DISPLAY_ORDER_6 (NUMBER(4,0))
• LST_UPD_DT (DATE)
• LST_UPD_USERID (VARCHAR2(35))
TYPE_1 - TEST always
ENTITY_2 and ENTITY_3 is fileA
ENTITY_4 is
{"fileA":"XY,"fileB"":"XY COMPANY"}

ACTIVE_5 - Y
DISPLAY_ORDER_6 is 0
LST_UPD_DT is sysdate
LST_UPD_USERID is TEST


C# console application has to read .dat file in above laayout and update a table in oracle as table layout.
first row in .dat file is
XY| XY COMPANY | Y| N| | | | | | | N

Can you please code for it ...thanks ..