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.
ADOM Framework SQL Replication
The latest new feature in the ADOM Framework is SQL Transactional Replication. However, our replication process has several improvements over the old MS Transactional Replication process as outlined below.
Single Distribution publication can service any number of different Subscriptions
Subscribers can subscribe to any number of tables in the Distribution Publication
No limitations on SQL Server Versions for Replication
Super-efficient dynamic processing via ADOM XML objects!
No “Snapshot” creation and management required… Just do a backup/Restore and then kick off Replication
Table structure changes of the Distribution catalog are automatically pushed to subscriber with each backup/restore
ADOM Replication’s Backup/Restore process is Table-Based so that ONLY the tables your Replicated database subscribes to get updated! Thus, you can do things like setup the ADOM Table Logging on the Replicated copy and leave your Production server pristine!
The ADOM Transactional Replication process works on a Pure Azure SQL DB!
Features of the ADOM Framework
Here are a few of the Features provided by the Framework
SQL REPLICATION
SQL Transactional Replication works on ALL servers versions that support OPENXML
AUDIT TABLES
ADOM auto-generates Log Tables and Super Efficient Triggers to manage them
XML OBJECTS
Stored Procedures return both the Hierarchical XML objects and XSD metadata
SECURITY MODEL
The ADOM Security Model locks the data down at the column level!
MODEL GENERATOR
Visual Studio Add-In generates C# data Model in code behind
JSON & SPA
The AdomScript.js library generates most efficient SPA development!
Subscription Plans
There are 3 different subscription plans depending on your needs
Single DB
Single Database
- IDFactory Configuration Tool
- Visual Studio Plug-In
- AdomScript.js Library
- Single Database
- Internal Security
Single Server
Single SQL Server
- IDFactory Configuration Tool
- Visual Studio Plug-In
- AdomScript.js Library
- Multiple DB's on Single SQL Instance
- Integrated Security
UNLIMITED
Unlimited Servers
- IDFactory Configuration Tool
- Visual Studio Plug-In
- AdomScript.js Library
- Unlimited SQL Instances
- Integrated Security
- SQL Replication
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!
