本文整理汇总了C#中IConnection.GetTransaction方法的典型用法代码示例。如果您正苦于以下问题：C# IConnection.GetTransaction方法的具体用法？C# IConnection.GetTransaction怎么用？C# IConnection.GetTransaction使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类IConnection的用法示例。
在下文中一共展示了IConnection.GetTransaction方法的3个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: Save
public void Save(IConnection connection)
{
if (BotCardId == 0)
{
connection
.GetConnection()
.Execute(
"INSERT INTO BotCards ([BotId],[CardId],[OwnedAmount]) " +
"VALUES(@BotId, @CardId, @OwnedAmount) ",
this,
connection.GetTransaction());
}
else
{
connection
.GetConnection()
.Execute(
"UPDATE BotCards " +
"SET [BotId] = @BotId," +
"[CardId] = @CardId," +
"[OwnedAmount] = @OwnedAmount " +
"WHERE BotCardId = @BotCardId ",
this,
connection.GetTransaction());
}
}示例2: Save
public void Save(IConnection connection)
{
connection
.GetConnection()
.Execute(
"INSERT INTO [TradeDetail] ([TradeId],[CardId],[NumberOfCard],[Price],[Buying]) " +
"VALUES(@TradeId, @CardId, @NumberOfCard, @Price, @Buying) ",
this,
connection.GetTransaction());
}示例3: Save
public void Save(IConnection connection)
{
if (Id == 0)
{
connection
.GetConnection()
.Execute(
"INSERT INTO Cards ([CardName],[CardSet],[CardRarity],[Premium],[MtgoCardId],[CardSetNumber]) " +
"VALUES(@Name, @Set, @Rarity, @Premium, @MtgoId, @CardSetNumber) ",
this,
connection.GetTransaction());
connection
.GetConnection()
.Execute(
"INSERT INTO Prices ([BotGroupId],[CardId],[BuyPrice],[SellPrice],[OwnedAmount]) " +
"VALUES(@BotGroupId, @Id, @BuyPrice, @SellPrice, @OwnedAmount) ",
this,
connection.GetTransaction());
}
else
{
connection
.GetConnection()
.Execute(
"UPDATE Cards " +
"SET CardName = @Name, " +
"CardSet = @Set, " +
"CardRarity = @Rarity, " +
"Premium = @Premium, " +
"MtgoCardId = @MtgoId " +
"WHERE CardId = @Id ",
this,
connection.GetTransaction());
connection
.GetConnection()
.Execute(
"UPDATE Prices " +
"SET BuyPrice = @BuyPrice, " +
"SellPrice = @SellPrice, " +
"OwnedAmount = @OwnedAmount " +
"WHERE BotGroupId = @BotGroupId " +
"AND CardId = @Id",
this,
connection.GetTransaction());
}
}