/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 vote377 views1 answer
Spawning object around in a circle of an gameobject unity'
C#
0 vote377 views1 answer
How to round to nearest number in array c#
C#
0 vote423 views1 answer
Garbage collect every 30 frames unity
C#Unity
0 vote387 views1 answer
How to change text in richtextbox wpf
C#
0 vote379 views2 answers
Mongodb c# batch find
C#
0 vote348 views2 answers
Cqrs design pattern .net core
C#
0 vote381 views1 answer
C# do while or
C#
0 vote386 views1 answer
How to make game object transparent in unity
C#Unity
2 votes442 views1 answer
How to check the tag of a collider in unity
C#Unity
0 vote350 views1 answer
Parsing object from text file c#
C#