Query for Information

Home Download Purchase Support FAQ Document Contact Us

ALinq Document > Programming Guide > Querying the Database

Query for Information

ALinq translates the queries you write into equivalent SQL queries and sends them to the server for processing.

Example

The following query asks for a list of customers from London. In this example, Customers is a table in the Northwind sample database.

var db = new AccessNorthwind(@"c:\northwind.mdb");

// Query for customers in London.
IQueryable<Customer> custQuery =
    from cust in db.Customers
    where cust.City == "London"
    select cust;

Dim db = New AccessNorthwind("c:\northwind.mdb")

' Query for customers in London.
Dim custQuery As IQueryable(Of Customer) = _
        From cust In db.Customers() _
        Where (cust.City = "London") _
        Select cust