sdrapkin / Securitydriven.tinyorm
Licence: other
.NET micro ORM done right.
Stars: ✭ 281
Labels
Projects that are alternatives of or similar to Securitydriven.tinyorm
Gorose
GoRose(go orm), a mini database ORM for golang, which inspired by the famous php framwork laravle's eloquent. It will be friendly for php developer and python or ruby developer. Currently provides six major database drivers: mysql,sqlite3,postgres,oracle,mssql, Clickhouse.
Stars: ✭ 947 (+237.01%)
Mutual labels: sql, orm, mssql
Prisma
Next-generation ORM for Node.js & TypeScript | PostgreSQL, MySQL, MariaDB, SQL Server, SQLite & MongoDB (Preview)
Stars: ✭ 18,168 (+6365.48%)
Mutual labels: orm, sql-server, mssql
Sequelize
An easy-to-use and promise-based multi SQL dialects ORM tool for Node.js
Stars: ✭ 25,422 (+8946.98%)
Mutual labels: sql, orm, mssql
Xorm
xorm是一个简单而强大的Go语言ORM库,通过它可以使数据库操作非常简便。本库是基于原版xorm的定制增强版本,为xorm提供类似ibatis的配置文件及动态SQL支持,支持AcitveRecord操作
Stars: ✭ 1,394 (+396.09%)
Mutual labels: sql, orm, mssql
Nut
Advanced, Powerful and easy to use ORM for Qt
Stars: ✭ 181 (-35.59%)
Mutual labels: sql, orm, sql-server
Sqlhelper
SQL Tools ( Dialect, Pagination, DDL dump, UrlParser, SqlStatementParser, WallFilter, BatchExecutor for Test) based Java. it is easy to integration into any ORM frameworks
Stars: ✭ 242 (-13.88%)
Mutual labels: sql, orm
Xo
Command line tool to generate idiomatic Go code for SQL databases supporting PostgreSQL, MySQL, SQLite, Oracle, and Microsoft SQL Server
Stars: ✭ 2,974 (+958.36%)
Mutual labels: sql, orm
Quickperf
QuickPerf is a testing library for Java to quickly evaluate and improve some performance-related properties
Stars: ✭ 231 (-17.79%)
Mutual labels: sql, orm
Db
Data access layer for PostgreSQL, CockroachDB, MySQL, SQLite and MongoDB with ORM-like features.
Stars: ✭ 2,832 (+907.83%)
Mutual labels: sql, orm
Granite
ORM Model with Adapters for mysql, pg, sqlite in the Crystal Language.
Stars: ✭ 238 (-15.3%)
Mutual labels: sql, orm
Fluentmigrator
Fluent migrations framework for .NET
Stars: ✭ 2,636 (+838.08%)
Mutual labels: sql, sql-server
Data
ATK Data - Data Access Framework for high-latency databases (Cloud SQL/NoSQL).
Stars: ✭ 243 (-13.52%)
Mutual labels: sql, orm
Sqlfiddle3
New version based on vert.x and docker
Stars: ✭ 242 (-13.88%)
Mutual labels: sql, sql-server
bizbook-server
The repository of bizbook server web api project
Stars: ✭ 45 (-83.99%)
Mutual labels: sql-server, mssql
uzbekistan-regions-data
Full Database of regions Uzbekistan available in JSON, SQL & CSV Format All Regions, Districts & Quarters with Latin, Cyrillic and Russian versions. (Районы (туманы) Республики Узбекистан и Города областного (республиканского) подчинения)
Stars: ✭ 46 (-83.63%)
Mutual labels: sql-server, mssql
Simple, fast, and secure micro ORM for .NET.
TinyORM by Stan Drapkin [sdrapkin at sdprime dot com]
Documentation: wiki
Features:
- Focused on SQL Server (any
SqlClient
-based db engine). Azure SQL is supported as well. - Intuitive, tiny, simple API. This is usually the hardest part for libraries to get right.
-
Does not obscure or reinvent
T-SQL
. If you prefer APIs that hideT-SQL
incompetence, look elsewhere. -
Very fast. As fast as competition (
Dapper
,OrmLite
,LLBLGen
,EF Core
, etc. benchmarks). -
Seamlessly transactional and safe. Transactions are not merely supported - they are the default.
-
XACT_ABORT=ON
(automatic transaction rollback on runtime T-SQL errors). - Custom transaction scopes are declared via standard
TransactionScope
instance (created viaTinyORM
.DbContext
.CreateTransactionScope()
factory).
-
- Transparent connection management. One less thing to worry about and screw up. Never think about connections again.
-
Task
-basedasync
API (ie. the API). All calls are buffered (focus on safety and fast connection release). -
POCOs or
anonymous
objects are fine. No inheritance, interface, or attribute requirements. - Returns
dynamic
entities which can be consumed directly, or projected to statically-typed objects (fast!).- Either strict (perfect-match) or relaxed (best-effort) projection of
dynamic
to statically-typed objects.
- Either strict (perfect-match) or relaxed (best-effort) projection of
- Full parameterization, with parameter list expansion (ex.
WHERE Id IN (@IdList)
). This also helps prevent SQL injection.-
CHAR
,VARCHAR
,NCHAR
,NVARCHAR
support forstring
parameters.
-
- Single or multiple Result Sets.
-
Snapshots provide change-tracking, with
UPDATE
T-SQL
generation for partial updates. - Intelligent batched *bulk* command sequences via
QueryBatch
(not just forINSERT
- for allCREATE/UPDATE/DELETE/MERGE
commands). -
Streaming data-out support (ex. streaming out
BLOBs
/files). -
Auditing
- Caller identity tracking (which user made the call?).
- Callsite tracking (which source code filename, method, and line# made the call?).
- Helpers for
CREATE
,UPDATE
,DELETE
, andUPSERT
T-SQL
generation. -
SequentialGuid
generator for fragmentation-free, unique, unguessable, code-generated clustereduniqueidentifier
indexes. - c# 7.0 in
safe
mode. Compiledany cpu
for .NET 4.5.2+. - Tiny codebase. Tiny ~45k
.dll
. -
TinyORM
on NuGet (Install-Package TinyORM
). - MS-PL (Microsoft Public) license. If MS-PL does not suit you, contact me.
If you are serious about SQL Server, give TinyORM a try (even if you're a Dapper
fan).
Simple TinyORM query
var db = DbContext.Create(connString);
var query = await db.QueryAsync("select [Answer] = @a + @b", new { @a = 123, @b = 2 });
Console.WriteLine(query.First().Answer); // prints "125"
static string connString = "Data Source=.\\SQL2012; Initial Catalog=tempdb; Integrated Security=True;";
Note that the project description data, including the texts, logos, images, and/or trademarks,
for each open source project belongs to its rightful owner.
If you wish to add or remove any projects, please contact us at [email protected].