DevForce Community Forum : Community Forum now on StackOverflow

Community Forum now on StackOverflow : DevForce moved to Stackoverflow

Fri, 02 May 2014 11:39:53 -700

Author: IdeaBlade
Subject: DevForce moved to Stackoverflow
Posted: 02-May-2014 at 11:39am

We've moved free community support for DevForce to StackOverflow. By moving to StackOverflow,one of the largest communities of developers on the internet will be able tobenefit from your questions—and you from their answers.

You can still use all the great content in this forum. If you don’t find youranswer here then head on over to StackOverflow to post your question using the DevForcetag.

Edited by IdeaBlade - 02-May-2014 at 12:02pm

Community Forum now on StackOverflow : why would Importing an entity fail?

Mon, 28 Apr 2014 19:14:16 -700

Author: DenisK
Subject: why would Importing an entity fail?
Posted: 28-Apr-2014 at 7:14pm

Sorry, I missed that you are creating a new EntityManager upon each add.

If that's the case, the next thing to debug is, make sure the Import succeeds, and right after the import, search the EM's cache by using the EntityManager.FindEntities method. This should only return 1 entity of type Memo and that its EntityKey is what you'd expect.

Community Forum now on StackOverflow : why would Importing an entity fail?

Mon, 28 Apr 2014 15:17:32 -700

Author: BillG
Subject: why would Importing an entity fail?
Posted: 28-Apr-2014 at 3:17pm

What i dont understand is that when i pop up the dialog box for Memo form i am creating a new repository before importing the passed in memo object. Why would the previous one still be there?

going back to my example. on the list form, the user clicks Add, i create the memo and pass it to the dialog box form. in the dialog box form, i create a new repository/entity manager, import the passed in memo to the newly created entity manager. if i create a new repository/entity manager, clear it of all memos, and then do the import, should not that one be the only memo in the cache?

Bill

Community Forum now on StackOverflow : why would Importing an entity fail?

Mon, 28 Apr 2014 14:43:38 -700

Author: DenisK
Subject: why would Importing an entity fail?
Posted: 28-Apr-2014 at 2:43pm

As you've already noticed, DevForce will generate a temporary key for entity with a PK identity column.

Entities with temporary key and EntityState of Added are considered new entities by the EntityManager. What this means is that when you import entities with the same id and EntityState of Added, the later import doesn't overwrite the earlier import. But rather, the EntityManager will see the later entity as a new entity and will increment the id. So what you have are 2 entities with different ids.

I suspect that this is what's happening here. The fix is to set the EntityState to Unchanged before import and set them back to Added before persisting them to the db.

Community Forum now on StackOverflow : PredicateBuilder with ands / ors

Mon, 28 Apr 2014 13:41:52 -700

Author: BillG
Subject: PredicateBuilder with ands / ors
Posted: 28-Apr-2014 at 1:41pm

I know how to use Predicate Descriptions with Ands.

I have the following code

public IEnumerable<MembersAndJobHistory> GetMembersForBatchByEmployer(Batch batch)       {           IPredicateDescription compositePred;           PredicateDescription p1 = null, p2 = null, p3 = null, p4 = null, p5 = null, p6 = null;              p1 = PredicateBuilder.Make(typeof(MembersAndJobHistory), "Status", FilterOperator.IsEqualTo, "A");           p2 = PredicateBuilder.Make(typeof (MembersAndJobHistory), "EmployerNo", FilterOperator.IsEqualTo,               batch.EmployerNo);           p3 = PredicateBuilder.Make(typeof(MembersAndJobHistory), "PayVia", FilterOperator.IsEqualTo, "E");            if (!CommonControl.IsControlTrue("NoMonthlyDues"))           {               p4 = PredicateBuilder.Make(typeof(MembersAndJobHistory), "Dues", FilterOperator.IsEqualTo, 0);            }           if (batch.BillYN != null)           {               p5 = PredicateBuilder.Make(typeof(MembersAndJobHistory), "BillYN", FilterOperator.IsEqualTo, batch.BillYN);                        }           p6 = PredicateBuilder.Make(typeof(MembersAndJobHistory), "TSStart", FilterOperator.IsLessThanOrEqualTo, batch.PayPeriodEnd);            compositePred = CombinePreds(p1, p2, p3, p4, p5, p6);            var query = Manager.MembersAndJobHistories               .Where(compositePred)               .OrderBy(m => m.SocSecNo);            var results = query.Execute();           return results;       }

       public IPredicateDescription CombinePreds(params PredicateDescription[] preds)      {           var nonNullPreds = preds.Where(pd => pd != null).ToArray();           var result = PredicateBuilder.And(nonNullPreds);           return result;      }

Now i need to add two more predicates to the query. Basically i want to And an Or. For example, and where
 TSFinish >= batch.PayPeriod or TSFinish is null

How do i fix my code to handle these 2 new predicates?

Bill

Community Forum now on StackOverflow : why would Importing an entity fail?

Mon, 28 Apr 2014 12:21:38 -700

Author: BillG
Subject: why would Importing an entity fail?
Posted: 28-Apr-2014 at 12:21pm

yes. It is an identity column.

Community Forum now on StackOverflow : why would Importing an entity fail?

Mon, 28 Apr 2014 11:53:54 -700

Author: DenisK
Subject: why would Importing an entity fail?
Posted: 28-Apr-2014 at 11:53am

Hi BillG,

Are you using an integer data type with Database Identity generation for your Memo's primary key?

Community Forum now on StackOverflow : why would Importing an entity fail?

Sun, 27 Apr 2014 00:30:29 -700

Author: BillG
Subject: why would Importing an entity fail?
Posted: 27-Apr-2014 at 12:30am

I have the following situation. the uses clicks an add button on a form. I create the entity for the add button in question lets say "Memo"

var memo = Repository.CreateMemo(member);

then I call my dialog box to display the memo

MemoEditForm form = new MemoEditForm(memo);
DialogResult result = form.ShowDialog()

in the constructor for the MemoEditForm. I have the following.

InitializeComponent();
Repository = UnionRepository.CreateRepository();
Repository.ClearAllMemberMemos();
currentMemo = Repository.ImportMemberMemo(memo);
editMode = memo.EntityAspect.EntityState == EntityState.Added ? EditMode.Add : EditMode.Edit;
MemberMemoBS.DataSource = currentMemo;
currentMember = currentMemo.Member;
LoadData();

basically I create a new repository/entity manager. I make sure the entity manager is clear. I import the passed over newly created memo object and import it into the new entity manager. if the user enters all the fields in and then clicks "Save" I close the dialog box and refresh a grid with the new memo. If they click cancel, I remove the entity from the first cache.

This works for the first memo. I add a memo (I click cancel). I click add again and the import this time returns a null for currentMemo.

so my question is why would the import fail. this is my import method

     public MemberMemo ImportMemberMemo(MemberMemo memo)
        {
            if (memo == null || memo.EntityAspect.IsNullOrPendingEntity)
            {
               throw new ArgumentException("Imported memo is null or nullo");
            }
            // Don't bother if already attached to repository's manager
            if (memo.EntityAspect.EntityManager == Manager) return memo;

            ImportEntities(new Object[] { memo });
            return (MemberMemo)Manager.FindEntity(memo.EntityAspect.EntityKey);
        }

    private void ImportEntities(IEnumerable entities)
        {
            EnsureEntitiesAreUnmodified(entities);
            Manager.ImportEntities(entities, MergeStrategy.OverwriteChanges);
        }