/C#/C# dapper execute stored procedure with parameters

C# dapper execute stored procedure with parameters

public void GetSomething(int somethingId)
{
    IRepository<Something, SomethingEnum> repository = UnitOfWork.GetRepository<Something, SomethingEnum>();

    var param = new DynamicParameters();
    param.Add("@somethingId", dbType: DbType.Int32, value:somethingId, direction: ParameterDirection.Input);

    var result = repository.Exec<Something>(SomethingEnum.spMyStoredProcedure, param);

    ...

}

Source: dapper-tutorial.net

Similar codes

1 vote311 views2 answers
Dynamic arrays in c#
C#
0 vote356 views7 answers
C# USING SHARED CLASS
C#
2 votes324 views1 answer
C# to binary
C#
0 vote343 views1 answer
Linq c#
C#
0 vote316 views1 answer
C# xor byte array
C#
26 votes371 views4 answers
Unity print
C#Unity
0 vote340 views1 answer
C# read file while writing
C#
-1 vote319 views1 answer
C# array inst working
C#
0 vote373 views1 answer
Unity conditional field
C#Unity
0 vote317 views1 answer
Find the values of dictionaries in C sharp
C#