DataSet ds = GetDataSetFromStoredProc("stored_proc_name", new SqlParameter("@parameter_name", value_id));
var retItems = from dstable in ds.Tables[0].AsEnumerable()
select new ClassThing()
{
PrimaryKeyId = dstable.Field<int>("some_column_name")
};