Frequently asked questions
Below are answers to some of the most common questions about ADOM
What does the ADOM Framework buy me as a DBA?
ADOM Automates ALL of your database development for you! Just create your table structure and Foreign Keys in the SQL Diagram tool, and ADOM Automates the rest!
How is the Object Model Generated?
ADOM interrogates the relational data structure, and constructs Hierarchical XML Objects based on Foreign Key definitions. The result is a set of stored procedures which render your data to the consumer as XML/XSD.
How are the objects consumed in code?
ADOM includes a Visual Studio Add-In which generates the data Model for you. Then the XML is simply deserialized directly into the Model. It's that easy!
How do you update the database tables?
A single stored procedure takes your resulting XML object and ingests it into the relational table structure in sub-second time, in a single call!
Does ADOM Support JSON?
Absolutely! You can either serialize your data model as JSON, or you can convert the XML to JSON and use the AdomScript.js library for SPA Development.
How does ADOM SQL Replication work?
The ADOM SQL Replication process uses the ADOM XML object structure to create a super efficient replication process that will run on ANY SQL database, including a pure Azure SQL DB!
Guaranteed Security
The Security Model locks data down at the column level, and is implemented in both directions (select and insert/update)
Object Model
First and only ORM that manages everything from within the database layer using efficient and secure stored procedures
Code Faster
Database Object Structures you can code with are delivered via automated processes, allowing Code Projects to adapt to the Database as it changes
Automated Development
Automates the generation of Log Audit tables, highly-tuned Triggers to populate Log tables, generation of stored procedures, and more.