LinqClassesDataContext dataContext = new LinqClassesDataContext("Data Source=test;Initial Catalog=test; Integrated Security=SSPI;");

                    

                    IEnumerable<DataRow> query =
                    from a in dataContext.Dim_AllocationTypes.AsEnumerable()
                    select a;

                    // Create a table from the query.
                    DataTable boundTable = query.CopyToDataTable<DataRow>();