/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

0 vote94 views1 answer
C# alphabetize a list of string
C#
0 vote101 views1 answer
Unity editor window mesh field
C#
6 votes137 views1 answer
How to make mouse invisible unity
C#Unity
0 vote99 views1 answer
C# string is all zeros
C#
0 vote104 views1 answer
C# ipaddress to integer
C#
1 vote94 views2 answers
C# 2d list
C#
0 vote94 views1 answer
C# lambda join two tables
C#
29 votes108 views3 answers
C# get bytes from string
C#
0 vote139 views1 answer
Unity conditional field
C#Unity
2 votes179 views1 answer
Change array size in unity
C#Unity