Exception: "transaction has aborted" When Implementing code sample with DevArt dotConnect for postgres

Hello everyone,

I am trying to use DevArt dotConnect for a postgres database.
I am following the Code Sample:Hello DevForce.
I followed every step using Northinwind db and it was working fine.
Then I did same typical steps only this time using a DevArt dotConnect connection instead,, and it fails with the exception:
    - IdeaBlade.EntityModel.EntityServerException:The transaction has aborted
    - FailureType: IdeaBlade.EntityModel.PersistenceFailure.Other

This is the StackTrace:

   at IdeaBlade.EntityModel.EntityManager.HandleEntityServerException(Exception ex, Boolean tryToHandle, PersistenceOperation operation, Boolean throwOnError)
   at IdeaBlade.EntityModel.EntityManager.HandleEntityServerException(Exception ex, Boolean tryToHandle, PersistenceOperation operation, Boolean throwOnError)
   at IdeaBlade.EntityModel.EntityManager.ExecuteServerQuery(IEntityQuerySurrogate entityQuery)
   at IdeaBlade.EntityModel.EntityManager.ExecuteFetch(IEntityFinder finder)
   at IdeaBlade.EntityModel.EntityQueryFinder.Execute()
   at IdeaBlade.EntityModel.EntityManager.ExecuteQueryCore(IEntityQuery query, Boolean isAsync)
   at IdeaBlade.EntityModel.EntityManager.ExecuteQuery[T](IEntityQuery`1 query)
   at IdeaBlade.EntityModel.EntityQueryExtensions.Execute[T](IEntityQuery`1 query)
   at IdeaBlade.EntityModel.EntityQuery`1.GetEnumerator()
   at WpfApplication1.MainWindowViewModel.FirstSample() in D:\ITProjects\Scrap\WpfApplication1\WpfApplication1\MainWindowViewModel.cs:line 37
   at WpfApplication1.MainWindowViewModel.Start() in D:\ITProjects\Scrap\WpfApplication1\WpfApplication1\MainWindowViewModel.cs:line 22
   at WpfApplication1.MainWindow.Window_Loaded(Object sender, RoutedEventArgs e) in D:\ITProjects\Scrap\WpfApplication1\WpfApplication1\MainWindow.xaml.cs:line 32 ...

Any ideas what is the problem?

Thanks.


Edited by yasirhantoush - 01-Mar-2011 at 12:47am

Hello sbelini,

Thanks for the follow up.

I Found out that whenever I set the DevForce Enabled = False in the model properties, it works absolutely fine.
That means when I am using the Entity Framework without DevForce.

Thanks.
Yasir.


Edited by yasirhantoush - 05-Mar-2011 at 12:20pm

Hello Silvio,

After adding the .Net reference System.transactions, and adding the provided code, it is working now.

Edited by yasirhantoush - 06-Mar-2011 at 3:29am