DevForce Community Forum : Saving just one object

Saving just one object : SaveEntity(oEmpl)orSaveEntity(Of...

Fri, 18 Apr 2008 06:26:19 -700

Author: f3rland
Subject: 772
Posted: 18-Apr-2008 at 6:26am

[VB]
SaveEntity(oEmpl)
or
SaveEntity(Of Model.Employee)(oEmpl)

[C#]
SaveEntity(oEmpl);
or
SaveEntity(oEmpl);

Saving just one object : Ok, I knew I was on the right...

Thu, 17 Apr 2008 15:44:54 -700

Author: DataMan
Subject: 772
Posted: 17-Apr-2008 at 3:44pm

Ok, I knew I was on the right track and after talking with Ideablade support we came up with the following code

EntityList<Entity> saveList = new EntityList<Entity>();

EntityList<Employee> mChangedEmployee = new EntityList<Employee>();

mChangedEmployee.ReplaceRange(mPersMgr.GetEntities<Employee>(DataRowState.Modified));

mChangedEmployee.AddRange(mPersMgr.GetEntities<Employee>(DataRowState.Added));

mChangedEmployee.AddRange(mPersMgr.GetEntities<Employee>(DataRowState.Deleted));

foreach (Entity mChanged in mChangedEmployee)

{

saveList.Add(mChanged);

}

mPersMgr.SaveChanges(saveList);

Now looking at f3rland's code above it shows passing the entire entity to the SaveEntity routine... Can you show me an example of calling the SaveEntity routine? Or is my above code the easiest way?

Thanks

Edited by DataMan - 17-Apr-2008 at 3:48pm

Saving just one object : It's weird that I was looking...

Thu, 17 Apr 2008 13:30:48 -700

Author: DataMan
Subject: 772
Posted: 17-Apr-2008 at 1:30pm

It's weird that I was looking to do the same thing and this was posted today!

Excuse my ignorance in this post...

So I modified my code to show the following

EntityList<ReportStorage> mReportStorage = new EntityList<ReportStorage>();

List<Entity> oList = new List<Entity>();

oList.Add(mReportStorage[0]);

mPersMgr.SaveChanges(oList);

I only added the [0] because it worked and I knew that I had created an entity list called ReportStorage. Can someone give me an explaination on what the [0] is and is there anything stored in [1] or [Xn]?

Thanks

Saving just one object : Try thisPublic Sub SaveEntity(Of...

Thu, 17 Apr 2008 08:20:59 -700

Author: f3rland
Subject: 772
Posted: 17-Apr-2008 at 8:20am

Try this

[VB]
Public Sub SaveEntity(Of T As Entity)(ByVal pEntity As T)
   Dim oList As New List(Of T)
   oList.Add(pEntity)
   PersistenceManager.DefaultManager.SaveChanges(oList)
End Sub

[C#]
public void SaveEntity(T pEntity) where T : Entity
{
    List oList = new List();
    oList.Add(pEntity);
    PersistenceManager.DefaultManager.SaveChanges(oList);
}

Handle with care when using it with child object... Make sure to save parent first.

Edited by f3rland - 17-Apr-2008 at 8:27am

Saving just one object : I have a situation where I just...

Thu, 17 Apr 2008 08:09:21 -700

Author: BillG
Subject: 772
Posted: 17-Apr-2008 at 8:09am

I have a situation where I just want to save one object. Basically I am reading a value from a table, updating up and want to write the updated value back to the table.

RdbQuery query = new RdbQuery(typeof(LocalInfo));

query.AddClause(LocalInfo.LocalIdEntityColumn, EntityQueryOp.EQ, 1);

LocalInfo = myPM.GetEntity(query);

Int32 nextId = local.NextEventNo;

local.NextEventNo = NextId + 1;

myPM.SaveChanges(????????);

return nextId;

I only want to save the "local" object. LocalInfo is the information about the union local current logged into the app.

It doesn't like the myPM.SaveChanges(local).

Bill