Hi,

I write Linq query for keep on fetching data from database. First loop table don't have record , so throwing exception. After first loop i have record in the database, my
query is working properly. Below i specified my query give some suggestion first loop(no records in table) i have to modify query or query have to change.

Ex:

 forloop(History history in historyList)
 {
 History history1 = (from p in context.History
                                    where p.TransferCode == history.TransferCode
                                    select p).First<History>()
                                    as History;    
 if(history1 == null)
 {
   SaveToDataBase(history);
 }
 else
 {
   UpdateToDataBase(history1);
 }
 }

Thinks