Under such scenario, you will be required to create a new class to hold the new object. In my sample, I create a BugCustom class that will allow me to hold the new property. Here is the snippet:

Class definition

public class BugCustom
{
    public int BugId { get; set; }
    public string Summary { get; set; }
    public string OwnerName { get; set; }
}

Select function (I do not have the Owners table, the select is simulated to return row with 3 column)

[WebMethod]
public object GetPagedBugsCustom(DataSourceSelectArguments selectArguments)
{
    BugTrackerModelDataContext context = new BugTrackerModelDataContext();
    context.DeferredLoadingEnabled = false;

    var datasource2 = 
        from b in context.Bugs
        select new BugCustom { BugId = b.BugId, Summary = b.Summary, OwnerName = "TestOwner" };


    WebGridDataProvider<BugCustom> provider = new WebGridDataProvider<BugCustom>(datasource2.AsQueryable());
    object data = provider.Select(selectArguments);

    if (data != null)
        return data;

    throw new InvalidOperationException("Unsupported operation type!");
}

The WebGrid client binding setting property

<ClientBindingSettings DataLoadMode="PagedData" DataSourceType="WebService" PreloadGroupTotals="true"
    ItemTypeName="BugCustom" ServiceUrl="WebService.asmx" EnableGroupRowPaging="true" GroupRowPageSize="20">
    <ServiceMethods SelectMethod="GetPagedBugsCustom" />
</ClientBindingSettings>

Hi Glenn,

That solved my issue with the join - thanks!  I now have a follow up issue.  I am using a left join, so some of the columns contain "Null" values.  I attempted to use a default values class to replace the Nulls.  Unfortunately, I am getting an error.

The attached sample shows the error.

Can you take a look?

Thanks,

Dave

The only way I could make it work is by using this query

var datasource = from b in context.Bugs
				 join o in context.Owners on b.BugId equals o.BugId into tl_j

				 from j in tl_j.DefaultIfEmpty()
				 select new BugWithOwner
				 {
					  BugId = b.BugId,
					  ChangeInLast = b.ChangeInLast,
					  Component = b.Component,
					  Dupe = b.Dupe,
					  OpSys = b.OpSys,
					  Severity = b.Severity,
					  Summary = b.Summary,
					  Target = b.Target,
					  OwnerId = j == null ? -1 : j.OwnerId,
					  OwnerName = j == null ? "--" : j.OwnerName
				  };