SubmitChanges() Doesn't Work

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
marhtt
Posts: 5
Joined: Mon 23 Feb 2009 12:45

SubmitChanges() Doesn't Work

Post by marhtt » Mon 23 Feb 2009 12:55

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?

AndreyR
Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Post by AndreyR » Tue 24 Feb 2009 13:30

Thank you for the report, we have found and fixed the problem. Look forward to the next build.

Post Reply