How to update an object with nhibernate + fluent nhibernate?

Question

I do a query through nhibernate to get a record back from the database.

var result  = session.Query<TableA>().Where(x => x.Id == 10).FirstOrDefault();
result.Where = "hi";
session.Update(result)
session.Commit();

So I get a result back and update a property and try to update and then commit it. This will crash because I have forigen key to Table B(Table A can Has one Table B and Table B has many Table A's)

So this reference cannot be null. So when it tries to do an update it crashes.

So I have to do

       var result  = session.Query<TableA>().Where(x => x.Id == 10).FirstOrDefault();
        result.Where = "hi";
        result.TableB = session.Load<TableB>(1);
        session.Update(result)
    session.Commit();

Then it is happy.

How can I do an update without having to load TableB in?

csano · Accepted Answer · 2011-07-22 21:27:28Z

1

Set the Update value of the TableB property mapping to false. I'm not sure how you'd do this using Fluent NHibernate, but it looks like the SetAttribute method will do this for you.

Something along the lines of: .SetAttribute("update", "false");

edited Jul 22, 2011 at 21:27

answered Jul 22, 2011 at 21:21

csano

13.9k2 gold badges31 silver badges46 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to update an object with nhibernate + fluent nhibernate?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related