UDTMapper 0.0.1-alpha.2

UDT Map

This library use for process List of object to store procedure with parameter user defined table.

example config:

file : /UDTMap/sample.json

{
    "UDTName": "UDTSample",
    "SpName": "SpInsertSample",
    "Properties": [
        {
            "PropertyName": "SampleId",
            "DbPropertyName": "sample_id"
        },
        {
            "PropertyName": "SampleName",
            "DbPropertyName": "sample_name"
        }
    ]
}

Class Model:

public class SampleModel {
    public int SampleId { get; set; }
    public string SampleName { get; set; }
}

User Defined Table:

CREATE TYPE UDTSample AS TABLE (
	sample_id int,
	sample_name nvarchar(max)
);

Store Procedure:

GO
CREATE PROCEDURE SpInsertSample
	@param as UDTSample READONLY
AS
BEGIN
	-- Process UDT Here
	SELECT * FROM @param;
END

Data Access:

using UDTMapper;

public class DataAccess : IUDTCallback 
{
    // sql : "DECLARE @Table as UDTSample; SELECT * FROM @Table"
    public DataTable GetDataTable(string sql) 
    {
        // Get Data Table To DataBase Here.
    }

    // spName: SpInsertSample
    public bool ProcessUDT(string spName, DataTable dataTable, object list) 
    {
        // Call sp here and other logic after execute sp.
    }
    
    public bool InsertSample(List<SampleModel> sample) 
    {
        return UDTMapping.ProcessUDT<SampleModel>(sample, "UDTSample", this);
    }
}