Update Database from RIA Services / Entity Framework without User interface objects.

Create an instance in code for whichever DataContext your ria object usually uses, once you have that instance you can use it to load the data in memory without any grid, once you have manipulated the data you can call DataContext.SubmitChanges() and should persist them in the database.  

I probably would not be able to write a good sample in C# as I usually code in VB, but hopefully it is simple enough.  If you are using a DomainDataSource control in xaml, check the DataContext property to see what type of object it is creating for it.  That is the one you will want to create and load queries with in code.  

I was able to discover the rest using intellisense alone.  Just call YourDataContextObject.Load(YourDataContext.QueryMethod), get the data in the LoadedData event, then manipulate it however you need to and call YourDataContext.SubmitChanges() (there is an event for that when it completes as well, you will need to check the response for errors, and use the e.MarkErrorAsHandled() method if there was an error in either operation).

Best of luck.

Yeah - I've been playing around with intellisense and can't find anything that exposes the fields in the entities.  If I bind them to a UI elements, no problem.  Change the value and SubmitChanges(), and I'm done.  I'm just not finding a way to walk through the collection and change the flags.    For instance, I created and loaded a DataContext:

---------------------------------------------------------------------------------------------------
productDomainContext _productDomainContext = new productDomainContext();
_productDomainContext.Load(_productDomainContext.GetNewProductsQuery());
---------------------------------------------------------------------------------------------------

Works great.  If I bind this to a datagrid, I see the expected records.   Now, what I want to do is take a batch number, combine that with a colorcode from the products table and a sequence number to create a serial number for the product.  No user interface is required for the process.  That's where I get stuck.  The code should be something like this:

--------------------------------------------------------------------------------------------------
string batchID = "ABC123";
int batchSeq = 1;
foreach (product in _productDomainContext)
{
    product.serialNumber = String.Concat( batchID,"-", product.colorCode, "-", batchSeq);
    batchSeq++;
}
---------------------------------------------------------------------------------------------------

Of course, if this worked, I wouldn't be asking this question.
When I attempt to compile, I get the error:

--------------------------------------------------------------------------------------------------
" foreach statement cannot operate on variables of type 'namespace.productDomainContext' because namespace.productDomainContext' does not contain a public definition for 'GetEnumerator' "   
--------------------------------------------------------------------------------------------------

I think I can make this work if I can get past this point, but I'm not finding a solution.

I've requested that this question be deleted for the following reason:

                           
No comment has been added to this question in more than 21 days, so it is now classified as abandoned and is now flagged for deletion.


If there is a valid solution, please OBJECT and indicate the comments that are, or would otherwise lead to, a solution.


Use the specific format https:#axxxxxxxx for comment ID(s).


Also, please don't object simply because the author did not respond to your comment. While we understand this is frustrating, unfortunately we cannot force the author to return to the question. Unless you feel you have presented a valid, verifiable solution we'll simply delete the question.


Experts-Exchange Auto Deleter

I believe this has been answered with a solution that can be implemented and tested.

https://www.experts-exchange.com/questions/27145171/Update-Database-from-RIA-Services-Entity-Framework-without-User-interface-objects.html?anchorAnswerId=36095168#a36095168