本文整理汇总了C#中IConnectionProvider.OpenConnection方法的典型用法代码示例。如果您正苦于以下问题：C# IConnectionProvider.OpenConnection方法的具体用法？C# IConnectionProvider.OpenConnection怎么用？C# IConnectionProvider.OpenConnection使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类IConnectionProvider的用法示例。
在下文中一共展示了IConnectionProvider.OpenConnection方法的14个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: EnsureOpenConnection
private static bool EnsureOpenConnection(IConnectionProvider conn)
{
bool connIsOpennedLocally = !conn.IsOpen;
if (connIsOpennedLocally)
conn.OpenConnection();
return connIsOpennedLocally;
}示例2: BulkSave
public void BulkSave(IConnectionProvider conn, IEntityCollection entitiesToSave, IEntityDaoFactory daoFactory)
{
IEntityCollection newEntities, changedEntities, removedEntities;
SplitCollectionForInsertUpdateAndDeleteOperations(entitiesToSave, out newEntities, out changedEntities, out removedEntities);
bool connIsLocal = !conn.IsOpen;
if (connIsLocal)
conn.OpenConnection();
try
{
BulkInsert(conn, newEntities, daoFactory);
BulkUpdate(conn, changedEntities, daoFactory);
BulkDelete(conn, removedEntities, daoFactory);
}
finally
{
if (connIsLocal)
conn.CloseConnection();
}
}示例3: MaxOfAll
private static object MaxOfAll(IConnectionProvider conn, IEntity rootEntity, IDbColumn column, DbRelation recursiveRelation, int beginAtLevel, int endAtLevel)
{
// Stop condition: count returns zero.
object maximum = null;
bool isLocalConn = !conn.IsOpen;
try
{
if (isLocalConn)
conn.OpenConnection();
bool reachedEndLevel = false;
int level = beginAtLevel;
do
{
object levelMax;
int nodeCount;
FetchMaxFromColumnAndCountAllNodesAtLevel(conn, rootEntity, recursiveRelation, level, column.ColumnName, out levelMax, out nodeCount);
maximum = MaxOfNullableValues(maximum as IComparable, levelMax as IComparable);
reachedEndLevel = (nodeCount == 0) || (level >= endAtLevel);
level++;
} while (!reachedEndLevel);
}
finally
{
if (isLocalConn)
conn.CloseConnection();
}
if (maximum == null)
maximum = DBNull.Value;
return maximum;
}示例4: MaxWithLeafFilter
private static object MaxWithLeafFilter(IConnectionProvider conn, IEntity rootEntity, IDbColumn column, DbRelation recursiveRelation, SearchCondition leafFilter, int beginAtLevel, int endAtLevel)
{
// Stop condition: final level reached (tree depth is measured).
object maximum = null;
bool isLocalConn = !conn.IsOpen;
try
{
if (isLocalConn)
conn.OpenConnection();
endAtLevel = GetEndLevel(conn, rootEntity, recursiveRelation, endAtLevel);
bool reachedEndLevel = false;
int level = beginAtLevel;
do
{
SelectStatement maxAtLevel = CreateSelectFromLevelQuery(rootEntity, recursiveRelation, leafFilter, level, LevelQuerySelectList.Default);
maxAtLevel.SelectList.Clear();
IDbColumn comparedColumn = maxAtLevel.FromTable.Columns.GetByColumnName(column.ColumnName);
maxAtLevel.SelectList.Add(AggregateFunctionFactory.Max(comparedColumn, "levelMax"));
DataTable results = maxAtLevel.Execute(conn);
object levelMax = results.Rows[0]["levelMax"];
maximum = MaxOfNullableValues(maximum as IComparable, levelMax as IComparable);
reachedEndLevel = (level >= endAtLevel);
level++;
} while (!reachedEndLevel);
}
finally
{
if (isLocalConn)
conn.CloseConnection();
}
if (maximum == null)
maximum = DBNull.Value;
return maximum;
}示例5: SumAll
private static object SumAll(IConnectionProvider conn, IEntity rootEntity, IDbColumn column, DbRelation recursiveRelation, int beginAtLevel, int endAtLevel)
{
// Stop condition: count returns zero.
object totalSum = null;
bool isLocalConn = !conn.IsOpen;
try
{
if (isLocalConn)
conn.OpenConnection();
bool reachedEndLevel = false;
int level = beginAtLevel;
do
{
SelectStatement sumAtLevel = CreateSelectFromLevelQuery(rootEntity, recursiveRelation, null, level, LevelQuerySelectList.Default);
sumAtLevel.SelectList.Clear();
IDbColumn summedColumn = sumAtLevel.FromTable.Columns.GetByColumnName(column.ColumnName);
sumAtLevel.SelectList.Add(AggregateFunctionFactory.Sum(summedColumn, false, "levelSum"));
sumAtLevel.SelectList.Add(AggregateFunctionFactory.Count("nodeCount"));
DataTable results = sumAtLevel.Execute(conn);
object levelSum = results.Rows[0]["levelSum"];
int nodeCount = Convert.ToInt32(results.Rows[0]["nodeCount"], CultureInfo.InvariantCulture);
totalSum = SumNullableValues(column, totalSum, levelSum);
reachedEndLevel = (nodeCount == 0) || (level >= endAtLevel);
level++;
} while (!reachedEndLevel);
}
finally
{
if (isLocalConn)
conn.CloseConnection();
}
return totalSum;
}示例6: SumWithLeafFilter
private static object SumWithLeafFilter(IConnectionProvider conn, IEntity rootEntity, IDbColumn column, DbRelation recursiveRelation, SearchCondition leafFilter, int beginAtLevel, int endAtLevel)
{
// Stop condition: final level reached (tree depth is measured).
object totalSum = null;
bool isLocalConn = !conn.IsOpen;
try
{
if (isLocalConn)
conn.OpenConnection();
endAtLevel = GetEndLevel(conn, rootEntity, recursiveRelation, endAtLevel);
bool reachedEndLevel = false;
int level = beginAtLevel;
do
{
SelectStatement sumAtLevel = CreateSelectFromLevelQuery(rootEntity, recursiveRelation, leafFilter, level, LevelQuerySelectList.Default);
sumAtLevel.SelectList.Clear();
IDbColumn summedColumn = sumAtLevel.FromTable.Columns.GetByColumnName(column.ColumnName);
sumAtLevel.SelectList.Add(AggregateFunctionFactory.Sum(summedColumn, false, "levelSum"));
DataTable results = sumAtLevel.Execute(conn);
object levelSum = results.Rows[0]["levelSum"];
totalSum = SumNullableValues(column, totalSum, levelSum);
reachedEndLevel = (level >= endAtLevel);
level++;
} while (!reachedEndLevel);
}
finally
{
if (isLocalConn)
conn.CloseConnection();
}
return totalSum;
}示例7: CountAll
private static int CountAll(IConnectionProvider conn, IEntity rootEntity, DbRelation recursiveRelation, int beginAtLevel, int endAtLevel)
{
// Stop condition: count returns zero.
int totalCount = 0;
bool isLocalConn = !conn.IsOpen;
try
{
if (isLocalConn)
conn.OpenConnection();
bool reachedEndLevel = false;
int level = beginAtLevel;
do
{
SelectStatement countAtLevel = CreateSelectFromLevelQuery(rootEntity, recursiveRelation, null, level, LevelQuerySelectList.Count);
DataTable results = countAtLevel.Execute(conn);
int nodeCount = Convert.ToInt32(results.Rows[0][0], CultureInfo.InvariantCulture);
totalCount += nodeCount;
reachedEndLevel = (nodeCount == 0) || (level >= endAtLevel);
level++;
} while (!reachedEndLevel);
}
finally
{
if (isLocalConn)
conn.CloseConnection();
}
return totalCount;
}示例8: CountWithLeafFilter
private static int CountWithLeafFilter(IConnectionProvider conn, IEntity rootEntity, DbRelation recursiveRelation, SearchCondition leafFilter, int beginAtLevel, int endAtLevel)
{
// Stop condition: final level reached (tree depth is measured).
int totalCount = 0;
bool isLocalConn = !conn.IsOpen;
try
{
if (isLocalConn)
conn.OpenConnection();
endAtLevel = GetEndLevel(conn, rootEntity, recursiveRelation, endAtLevel);
bool reachedEndLevel = false;
int level = beginAtLevel;
do
{
SelectStatement countAtLevel = CreateSelectFromLevelQuery(rootEntity, recursiveRelation, leafFilter, level, LevelQuerySelectList.Count);
DataTable results = countAtLevel.Execute(conn);
totalCount += Convert.ToInt32(results.Rows[0][0], CultureInfo.InvariantCulture);
reachedEndLevel = (level >= endAtLevel);
level++;
} while (!reachedEndLevel);
}
finally
{
if (isLocalConn)
conn.CloseConnection();
}
return totalCount;
}示例9: DetermineTreeDepthInternal
private static int DetermineTreeDepthInternal(IConnectionProvider conn, IEntity rootEntity, DbRelation recursiveRelation)
{
EnsureRecursiveRelation(recursiveRelation);
int depth = 0;
bool isLocalConn = !conn.IsOpen;
try
{
if (isLocalConn)
conn.OpenConnection();
bool reachedEndLevel = false;
do
{
SelectStatement countAtLevel = CreateSelectFromLevelQuery(rootEntity, recursiveRelation, null, depth, LevelQuerySelectList.Count);
DataTable results = countAtLevel.Execute(conn);
int nodeCount = Convert.ToInt32(results.Rows[0][0], CultureInfo.InvariantCulture);
if (nodeCount > 0)
depth++;
else
reachedEndLevel = true;
} while (!reachedEndLevel);
}
finally
{
if (isLocalConn)
conn.CloseConnection();
}
return depth;
}示例10: SelectAll
private static DataTable SelectAll(IConnectionProvider conn, IEntity rootEntity, DbRelation recursiveRelation, int beginAtLevel, int endAtLevel)
{
// Stop condition: select returns nothing.
DataTable mergedData = null;
bool isLocalConn = !conn.IsOpen;
try
{
if (isLocalConn)
conn.OpenConnection();
bool reachedEndLevel = false;
int level = beginAtLevel;
do
{
SelectStatement fetchLevel = CreateSelectFromLevelQuery(rootEntity, recursiveRelation, null, level, LevelQuerySelectList.AllColumns);
DataTable levelData = fetchLevel.Execute(conn);
if (levelData.Rows.Count > 0)
AppendData(levelData, ref mergedData);
reachedEndLevel = (levelData.Rows.Count == 0) || (level >= endAtLevel);
level++;
} while (!reachedEndLevel);
}
finally
{
if (isLocalConn)
conn.CloseConnection();
}
return mergedData;
}示例11: SelectWithLeafFilter
private static DataTable SelectWithLeafFilter(IConnectionProvider conn, IEntity rootEntity, DbRelation recursiveRelation, SearchCondition leafFilter, int beginAtLevel, int endAtLevel)
{
// Stop condition: final level reached (tree depth is measured).
// It's possible that at some intermediate levels no records satisfy the specified criteria.
// Nevertheless, the algorithm must proceed to the next level where it might find matching records.
// This behavior simulates the behavior of recursive CTEs.
DataTable mergedData = null;
bool isLocalConn = !conn.IsOpen;
try
{
if (isLocalConn)
conn.OpenConnection();
endAtLevel = GetEndLevel(conn, rootEntity, recursiveRelation, endAtLevel);
bool reachedEndLevel = false;
int level = beginAtLevel;
do
{
SelectStatement fetchLevel = CreateSelectFromLevelQuery(rootEntity, recursiveRelation, leafFilter, level, LevelQuerySelectList.AllColumns);
DataTable levelData = fetchLevel.Execute(conn);
if (levelData.Rows.Count > 0)
AppendData(levelData, ref mergedData);
reachedEndLevel = (level >= endAtLevel);
level++;
} while (!reachedEndLevel);
}
finally
{
if (isLocalConn)
conn.CloseConnection();
}
return mergedData;
}示例12: Prepare
public void Prepare()
{
connectionProvider = ConnectionProviderFactory.NewConnectionProvider(cfgProperties);
connection = (DbConnection) connectionProvider.GetConnection();
connectionProvider.OpenConnection(connection);
}示例13: InsertAndSelectAutoNumber
private static object InsertAndSelectAutoNumber(IConnectionProvider conn, string command, DbParameterCollection parameters, int cmdTimeout = 30)
{
bool isLocalConn = !conn.IsOpen;
if (isLocalConn)
conn.OpenConnection();
try
{
DbUtil.ExecuteNonQuery(conn, command, parameters, CommandType.Text, cmdTimeout);
// ROWID is always a 64bit integer.
DataTable data = DbUtil.ExecuteQuery(conn, "SELECT last_insert_rowid()", new DbParameterCollection(), CommandType.Text, null, cmdTimeout);
int lastId = Convert.ToInt32(data.Rows[0][0], CultureInfo.InvariantCulture);
return lastId;
}
finally
{
if (isLocalConn)
conn.CloseConnection();
}
}示例14: BulkDelete
public void BulkDelete(IConnectionProvider conn, IEntityCollection removedEntities, IEntityDaoFactory daoFactory)
{
if (removedEntities.Count == 0)
return;
bool connIsLocal = !conn.IsOpen;
if (connIsLocal)
conn.OpenConnection();
try
{
foreach (IEntity entity in removedEntities)
GetDao(conn, entity, daoFactory).DeleteOne();
}
finally
{
if (connIsLocal)
conn.CloseConnection();
}
}