Exemple #1
0
        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));
        }
Exemple #2
0
        /// <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);
        }