I'm wondering if there's a performance penalty when doing the following vs using plain old ado.net DataReader and DataTable:\[code\]using(DBEntities dbEntities = new dbEntities){ ObjectResult<tblCustomers> customers = dbEntities.ExecuteStoreQuery<tblCustomers>("SELECT name,id FROM tblCustomers");}\[/code\]I would also like to run sprocs using dbEntity.I mention this because i'm developing a highly performance sensitive application but would still like to use the entity framework.furthermore, can anyone point me to recent performance tests of linq to entities compiled queries on .net 4.0?EDIT
If i go with ado.net i plan on inserting the results i get from each row to a .net object manually. So it's entity framework storequery/sproc vs ado.net + manually creating and inserting data to a .net object.
If i go with ado.net i plan on inserting the results i get from each row to a .net object manually. So it's entity framework storequery/sproc vs ado.net + manually creating and inserting data to a .net object.