►Next Version Q◄

BenHayat

Hello Support;

As part of the next version "previous discussion", where Aware will create all the necessary foreign keys where third party tools can recognize the table relationships created by AwareIM, I want to ask the following question:

Note: Microsoft .Net uses Entity Framework ORM as the Data Access Layer between Database and Application.
Part of EF that does this, is called "Data Migration". It basically looks at the Object relationships in C# code and then creates/maintains Database structure.

Question:
Imagine, we have developed an application in ASP.Net that uses EF to consume the same database that was created by AwareIM and assuming the next version of AwareIM, provide all the foreign keys that EF can establish and recognize all the tables relationships.
My question is:
If ASP App, changes data (ADD/EDIT/DELETE) on any data record in Aware's database, how will Aware recognize it's data has been changed by another application???
This is going to be a major concern if the data is shared between two applications and Aware can see up-to-date data.

Thank you in advance!

BenHayat

^BUMP

aware_support

"My question is:
If ASP App, changes data (ADD/EDIT/DELETE) on any data record in Aware's database, how will Aware recognize it's data has been changed by another application??? "

I don't quite understand the question. Aware IM won't automatically "recognize" any changes done externally - by ASP.NET or any other tools - that is, if your question implies that Aware IM is supposed to refresh its data automatically. When Aware IM reads external data next time it will read the new data.

BenHayat

aware_support wrote
I don't quite understand the question. Aware IM won't automatically "recognize" any changes done externally - by ASP.NET or any other tools - that is, if your question implies that Aware IM is supposed to refresh its data automatically. When Aware IM reads external data next time it will read the new data.

Let me revise my question. In Aware, if user A opens customer "John Smith" record and while user A is making changes to the record, if User B opens the same customer "John Smith" and makes changes to it and saves it, then If User A tries to save, she will get error that the record has been changed by another user.

Now suppose, in another case while two systems sharing the same database, user B happens to be an ASP.Net system that made the change to "John Smith" while Aware user was making changes (user A). Will Aware system recognize that User B had mad changes and saved it and not to overwrite his changes with User A data? Another words, will proper record locking be maintained by Aware, if data is changed by another system other than Aware?

aware_support

No, Aware IM won't recognize this situation for external tables. If the second user saves the form it will overwrite any changes made by the .NET system while he was filling out the form.

BenHayat

aware_support wrote
No, Aware IM won't recognize this situation for external tables. If the second user saves the form it will overwrite any changes made by the .NET system while he was filling out the form.

Just want to make sure we're talking about the same thing.
These are NOT external tables. These are tables that were created by Aware as part of it's database.
This is the case where third party tools will be using Aware database and Not Aware using external tables.
This is the case where Aware is in full control of it's database tables, except an outside tool might change it's data.

Some systems use the database engine's record locking regardless of who is accessing the data. But in Aware, is Aware maintaining it's own record locking or relying on database engine record locking?

aware_support

In this case the external tools need to update the data in an Aware IM-friendly way - there is a special field in any Aware IM-managed table that stores the version of the record. They need to increment this version when they make a change. If they do, then Aware IM will continue to work properly and maintain optimistic locking.

BenHayat

aware_support wrote
In this case the external tools need to update the data in an Aware IM-friendly way - there is a special field in any Aware IM-managed table that stores the version of the record. They need to increment this version when they make a change. If they do, then Aware IM will continue to work properly and maintain optimistic locking.

Support, Thank you!!!
That's what I was looking for to know. This is huge to solve this problem, otherwise third party tools could mess up Aware's data integrity.