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
Sql Server CLR DB Type Mappings
DateTimeOffset -> DateTimeOffset(7)
String -> varchar(200)
Int32 -> int
int64 -> bigint
single, double -> real
byte[] -> varvinary(MAX)
Boolean -> bit
DateTime -> DateTime
TimeSpan -> time(7)