Update reference

Thu, 06 Mar 2008 22:56:58 Z

I have a LastModified relationship between SiteUser and GroupPost entities (1..*)

I'm trying to update reference using code below

using (myEntities ee = new myEntities())

{

GroupPost post = (from posts in ee.GroupPost.Include("SiteUser")

where posts.PostID == id
select posts).First<GroupPost>();

SiteUser u = ee.SiteUser.First<SiteUser>(e => e.UserName == HttpContext.User.Identity.Name);

post.SiteUser = u;

ee.SaveChanges();
}

which throws an exception

A relationship is being added or deleted from relationship set 'SiteUserGroupPost'. Given cardinality constraints, a corresponding 'GroupPost' must also be added or deleted.

How can I bind one existing entity object to another existing object?

Fri, 07 Mar 2008 09:17:01 Z

Hello,

I don't understand. I did the same as you and I have no problem.

Sun, 09 Mar 2008 14:47:51 Z

I've solved this problem. I changed SiteUser End multiplicity from 1 to 0..1.