How Do I return a DataTable from a SubSonic Query?

Question

I'm trying to return a datatable from a query I have written in Subsonic (I'm just starting to learn it) - But can only return a DataSet?

public DataTable GetAllCarTypes()
{
    return new Query("tblCarType").ExecuteDataSet();
}

I was hoping for .ExecuteDataTable()??

Answer 1

Ahhaaa.. should have thought about it before O posted, think I have it now

public DataTable GetAllCarTypes()
{
    return new Query("tblCarType").ExecuteDataSet().Tables[0];
}

If not please can you post up the correct syntax

Answer 2

If you're only returning 1 table from the query, you can do:

public DataTable GetAllCarTypes()
{
    return new Query("tblCarType").ExecuteDataSet().Tables[0];
}