Use a DataAdapter fill a DataTable from a basic SQL statement ... row[ x ] = typeof( T ).GetProperty( propertyList[ x ] ).GetValue( rec ); } dt.Rows.Add( row ); } To truly achieve a flexible design, ...