Cannot insert new record in Postgresql 8.4 but no exception is thrown

[lc4pro]

I'm trying to know when to hook to extensibility methods.
So, this is my first test on inserting a record from code.

As stated in the subject, nothing happens (the server table remains empty), but no exception are thrown or errors are raised ( context.HasErrors is false ).

Here is the code. (Edit May/02) May be important to point that Car is a subclass of Vehicles, all the hierarchy in one table.

What am I doing the wrong way?

TIA

Code: Select all

            TestDataContext context = new TestDataContext();
            Console.WriteLine( context.Connection.ConnectionString );
            if (!context.Connection.ConnectionString.Contains( "Password" ))
                context.Connection.ConnectionString += ";Password=xxx";
            context.Connection.Open();
            context.Transaction = context.Connection.BeginTransaction();
            Car c = new Car();
            c.Brand = "Dodge";
            context.Vehicles.InsertOnSubmit( c );
            Console.WriteLine( "Submitting " );
            context.SubmitChanges();
            context.Transaction.Commit();
            Console.WriteLine( "HasErrors = " + context.HasErrors.ToString() );

[MariiaI]

We couldn't reproduce this issue in our environment with the latest build of LinqConnect 4.4.484. We are sending you a sample project to the e-mail address you have provided in your forum profile. Please check that the letter is not blocked by your mail filter. Please modify our sample project so that the issue could be reproduced and send it back to us, or send us your sample project.

JIC: you can use logging to see the generated SQL query: http://www.devart.com/linqconnect/docs/?Logging.html

[lc4pro]

I sent a mail with the project and some extra info.
Thank you.

[MariiaI]

Thank you for the additional information. Please add this code to the CrmSampleDataContext.CrmDataContextExtension.cs file in your sample project:

Code: Select all

 partial void InsertVehicle(Vehicle instance)
   {
    Console.WriteLine( "Inserting {0}", instance.Brand );
    this.ExecuteDynamicInsert(instance);
   }

The ExecuteDynamicInsert method is called inside overridden methods to redelegate the task of generating and executing dynamic SQL for insert operations to LinqConnect.
For more information please refer to:
http://www.devart.com/linqconnect/docs/ ... thods.html
http://www.devart.com/linqconnect/docs/ ... thods.html

[lc4pro]

Thank you a lot. As I always say: "Please read the manual before any use of the appliance"...

[MariiaI]

Glad to see that the issue was resolved. If you have any further questions, feel free to contact us.