Page 1 of 1

SubmitChanges() Doesn't Work

Posted: Mon 23 Feb 2009 12:55
by marhtt
protected void UpdateContact(int contactID)
{
siteSetupDataContext2 = new SiteSetupDataContext();

try
{
var contacts = from c in siteSetupDataContext2.CONTACTs
where c.CONTACTID == contactID
select c;

CONTACT cont = contacts.Single();
siteSetupDataContext3 = new SiteSetupDataContext();
siteSetupDataContext3.CONTACTs.Attach(cont,contacts.Single());

cont.COMMENTS = "from LINQ";
siteSetupDataContext3.SubmitChanges();

}
catch (Exception ex)
{
throw ex;
}
}

The above code throws no exception but it doesn't update the database. I am using oracle 9i.

It is also using the DataContext class generated by Entity Developer. I am able to retrieve data but not update!
Any ideas?

Posted: Tue 24 Feb 2009 13:30
by AndreyR
Thank you for the report, we have found and fixed the problem. Look forward to the next build.