View on GitHub
SauceDB
.net ORM with multipe database engine support.
Download this project as a .zip file
Download this project as a tar.gz file
Features
Documentation
Load from a table
Load from a view
Load from a stored proc
Linq
Field aliasing
Transactions
VS Extension
Query Predicate
Raw Access
Database Migrator
Databinding
Schema Validation
Table Init
Schema Support
Object Init
Enum Columns
Overrides
Object Name
Object Schema
Primary Keys
Column Loading
Column Savings
Foreign Keys
Default Values
Type Mappings
Sql Server
MySQL
Postgre
SqLite
Examples
CRUD
DB Quirks
SqLite
Postgre CLR DB Type Mappings
STRING -> character varying
Int32-> INTEGER
Int64 -> bigint
single, double -> real
byte[] -> image
Boolean -> bit
DateTime,datetimeoffset -> date
timespan -> time without time zone