RE: [gentle-devel] Mass update with Gentle .net

[<rog...@fe...>]

I use this

grtz

Roger


					IDbConnection dbConnection =3D null;
					IDbTransaction dbTransaction =3D null;

					try
					{	dbConnection =3D this.broker.Provider.GetConnection();
						dbTransaction =3D dbConnection.BeginTransaction();

						-- make your statement
						Broker.Execute(stmt, dbConnection, dbTransaction);

						-- make your statement
						Broker.Execute(stmt, dbConnection, dbTransaction);

						-- make your statement
						Broker.Execute(stmt, dbConnection, dbTransaction);

						dbTransaction.Commit();
					}
					catch (Exception _e)
					{
						if (dbTransaction !=3D null)
						{
							dbTransaction.Rollback();
						}
						throw _e;
					}
					finally
					{
						dbConnection.Close();
						dbTransaction.Dispose();
						dbTransaction =3D null;
					}=20
=20
=20


________________________________

	Van: gop...@li... =
[mailto:gop...@li...] Namens Simon Johnson
	Verzonden: dinsdag 28 februari 2006 17:32
	Aan: gop...@li...
	Onderwerp: [gentle-devel] Mass update with Gentle .net
=09
=09
	Dear All,
=09
	How do I build an update query using Gentle that will update a bunch of =
records within in a transaction?
=09
	Kind Regards,
=09
	Simon Johnson.
=09