Hi All,

i'm using NHibernate in my project(C# Winforms Application). I have a requirment to populate some data in the database(SQLserver) with data integrity.

I have two tables.

EMPLOYEE
EmpId
Name

EMPLOYEEADDRESS
EmpId
Address
Addresstype.

The employee employeeaddress relationship is one t many. In a single transaction I want to insert one employee record in employee table and multiple address for same employee in employeeAddress table.

Can anyone help me


Thanking you
Satheesh

ISession.BeginTransaction and ITransaction.Commit() or ITransaction.Rollback()

Gert

I can populate the data in two tables with different transactions. But in a single transaction i'm not able to, so the data integrity will lost.

I want to save all the data at the same time other wise roll back the transaction

Please give me some samples with with an example i mentioned in the question.


regards
Satheeshj

It is hard to understand where is Your problem. But usual transaction handling code is:



You should read the NHibernate documentation, there is some information...

Gert

i have Two objects
Member (mId,mName)
memberAddress(aId(auto generated in db),mId,Address,addresstype)


Member mr=new Member();
memberAddress [] m=new memberAddress[3];
mr.mId=1;
mr.mName="Sam";
memberAddress m1=new memberAddress();
memberAddress m2=new memberAddress();
m1.mId=1;
m1.address="[email protected]";
m1.type="Mail";
m2.mId=1;
m2.address="#888";
m2.type="Home";
m[0]=m1;
m[1]=m2;
mem.SaveMember(m,mr);

and my save member mthod is

public void SaveMember(memberAddress [] address,Member mem)
{
ITransaction tx = null;
try
{
if(!session.IsConnected)
{
session.Reconnect();
}

tx = session.BeginTransaction();
session.Save(mem);
foreach(memberAddress adr in address)
{
session.Save(adr);
}
tx.Commit();
session.Disconnect();

}
catch (Exception ex)
{
tx.Rollback();

session.Disconnect();
// handle exception
}
}



The above is my factory code and it is not working.

I think now you can understand more about my problem. I want to save one master table entry and and multiple child entries in a transaction.


Waiting for reply.


Thanks & Regards
Satheesh

Please explain "not working". Anyway, if Your session is opened, it may choose to flush any changed objects it knows about at any time.

Gert