LINQ to SQL submitchanges not doing anything?

Your not calling ts. Complete in function saveEditedFmas Also I would recommend calling db.SubmitChanges() outside of the for loop. And why do you have a transaction in function fetchAllActiveAssetsInFMA?

It's only fetching data right? And I'm not quite sure whats happening inside the for loop in save function, looks strange I think you should map the properties from fmaItemToSave to fmaItemToUpdate foreach (var fmaItemToSave in fmaToSaveList) { var fmaItemToUpdate = clsCompiledQuery. GetFmaById(db, fmaItemToSave.ID).First(); fmaItemToUpdate.

Name = fmaItemToSave. Name; fmaItemToUpdate. AssetID = fmaItemToSave.

AssetID; //And the rest of the properties } db.SubmitChanges().

Your not calling ts. Complete in function saveEditedFmas. Also I would recommend calling db.SubmitChanges(); outside of the for loop.

And why do you have a transaction in function fetchAllActiveAssetsInFMA? It's only fetching data right? And I'm not quite sure whats happening inside the for loop in save function, looks strange.

I think you should map the properties from fmaItemToSave to fmaItemToUpdate foreach (var fmaItemToSave in fmaToSaveList) { var fmaItemToUpdate = clsCompiledQuery. GetFmaById(db, fmaItemToSave. ID).First(); fmaItemToUpdate.Name = fmaItemToSave.

Name; fmaItemToUpdate. AssetID = fmaItemToSave. AssetID; //And the rest of the properties } db.SubmitChanges().

Tried both of those suggestions, nothing. Thanks for the help – hansel fernandez Jun 22 at 20:03 The inside of the for loop in the save function looks strange, your not changing any values of the objects. – Magnus Jun 22 at 20:09 AFF_CMS_FMA fmaItemToUpdate = clsCompiledQuery.

GetFmaById(db, fmaItemToSave. ID).ToList()0; fmaItemToUpdate = fmaItemToSave; these two lines are setting the object passed in to the equivalent of it on the db . I removed the transaction from fetch you were right about that one .

Still same result though – hansel fernandez Jun 22 at 20:13 I think you should map the properties from fmaItemToSave to fmaItemToUpdate – Magnus Jun 22 at 20:15 Also don't do .ToList()0 use .First() instead, looks better – Magnus Jun 22 at 20:17.

Your not calling ts. Complete in function saveEditedFmas .

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.