ObjectQuery<T>.Execute(MergeOption) Method

Definition

Executes the object query with the specified merge option.

public:
 System::Data::Objects::ObjectResult<T> ^ Execute(System::Data::Objects::MergeOption mergeOption);
public System.Data.Objects.ObjectResult<T> Execute (System.Data.Objects.MergeOption mergeOption);
override this.Execute : System.Data.Objects.MergeOption -> System.Data.Objects.ObjectResult<'T>
Public Function Execute (mergeOption As MergeOption) As ObjectResult(Of T)

Parameters

mergeOption
MergeOption

The MergeOption to use when executing the query. The default is AppendOnly.

Returns

An ObjectResult<T> that contains a collection of entity objects returned by the query.

Examples

This example returns an ObjectResult<T> from Execute method. Then it gets an enumerator and iterates through the query results. At the end it releases the enumerator and the ObjectResult<T> object.

using (AdventureWorksEntities context =
    new AdventureWorksEntities())
{
    ObjectSet<Product> query = context.Products;
    ObjectResult<Product> queryResults = null;

    System.Collections.IEnumerator enumerator = null;
    try
    {
        queryResults = query.Execute(MergeOption.AppendOnly);

        // Get the enumerator.
        enumerator = ((System.Collections.IEnumerable)queryResults).GetEnumerator();

        // Iterate through the query results.
        while (enumerator.MoveNext())
        {
            Product product = (Product)enumerator.Current;
            Console.WriteLine("{0}", product.Name);
        }
        // Dispose the enumerator
        ((IDisposable)enumerator).Dispose();
    }
    finally
    {
        // Dispose the query results and the enumerator.
        if (queryResults != null)
        {
            queryResults.Dispose();
        }
        if (enumerator != null)
        {
            ((IDisposable)enumerator).Dispose();
        }
    }
}

Remarks

The default merge option for object queries is AppendOnly. For more information, see Identity Resolution, State Management, and Change Tracking.

Applies to

See also