C# Notes

Create an Enum with Strings

public enum EnvironmentCode
{
    [EnumMember(Value = "String1")]
    String1,

    [EnumMember(Value = "String2")]
    String2,

    [EnumMember(Value = "String3")]
    String3,

    [EnumMember(Value = "String4")]
    String4
}

Dapper

Dynamic Variables

var p = new DynamicParameters();\
p.Add("@a", 11);\
p.Add("@b", dbType: DbType.Int32, direction: ParameterDirection.Output);\
p.Add("@c", dbType: DbType.Int32, direction: ParameterDirection.ReturnValue);\

cnn.Execute("spMagicProc", p, commandType: CommandType.StoredProcedure);\

int b = p.Get<int>("@b");\
int c = p.Get<int>("@c");