public Bets DapperGetBetById()
{
using (var conn = ConnectionFactory.GetConnection())
{
var bet = conn.QueryFirst <Bets>("select * from Bets where BetId = @betId", new { betId = 100 });
return(bet);
}
}
public void DapperUpdateOneHundredBets()
{
using (var conn = ConnectionFactory.GetConnection())
{
for (int i = 0; i < 100; i++)
{
conn.Update(new Bets {
BetId = i, MemberId = 1, StakeAmount = 49, DateCreated = DateTime.Now, DateUpdated = DateTime.Now
});
}
}
}
public void DapperAddOneHundredNewBets()
{
using (var conn = ConnectionFactory.GetConnection())
{
for (int i = 0; i < 100; i++)
{
conn.Insert(new Bets {
MemberId = 1, StakeAmount = 100, DateCreated = DateTime.Now, DateUpdated = DateTime.Now
});
}
}
}