Exemple #1
0
        /// <summary>
        /// Exécute une requête de select et retour la première valeur
        /// de la première ligne.
        /// </summary>
        /// <param name="minRowsAffected">Nombre minimum de lignes affectées.</param>
        /// <param name="maxRowsAffected">Nombre maximum de lignes affectées.</param>
        /// <returns>Retourne la valeur ou null.</returns>
        public object ExecuteScalar(int minRowsAffected, int maxRowsAffected)
        {
            using (SqlServerDataReader reader = this.ExecuteReader()) {
                if (reader.Read())
                {
                    int rowsAffected = reader.RecordsAffected;
                    if (rowsAffected > maxRowsAffected)
                    {
                        throw new SqlServerException(string.Format(
                                                         CultureInfo.CurrentCulture,
                                                         SR.ExceptionTooManyRowsAffected,
                                                         rowsAffected));
                    }

                    if (rowsAffected < minRowsAffected)
                    {
                        throw new SqlServerException(string.Format(
                                                         CultureInfo.CurrentCulture,
                                                         SR.ExceptionTooFewRowsAffected,
                                                         rowsAffected));
                    }

                    return(reader.GetValue(0));
                }

                throw new SqlServerException(SR.ExceptionZeroRowAffected);
            }
        }
Exemple #2
0
        /// <summary>
        /// Execute l'insertion en base de la collection.
        /// </summary>
        /// <param name="commandName">Nom de la commande.</param>
        /// <param name="dataSourceName">Nom de la dataSource.</param>
        /// <returns>Liste d'objet insérés.</returns>
        public ICollection <T> ExecuteInsert(string commandName, string dataSourceName)
        {
            SqlServerCommand command = new SqlServerCommand(dataSourceName, commandName, _sbInsert.ToString());

            CreateParameter(command);
            command.CommandTimeout = 0;
            BeanPropertyDescriptor primaryKey = _beanDefinition.PrimaryKey;

            using (SqlServerDataReader reader = command.ExecuteReader()) {
                while (reader.Read())
                {
                    T source = _index[reader.GetInt32(1).Value];
                    primaryKey.SetValue(source, reader.GetInt32(0).Value);
                }
            }

            return(_collection);
        }