Fast, Lightweight ORM providing intuitive, Typed API's over ADO.NET's core interfaces
Use
typed, intuitive apis
for simplifying talking to RDBMS's:
OrmLite Tour by @gistlyn on gist.cafe.
Create schema's from code-first POCO's, supports foreign keys, indexes, multi-nested database connections, convenience API's for common data access patterns, querying with typed-expressions, whilst providing seamless access raw SQL and ADO.NET transactions whenever needed.
NuGet package contains support for both .NET v4.5+ and .NET Standard 2.0 (.NET Core 5/3/2).
Use .Core package if running ASP.NET Core on .NET Framework.
Using Microsoft.Data.SqlClient
Using SQL Server 2012 specific SqlGeography, SqlGeometry and SqlHierarchyId Types:
Using Async MySqlConnector:
Using Microsoft.Data.SQLite