private MyTraining importMyTraining(Guid guid, Profile profie, SqlCeConnection oldConnection) { if (myTrainings.ContainsKey(guid)) { return(MyTraining.GetById(myTrainings[guid])); } Log.WriteInfo("Importing MyTraining id={0}", guid); SqlCeCommand cmd = new SqlCeCommand(); cmd.Connection = oldConnection; cmd.CommandText = string.Format("SELECT Id,StartDate,EndDate,GlobalId,EntryType,ProfileId,TrainingEnd,PercentageCompleted,Name FROM MyTraining WHERE GlobalId='{0}'", guid); var reader = cmd.ExecuteReader(); Log.WriteInfo("MyTraining reader executed"); if (reader.Read()) { MyTraining myTraining = new MyTraining(); myTraining.Name = getString(reader, "Name"); var endDate = getDateTime(reader, "EndDate"); var startDate = getDateTime(reader, "StartDate").Value; var trainingEnd = (TrainingEnd)getInt32(reader, "TrainingEnd").Value; myTraining.SetData(startDate, endDate, trainingEnd); myTraining.EntryType = getString(reader, "EntryType"); myTraining.ProfileId = profie.Id; myTraining.PercentageCompleted = getInt32(reader, "PercentageCompleted"); myTraining.CreateAndFlush(); myTrainings.Add(guid, myTraining.Id); return(myTraining); } return(null); }