Techie Solutions.

Method 'System.String Format(System.String, System.Object, System.Object, System.Object)' has no supported translation to SQL. Once I was working on the Linq query and found the above error message .  Actually i was inserting some data into the database by Linq query and  this was the code  foreach (var rep in (from rep in db.DO_TR                                                  join ab in db.DO_TA on rep.TeacherAbsenceID equals ab.Id                                                  join tt in db.Archive_TT on string.Format("{0}{1} ({2})", rep.RollClassCode,                                             ...