Features of SQLDatabase.Net Library
It is a .net software library that provides a relational database management system which runs on
all major operating system with the same code base and database file format. It supports multi-threading against single connection. See example code for more capabilities.
- ANSI SQL standards
- Atomic Transactions
- Server Less
- Written as .NET dll
- Same Library for x86 and x64
- Zero Configuration
- Does not depend on other libraries
- Transactional ACID Compliant
- B+Tree indexes
- Multi Column indexes
- ACID transactions BEGIN, COMMIT and ROLLBACK
- DISTINCT, ORDER BY, GROUP BY, HAVING, LIMIT, and OFFSET
- Auto Increment int values
- Numeric Sequence generation
- Row Id builtin
- String Format function similar to .Net
- Date time functions
- AES 256 builtin security except PCL
- Column level security based on AES 256 encryption
- ReIndex
- CAST function CAST (Value AS Type)
- Temporary Tables
- In Memory Database
- External Memory Stream databases
- Multiple Schema Files
- Ability to JOIN in memory and on disk files
- Subqueries and Correlated Subqueries
- EXISTS operator
- Boolean Expressions
- Builtin Functions
- Variable-length records
- Triggers and Views
- Storage of Bytes Array as BLOB
- VACUUM command
- INSERT OR .... support
- Small Memory footprint
- Consistent with System.Data class
- Reduced or no learning time
- DDL, DML and DQL are supported
- ALIAS support
- Backup ability
- Copy paste easy deployment
- Multiple .dll files can reside on same machine
- Ability to set different .net cultures
SQLDatabase.Net.dll and SQLDatabase.Net.PCL have many more features than listed , it stands out against similar embedded databases even in basic comparison.