Home - lobodava/artisan-orm GitHub Wiki

Welcome to Artisan.Orm documentation wiki!

• What's New in v4

• The Sample

• Getting Started

• RepositoryBase

  • SqlCommand Initialization
  • About Connection Strings

• Read-methods understanding

  • ReadToDictionary & ReadAsDictionary

• SqlCommand Extensions

  • CommandType and CommandText configuration
  • SqlCommand "AddParam" extensions
  • SqlCommand extensions for SqlDataReader execution
  • cmd.AddTableParam
    • cmd.AddTableParam for Ids
    • cmd.AddTableRowParam

• SqlDataReader extensions

• Mappers

  • What is ObjectRow?
  • What the Mappers are for?
  • RequiredMethod for MapperFor Attribute
  • Auto-Mapping
  • Inline Mappers

• User Defined Table Types

• Negative identities and object graph saving

• Artisan Way of DataReply

• Transactions

• Code Generation

• INode Interface and ToTree Methods

v4 features

• BulkCopy

• ReadToLists — multi result sets

• MergeJoin

• Streaming with IAsyncEnumerable

Reference

• Output Parameters

• JSON Parameters (NET6+)

• DateOnly / TimeOnly (NET6+)

Patterns & integration

• Using Artisan.Orm in ASP.NET Core

• Testing Your Repository

• Performance Notes

Background reading

The articles below are the long-form narrative behind Artisan.Orm — the why and the how it evolved. Originally published on CodeProject between 2016 and 2021, re-published here under CC-BY-SA-4.0 after CodeProject went read-only in late 2024.

• 1. How to Save an Object Graph in Master-Detail Relationship with One Stored Procedure — pairs with Negative identities and object graph saving.

• 2. Artisan.Orm — How to Reinvent the Wheel — the origin story of the library.

• 3. The Artisan Way of Data Reply — pairs with Artisan Way of DataReply.

• 4. Combination of Id-ParentId and HierarchyId Approaches to Hierarchical Data — pairs with INode Interface and ToTree Methods.

See articles/README.md in the main repo for the full index.