public int Attach(T1 firstTableVO, T2 secondTableVO) { string statement = SqlStatememtGenerator.Insert(tableName, ConvertToArray(firstTableIdColumnName, secondTableIdColumnName)); SqlParameter[] parameters = new SqlParameter[2]; parameters[0] = MakeSqlParameter(firstTableIdColumnName, firstTableVO.Id); parameters[1] = MakeSqlParameter(secondTableIdColumnName, secondTableVO.Id); return(executer.ExecuteInsertStatement(statement, parameters)); }
/// <summary> /// Inserts the object in databse and sets its Id property to the inserted record id. /// </summary> /// <param name="vo">The VO object to be inserted.</param> /// <returns>The inserted record id. -1 if the insertion was not successful.</returns> public virtual int Insert(T vo) { string[] columnsNames = ConvertColumnNamesToArray(); string statement = SqlStatememtGenerator.Insert(tableName, columnsNames); SqlParameter[] parameters = MakeSqlParameters(vo); int id = executer.ExecuteInsertStatement(statement, parameters); vo.Id = id; return(id); }