Saturday, October 20, 2012

C# LINQ Update using multiple where

We can use LINQ update using more than one where.

  // Upadate PR_RECIVEDINVOICEs status  
         var users = from u in dataContextObj.PR_RECIVEDINVOICEs  
               where u.RecivedInvoice_PublisherInvoice == receiveBook.InvoiceNo && u.Status=="Order"  
               select u;  
         users.ToList().ForEach(u => u.Status = "Book Receive");  
         dataContextObj.SubmitChanges();  

vfpoledeb.1 provider is not registered on the local machine

Have u Install VFP Ole DB Provider in your System ? If No then Please Install it from following link. http://www.microsoft.com/download...