本文整理汇总了C#中DbConnection.CommitTransaction方法的典型用法代码示例。如果您正苦于以下问题：C# DbConnection.CommitTransaction方法的具体用法？C# DbConnection.CommitTransaction怎么用？C# DbConnection.CommitTransaction使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类DbConnection的用法示例。
在下文中一共展示了DbConnection.CommitTransaction方法的6个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: SelectFetchEntities
protected override void SelectFetchEntities(int entityCount)
{
using (var db = new DbConnection())
{
db.BeginTransaction();
var results = db.Entities.Where(x => x.Id <= entityCount).ToList();
db.CommitTransaction();
}
}示例2: PagedEntities
protected override void PagedEntities(int entityCount)
{
using (var db = new DbConnection())
{
db.BeginTransaction();
var results = db.Entities.Skip(0).Take(entityCount).ToList();
db.CommitTransaction();
}
}示例3: DeleteEntities
protected override void DeleteEntities(List<Entity> entities)
{
using (var db = new DbConnection())
{
db.BeginTransaction();
entities.ForEach(entity => db.Delete(entity));
db.CommitTransaction();
}
}示例4: ResetDatabase
protected override void ResetDatabase()
{
using (var db = new DbConnection())
{
db.BeginTransaction();
db.Execute("DELETE FROM Entity");
db.Execute("DELETE FROM sqlite_sequence WHERE name = 'Entity'");
db.CommitTransaction();
}
}示例5: InsertEntities
protected override void InsertEntities(List<Entity> entities)
{
using (var db = new DbConnection())
{
db.BeginTransaction();
// Insert doesn't seem to update the Id on the entity, this "work around" is horible
// but at least gives us parity with the other benchmarks! If there's a better
// way... I can't find it :/
entities.ForEach(entity =>
{
var id = db.InsertWithIdentity(entity);
entity.Id = Convert.ToInt32(id);
});
db.CommitTransaction();
}
}示例6: SelectSingleEntity
protected override void SelectSingleEntity(int entityCount)
{
using (var db = new DbConnection())
{
db.BeginTransaction();
do
{
var entity = db.Entities.Single(x => x.Id == entityCount);
entityCount--;
}
while (entityCount > 0);
db.CommitTransaction();
}
}