private void ObjectSpace_Committing(object sender, System.ComponentModel.CancelEventArgs e)
{
NonPersistentObjectSpace objectSpace = (NonPersistentObjectSpace)sender;
using (IDbConnection conn = new SqlConnection("uid=sa;pwd=sa;Pooling=false;Data Source=.;Initial Catalog=SkyFaith"))
{
foreach (object obj in objectSpace.ModifiedObjects)
{
if (obj is BusinessObjects.NonPersistentObjects.Student)
{
if (objectSpace.IsNewObject(obj))
{
conn.Execute("insert into student(Id,name,gender,phone) values(@Id,@name,@gender,@phone)", obj);
}
else if (objectSpace.IsDeletedObject(obj))
{
conn.Execute("delete from student where Id = @Id", obj);
}
else
{
conn.Execute("update student set name=@name,gender=@gender,phone=@phone where Id=@Id", obj);
}
}
}
}
}
private void ObjectSpace_Committing(Object sender, CancelEventArgs e)
{
NonPersistentObjectSpace objectSpace = (NonPersistentObjectSpace)sender;
foreach (Object obj in objectSpace.ModifiedObjects)
{
if (obj is BaseNonPersistentClass)
{
if (!globalObjects.Contains((BaseNonPersistentClass)obj))
{
globalObjects.Add((BaseNonPersistentClass)obj);
}
else if (objectSpace.IsDeletedObject(obj))
{
globalObjects.Remove((BaseNonPersistentClass)obj);
}
}
}
}
