Converting System.Linq.IQueryable interface to System.Data.DataSet

Just a quick tip, in case you need to convert a System.Linq.IQueryable interface to System.Data.DataSet then check at the codes below

private DataSet LINQToDataSet({Your LINQ Data Context} myDB, IQueryable item)
{
    SqlCommand cmd = myDB.GetCommand(item) as SqlCommand;

    DataTable oDataTable = new DataTable();
    SqlDataAdapter oDataAdapter = new SqlDataAdapter(cmd);
    oDataAdapter.Fill(oDataTable);

    DataSet oDataSet = new DataSet();
    oDataSet.Tables.Add(oDataTable);
    return oDataSet;
}

Usage:

var oTableResult = (from p in myDB.SampleTable
                where p.SampleColumn == "Test Value"
                select p);

LINQToDataSet(myDB, oTableResult);