CommandType.StoredProcedure + SqlDbType.Structured (edit)

https://objectcomputing.com/resources/publications/sett/november-2013-sql-server-tvp-procedure-compatibility-in-net

Dapper

Dapper 1.50.2 (.NET 4.5)

https://hant.kutu66.com/database/article_6484

https://todothinkofname.net/2016/05/30/Dapper-with-Net-core/

SQL Server Features - Dapper with .NET Core:

https://medium.com/dapper-net/sql-server-specific-features-2773d894a6ae

  • Table-Valued Parameters
  • Spatial Data Types
  • HiearchyID Data Type

Table Valued Parameters with Dapper

https://www.codeproject.com/Articles/835519/Passing-Table-Valued-Parameters-with-Dapper

C# and Table Value Parameters

https://www.codeproject.com/Articles/39161/C-and-Table-Value-Parameters

https://www.c-sharpcorner.com/UploadFile/ff2f08/table-value-parameter-use-with-C-Sharp/

https://guptaashish.com/tag/sqldbtype-structured/

Dapper

https://www.c-sharpcorner.com/uploadfile/mahesh/executing-a-stored-procedure-programmatically/

https://www.c-sharpcorner.com/uploadfile/pchandraker/passing-table-valued-parameter-to-stored-procedu-part-1/

https://www.c-sharpcorner.com/UploadFile/pchandraker/passing-table-valued-parameter-to-stored-procedu-part-2/

Extend Dapper Dynamic Parameters to send Table Valued Parameter to SQL Server

http://www.rosengren.me/blog/extend-dapper-dynamic-parameters-to-send-table-valued-parameter-to-sql-server