linq example - use where for datacontext object

                LinqDataObjectsDataContext dc = new LinqDataObjectsDataContext();
                Invoice ret = dc.Invoices.Where(e => e.InvoiceID == id).SingleOrDefault();

more...

datacontext linq refresh example C# - linq example how to save object in linq to sql

        public string  SaveInvoiceXML(string sInvoice){
           try{
            Invoice inv = new Invoice();
            inv = CXMLConv.fromXML<Invoice>(sInvoice, inv);

            LinqDataObjectsDataContext dc = new LinqDataObjectsDataContext();

            dc.Invoices.Attach(inv);
            dc.Refresh(RefreshMode.KeepCurrentValues, inv);
            dc.SubmitChanges();

            return OK(CXMLConv.toXML(inv));
           }
           catch (Exception ex)
           {
               return RegisterError(ex, "SaveInvoiceXML", sInvoice);
           }
        }

more...