DevForce Community Forum : Refresh Related Entity http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2009 : Refresh Related Entity Thu, 21 May 2026 20:24:24 -700 Tue, 16 Mar 2010 14:01:24 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=1664 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ Refresh Related Entity : Sorry, but there is much I don't... http://www.ideablade.com/forum/forum_posts.asp?TID=1664&PID=6370#6370 Author: IdeaBlade
Subject: 1664
Posted: 16-Mar-2010 at 2:01pm

Sorry, but there is much I don't understand about your post. First of all, you refer to "setting up the Department Id in the Employee table," which sounds like some operation you're performing directly on a database table rather than in an object model. In the object model, there are no tables! 
 
Secondly, if you actually defined a relationship between the Employee and Department tables in the database, using Employee.DepartmentId as the foreign key to relate the two, then your object model would have been generated automatically with an association between the Employee and Department entities, and the Employee entity would not even have a DepartmentId property: it would only have a Department property. So I'm really not at all clear on what you're doing.  I'm concerned that you may be misunderstanding the object model in some fundamental way, but I just can't yet tell exactly what it is that you're doing.
 
So let's start with this question:  Have you, in fact, defined a relationship in the database between Employee and Department, using Employee.DepartmentId as the foreign key that links to Department.DepartmentId?  If not, why not?
]]> Tue, 16 Mar 2010 14:01:24 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1664&PID=6370#6370 Refresh Related Entity : I undertstands that it returns... http://www.ideablade.com/forum/forum_posts.asp?TID=1664&PID=6362#6362 Author: ngoel
Subject: 1664
Posted: 15-Mar-2010 at 3:17pm

 
I undertstands that it returns a Null Entity for Department if there isn't one available. My problem is when I am setting up the Department Id in the Employee table (Department Id is a Foriegn Key relating the Department table to the Employee Table), it is not updating the Null Entity to Actual Department. My question was is there a way to force an update. The way I am setting the Department Id is
 
emp.DepartmentId = department.DepartmentId; ( According to the User Selection)
 
It works if we already have a different department attached i.e. user is just changing the department, but it does not work when the Department attached to the Employee is a null entity. I hope I made myself clear this time.
 
Thanks
Nitin
]]> Mon, 15 Mar 2010 15:17:00 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1664&PID=6362#6362 Refresh Related Entity : Originally posted by ngoel But... http://www.ideablade.com/forum/forum_posts.asp?TID=1664&PID=6338#6338 Author: GregD
Subject: 1664
Posted: 09-Mar-2010 at 6:51pm

Originally posted by ngoel

But I think when you create an Employee object with just the Primary Key values, it puts null entity for the Department.
 
No, not really.  When you first create the Employee object, the foreign key to Department is null. DevForce doesn't change that on its own. 
 
However, if DevForce is asked to look up a Department with a foreign key of null (for example, when you reference newEmployee.Department), naturally it can't find one. DevForce could just let an exception be thrown: that's the standard .NET behavior when you refer to something that doesn't exist. But it likes to help you out; so instead of throwing an exception, it return a null entity for a Department. That way, your code doesn't blow up; but you (and your user) can still tell that there's no Department yet assigned.  The foreign key remains null.
 
 
Originally posted by ngoel

I am doing, emp.DepartmentId = department.DepartmentId;

It does take some time to get used to not having to do all of the wiring via the foreign keys.

]]> Tue, 09 Mar 2010 18:51:53 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1664&PID=6338#6338 Refresh Related Entity : Hello Iam not assigning the... http://www.ideablade.com/forum/forum_posts.asp?TID=1664&PID=6334#6334 Author: ngoel
Subject: 1664
Posted: 08-Mar-2010 at 7:09pm

Hello
 
I am not assigning the null department entity to your Employee. But I think when you create an Employee object with just the Primary Key values, it puts null entity for the Department. For setting the Department value, I am doing it a bit differently. Here is my code:
 
Employee emp = Employee.Create(_mgr);
Department department = GetSelectedDepartment();
 
Now, instead of doing emp.Department = department;
 
I am doing, emp.DepartmentId = department.DepartmentId;
 
This way, the DepartmentId gets updated, but emp.Department.DepartmentId is still blank, which suggests that the Department object had not been updated. I think I have to manually update the department object.
 
Thanks
Nitin
 
 
]]> Mon, 08 Mar 2010 19:09:30 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1664&PID=6334#6334 Refresh Related Entity : I don't quite get this.... http://www.ideablade.com/forum/forum_posts.asp?TID=1664&PID=6292#6292 Author: IdeaBlade
Subject: 1664
Posted: 04-Mar-2010 at 2:14pm

I don't quite get this. Presumably you aren't assigning the nulldepartment entity to your Employee; so I don't understand how theDepartment property of your Employee ends up being the null entity.

Isuspect that maybe there are some UI refresh issues involved in whatyou think you're seeing, though I can't quite figure out the scenario.But consider the following console app code:

    private void DoIt() {
      Customer aCustomer = _mgr.Customers.FirstOrNullEntity();
      Order newOrder = Order.Create(_mgr);
      Console.WriteLine("New Order's Customer: {0}", newOrder.Customer.CompanyName);
      newOrder.PropertyChanged += new syscomp.PropertyChangedEventHandler(newOrder_PropertyChanged);
      newOrder.Customer = aCustomer;
      Console.WriteLine("New Order's Customer after assignment: {0}", newOrder.Customer.CompanyName);
      PromptToContinue();
    }

    void newOrder_PropertyChanged(object sender, System.ComponentModel.PropertyChangedEventArgs e) {
      Console.WriteLine("Property changed on Order: {0}", e.PropertyName );
    }

It produces the following output:




]]> Thu, 04 Mar 2010 14:14:34 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1664&PID=6292#6292 Refresh Related Entity : We have a Employee and Department... http://www.ideablade.com/forum/forum_posts.asp?TID=1664&PID=6272#6272 Author: ngoel
Subject: 1664
Posted: 28-Feb-2010 at 8:01pm

We have a Employee and Department Many to One relationship where an employee is attached to single deparment. Employee table has DepartmentId as a Foriegn Key attached to the DepartmentId column in the Department table. When editing the employees, user change the DepartmentId and it automatically update the Department object attached to the Employee entity which is what I want.

But, when creating a new employee, I create a Employee with a Blank Department first and then update the DepartmentId on the Employee object according to the user selection. But this does not update the Department object attached. The Department Object attached is still a Null Entity. Is there a way to force an update on the Employee table so that it updates the department object according to the department id selected? I think we might have to detach the Department object and reattach it. But not sure how I do it. Can you help?

]]> Sun, 28 Feb 2010 20:01:50 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1664&PID=6272#6272