/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 vote185 views1 answer
C# list to string one line
C#
1 vote179 views1 answer
C# named parameters
C#
5 votes200 views1 answer
Unity get gameobject script is attached to
C#Unity
0 vote150 views1 answer
Unity add to dictionary
C#Unity
5 votes179 views3 answers
Find the max number in an array c#
C#
0 vote162 views1 answer
C# Check if variables are equal
C#
1 vote176 views1 answer
Unity list of gameobjects
C#
0 vote175 views1 answer
Wpf bind to self
C#
0 vote198 views1 answer
C# list audio devices
C#
0 vote188 views1 answer
Unity slider not empty
C#Unity