/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

3 votes222 views1 answer
Check connection c#
C#
0 vote219 views1 answer
C# setting property values through reflection with attributes
C#
4 votes214 views3 answers
Sum of digits in c#
C#
3 votes240 views1 answer
What is the namespace for textmesh pro
C#
96 votes237 views6 answers
C# how to convert string to int
C#
0 vote234 views1 answer
How to remove vowels from a sttring using regex c#
C#
0 vote218 views2 answers
ResourceDictionary wpf
C#
130 votes336 views6 answers
Generate random number c#
C#
4 votes231 views1 answer
Covert char[] to string C#
C#
0 vote184 views1 answer
Unity insert variable into string
C#