本文整理汇总了C#中DataConnection.RollbackTransaction方法的典型用法代码示例。如果您正苦于以下问题：C# DataConnection.RollbackTransaction方法的具体用法？C# DataConnection.RollbackTransaction怎么用？C# DataConnection.RollbackTransaction使用的例子？那么, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类DataConnection的用法示例。
在下文中一共展示了DataConnection.RollbackTransaction方法的2个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: GetProcedureSchema
protected override DataTable GetProcedureSchema(DataConnection dataConnection, string commandText, CommandType commandType, DataParameter[] parameters)
{
if (commandType == CommandType.StoredProcedure)
{
commandText = "{ CALL " + commandText + "(" + String.Join(",", parameters.Select(x => "?")) + ")}";
}
//bug SchemaOnly simply doesn't work
dataConnection.BeginTransaction();
try
{
using (var rd = dataConnection.ExecuteReader(commandText, CommandType.Text, CommandBehavior.Default, parameters))
{
return rd.Reader.GetSchemaTable();
}
}
finally
{
dataConnection.RollbackTransaction();
}
}示例2: GetProcedureSchema
protected override DataTable GetProcedureSchema(DataConnection dataConnection, string commandText, CommandType commandType, DataParameter[] parameters)
{
//bug in drivers, SchemaOnly executes statement
dataConnection.BeginTransaction();
try
{
using (var rd = dataConnection.ExecuteReader(commandText, commandType, CommandBehavior.SchemaOnly, parameters))
{
return rd.Reader.GetSchemaTable();
}
}
finally
{
dataConnection.RollbackTransaction();
}
}