LinqToSql - Include linked object in selected result

Answer 1

Using the DataLoadOptions you can specify that L2S will load the FieldViews records together with the Fields.

Insert something like this before the query:

var dlo = new DataLoadOptions();
dlo.LoadWith<Fields>(f => f.FieldViews);
DataContext.LoadOptions = dlo;

The server will execute two queries, but within the same call to the server.