public object SPToScalar(string sp, params object[] parameters)
{
using (DbConnection conexion = factory.CreateConnection ()) {
conexion.ConnectionString = ConnectionString;
conexion.Open ();
using (DbCommand comando = factory.CreateCommand ()) {
comando.Connection = conexion;
comando.CommandType = CommandType.StoredProcedure;
comando.CommandText = sp;
comando.CommandTimeout = CommandTimeOut;
cargarParametros (comando, parameters);
return comando.ExecuteScalar ();
}
}
}