/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 vote271 views1 answer
How to parent something unity
C#
0 vote279 views1 answer
C# access substring
C#
0 vote288 views2 answers
C sharp type in word and calculate how much a letter is inside that word
C#
0 vote268 views1 answer
C# xml check if attribute exists
C#
2 votes268 views2 answers
C# open a new form and close current
C#
4 votes259 views1 answer
ALWAYS MAximize window on start c#
C#
0 vote308 views1 answer
Dictionary string list int c#
C#
0 vote293 views1 answer
C# read file while writing
C#
12 votes313 views6 answers
C# store byte array as string
C#
7 votes283 views2 answers
How to convert int to float in c#
C#