How to: Return a Specific Object Using its Key

This topic shows how to retrieve a data type by its key values instead of explicitly creating and executing a query. This example uses the TryGetObject<T> method on OpenAccessContext to return an object with the specified key into the object context.

To run the code in this example, you need to create a new Telerik Data Access Domain Model based on the Northwind database.

The following code is the LINQ example.

C#


    using (EntitiesModel dbContext = new EntitiesModel())
    {
       Telerik.OpenAccess.ObjectKey objectKey = new Telerik.OpenAccess.ObjectKey("Customer", new[] { new Telerik.OpenAccess.ObjectKeyMember("CustomerID", "ALFKI") });
       Customer customer = null;
       if (dbContext.TryGetObjectByKey<Customer>(objectKey, out customer))
       {
           Console.WriteLine(customer.CompanyName);
       }
    }

VB.NET


    Using dbContext As New EntitiesModel()
     Dim objectKey As New Telerik.OpenAccess.ObjectKey("Customer", { New Telerik.OpenAccess.ObjectKeyMember("CustomerID", "ALFKI") })
     Dim customer_Renamed As Customer = Nothing
     If dbContext.TryGetObjectByKey(Of Customer)(objectKey, customer_Renamed) Then
      Console.WriteLine(customer_Renamed.CompanyName)
     End If
    End Using

For more information about the ObjectKey API, please refer to the following topics:

See Also