I was thinking of creating an dynamic class that would have a member like so which is parsed through the initialiser.
<String>dynamic.Query: An INSERT INTO ... ON DUPLICATE UPDATE statement
This class would have an LinkObject method which accepts a <Dynamic>dynamic parameter which adds the dynamic parameter change hooks.
When a change hook is called the Dynamic instance is added to an array if not already in there (maybe remove hooks and readd later).
Then on each frame get the updated instances and run the query.
Edit: ive already written code to grab dynamic objects from a collection with LINQ style code for selecting elements from the database so every table row isnt in memory.
https://github.com/ntoxin66/Dynamic/...ftest.sp#L1125
So writting this around a collection is key.
The collection acts like a table and you should be able:
1. Select items to it
2. Items in it auto update like first part of this post
3. Remove items from it