Linq2Sql Clone an Object C#

Question

tblAgreement AgreementOld = (from g in TDC.tblAgreements
                             where g.AccountID == ids.accountID && g.AgreementID == AgreementID
                            select g).SingleOrDefault();

Guid AgreementIDNew = Guid.NewGuid();
var AgreementNew = AgreementOld;
AgreementNew.AgreementID = AgreementIDNew;
AgreementNew.StatusChangeDate = DateTime.Now;
AgreementNew.CreationDate = DateTime.Now;
AgreementNew.AccountID = ids.accountID;
AgreementNew.CreatedByID = ids.userID;
TDC.tblAgreements.InsertOnSubmit(AgreementNew);

I am trying to create a new object with some same values as old object, But i am getting this error message;

Cannot add an entity that already exists.

Note: I don't want to delete OLD object. Kindly Help me I have google it but couldn't find any help or solution.

Ehsan Sajjad · Accepted Answer · 2015-02-24 07:57:56Z

1

You need to create a new object, currently your new object is also reffering to old one:

var AgreementNew = new Agreement();  // create a new instance
AgreementNew.SomeProperty = AgreementOld.SomeProperty; // assign property from old to new
AgreementNew.AgreementID = AgreementIDNew; // new proerties here
AgreementNew.StatusChangeDate = DateTime.Now;
AgreementNew.CreationDate = DateTime.Now;
AgreementNew.AccountID = ids.accountID;
AgreementNew.CreatedByID = ids.userID;
TDC.tblAgreements.InsertOnSubmit(AgreementNew);

answered Feb 24, 2015 at 7:57

Ehsan Sajjad

62.6k16 gold badges112 silver badges171 bronze badges

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

2 Comments

Waqar Ahmed Over a year ago

I know this solution but its so headaching!

Ehsan Sajjad Over a year ago

@WaqarAhmed you have to do this way, its reference type so that way won't work what you want

Amit · Accepted Answer · 2015-02-24 08:04:27Z

0

If AgreementOld is DataTable then just do

var AgreementNew = AgreementOld.Copy();

answered Feb 24, 2015 at 8:04

Amit

8906 silver badges13 bronze badges

Collectives™ on Stack Overflow

Linq2Sql Clone an Object C#

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related