This is my code,
public void AddNDADetails(string id)
{
try
{
con = db.CreateConnection();
con.Open();
string query = string.Format("INSERT INTO NDAInformation (NDAID,RegNumber,DateCreate,RefName,ReqServ,ServDetails) VALUES (:ndaID,:regnumber,TO_DATE(:date,'DDMMYYYY'),:refname,:regserv,:servdetails)");
cmd = db.GetSqlStringCommand(query);
cmd = con.CreateCommand();
cmd.CommandText = query;
db.AddInParameter(cmd, "ndaID", DbType.String, id);
db.AddInParameter(cmd, "regnumber", DbType.String, om.RegNumber);
db.AddInParameter(cmd, "date", DbType.Date, om.Date);
db.AddInParameter(cmd, "refname", DbType.String, om.ComRef);
db.AddInParameter(cmd, "regserv", DbType.String, om.ComService);
db.AddInParameter(cmd, "servdetails", DbType.String, string.Join(",", om.ReqServiceDetails));
db.ExecuteNonQuery(cmd);
}
catch (Exception ex)
{
throw ex;
}
}