Method 'System.String Format(System.String, System.Object, System.Object, System.Object)' has no supported translation to SQL


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,                                                        rep.Block, rep.Row) equals tt.GroupRowID
                                                 join clss in db.Archive_Classes on tt.ClassID equals clss.ID
                                                 join rc in db.Archive_RollClasses on tt.RollClassID equals rc.ID
                                                 where (clss.Code == item.ClassCode) && (rc.Code == item.RollClassCode) && (ab.CalendarID == item.CalendarID)
                                                 select new { rep, ab }))
                            {
                                
                            }

We can fix this issue just removing the string.Format , and just adding the value like

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 rep.RollClassCode + " " + rep.Block + "(" +                                                                rep.Row + ")" equals tt.GroupRowID
                                             join clss in db.Archive_Classes on tt.ClassID equals clss.ID
                                             join rc in db.Archive_RollClasses on tt.RollClassID equals rc.ID
                                             where (clss.Code == item.ClassCode) && (rc.Code == item.RollClassCode) && (                                               (ab.CalendarID == item.CalendarID)
                                             select new { rep, ab }))
                        {
                           
                        }

 Thanks . Let me know if you have any issue .

Comments

Post a Comment

Popular posts from this blog

The input is not a valid Base-64 string as it contains a non-base 64 character, more than two padding characters, or an illegal character among the padding characters.

I was trying to upload a file in client side and sending back the data from the client to Web API controller by angular service . Step 1 : I was doing it by. (It was bot the complete code )   function saveFile(file, cb) {     var readerObj = new FileReader();     readerObj .readAsDataURL(file);     readerObj .onload = function () {         savedFileDataAsBase64Format(readerObj .result, file.name,cb);     };     readerObj .onerror = function (error) {         alert("Error in uploading the file.");     }; Step 2 :     This is my Web api controller action method.        [HttpPost]         [Route("api/FileInput/SaveBase64FileData/{fileName}")]         public void SaveBase64FileData(string fileName, [FromBody]string fileData)         {     ...
Read more

The transaction is aborted or Failure while attempting to promote transaction.

This error is generally produced while you working on the  Linq query with Entity framework and there was some other system configurations like Visual studio 2015. Entity framework version 4. C# 4.5 But while I checked the Inner exception I got the following message  "There is already an open DataReader associated with this Command which must be closed first" So in my case there was some WCF services and from the WCF services I was extracting the data by Linq query . This was code  Code: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 using (TransactionScope scope = new TransactionScope()) { using (CentralisedData_DataDataContext db = new CentralisedData_DataDataContext()) { // Some code was there } db.SubmitChanges(); ...
Read more

Unable to load one or more breakpoints in Visual studio.

Image
Those who are working on Visual studio IDE they might have faced this type of error while opening any existing project . Sometimes by rebuild the solution or removing the break points the issue is get resolved .  So this problem/ issue is caused due to various reason but among those reason one of them is worked for me .  Here is my solutions. It worked for me . Please follow my steps. Step 1:    Please go to the physical folders/files of your solution . Just right click of the solution and from the options choose "Open Folder is File Explorer". Please check the attached Image. Please click on Image to view it properly Step 2:     Then you will see the files like this. Then please check the if the "Hide Items" checkbox is checked or not . If not checked please check that one. Then you will   see .vs folder .                               Please click on Im...
Read more