[Solved] Is there any problem to use the database without OpenAccess ORM?

[Tajes]

Hello,
    We were wondering if we can create a C# aplication with OpenAccess ORM mapped to a DataBase in MySQL, and on the other hand to have a application made in Visual Fox Pro that connects to the same DataBase using a ODBC driver.
    Does OpenAccess make something in the database that means a problem to the other application? Will it be a problem inserts, updates, deletes in related tables that represents related persistent classes?


Thanks an sorry for my English.

[Jan Blessenohl]

Hello Iván Tajes,
There are no problems using OpenAccess applications in parallel to other programs.

You just have to make sure that you do not break the OpenAccess internal key mechanism, if used. If you do not specify a primary key field in OpenAccess, we add a non visible field to the class/table that contains the key calculated by a HighLow key generator. If you now insert rows into such a table this will probably break our key generator mechanism and you might see duplicate key exceptions.

Kind regards,
Jan Blessenohl
the Telerik team

[Tajes]

Then, if we fill the primary keys and foreing keys correctly (not empty, not duplicate and foreing keys that exists) It won't be a problem?

And if we use the autogenerate key feature of MySQL, will it work correctly?

Thanks.

[Jan Blessenohl]

Hi Iván Tajes,
Yes, yes.

Best wishes,
Jan Blessenohl
the Telerik team