Method-Based Query Syntax Examples: Element Operators (LINQ to Entities)
The examples in this topic demonstrate how to use the First method to query the AdventureWorks Sales Model using method-based query syntax. The AdventureWorks Sales Model used in these examples is built from the Contact, Address, Product, SalesOrderHeader, and SalesOrderDetail tables in the AdventureWorks sample database.
The example in this topic uses the following using/Imports statements:
Option Explicit On
Option Strict On
Imports L2EExamplesVB.AdventureWorksModel
Imports System.Data.Objects
Imports System.Globalization
using System;
using System.Data;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.Objects;
using AdventureWorksModel;
using System.Globalization;
For more information, see How to: Create a LINQ to Entities Project in Visual Studio.
First
Example
The following example uses the First method to find the first e-mail address that starts with 'caroline'.
Using AWEntities As New AdventureWorksEntities
Dim contacts As ObjectQuery(Of Contact) = AWEntities.Contact
Dim query = contacts.First(Function(cont) _
cont.EmailAddress.StartsWith("caroline"))
Console.WriteLine("An email address starting with 'caroline': {0}", _
query.EmailAddress)
End Using
using (AdventureWorksEntities AWEntities = new AdventureWorksEntities())
{
ObjectQuery<Contact> contacts = AWEntities.Contact;
Contact query = contacts.First(contact =>
contact.EmailAddress.StartsWith("caroline"));
Console.WriteLine("An email address starting with 'caroline': {0}",
query.EmailAddress);
}