Hi,In normal way of write the code as follows in DAL.DataSet ds=db.executedataset();IEnumerable<datarow>= ds.tables[0].asEnumerable();For better performance can use datareader in Linq instead of DataSet ...