gistfile1.txt

var qf = new QueryFactory();
var q = qf.Actor
            .From(QueryTarget.InnerJoin(qf.FilmActor)
                            .On(ActorFields.ActorId.Equal(FilmActorFields.ActorId)))
            .Where(ActorFields.FirstName.StartsWith("A"));
            .Select(()=>new { FirstName = ActorFields.FirstName.ToValue<string>(),
                              LastName=ActorFields.LastName.ToValue<string>() });
var results = new DataAccessAdapter.FetchQuery(q);

gistfile2.txt

var metaData = new LinqMetaData(new DataAccessAdapter());
var q = from a in metaData.Actor
		join fa in metaData.FilmActor on a.ActorId equals fa.ActorId
		where a.FirstName.StartsWith("A")
		select new {FirstName = a.FirstName, LastName=a.LastName};
var results = q.ToList();