SauceDB

Features

1. Speed
2. Column Value mapping to Enum
3. Works on any object
4. No Code Generation Required
5. Object primary key set on object when inserted
6. Default values set on object when inserted (currently only supported on sql server)
7. No Data Context required
8. Multiple Data store support
9. Full crud with no SQL required
10. Multi Database Support (SqlServer, MySql, Postgre, Sqlite) with a shared API
11. Load from a table
12. Load from a view
13. Load from a stored proc
14. Linq
15. Field aliasing
16. Transactions
17. VS Extension
18. Query Predicate
19. Raw Access
20. Database Migrator
21. Databinding
22. Schema Validation
23. Table Init
24. Schema Support
25. Object Init
26. Enum Columns

Assumptions

1. The object name is the table name with an s (if not on the object name)
2. The table will be located in the default schema
3. A property named id (case insensitive) will be the primary key
4. The property name is the column name
5. The column will always be loaded
6. The column will always be saved
7. All Columns Map to a property
8. All objects will be validated on the schema
9. No column is a foreign key
10. The default value of all fields is null
11. No object requires additional initialization (calculation etc)