本文整理汇总了C#中Microsoft.Practices.EnterpriseLibrary.Data.Sql.SqlDatabase.CreateConnection方法的典型用法代码示例。如果您正苦于以下问题：C# SqlDatabase.CreateConnection方法的具体用法？C# SqlDatabase.CreateConnection怎么用？C# SqlDatabase.CreateConnection使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类Microsoft.Practices.EnterpriseLibrary.Data.Sql.SqlDatabase的用法示例。
在下文中一共展示了SqlDatabase.CreateConnection方法的2个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: UpdateAveragesAndScores
public string UpdateAveragesAndScores( SqlDatabase db, DateTime when )
{
string result = "Successfully updated scores and averages";
DbConnection conn = db.CreateConnection();
conn.Open();
DbTransaction trans = conn.BeginTransaction();
try
{
db.ExecuteNonQuery( "spSetCurrentScore", when );
db.ExecuteNonQuery( "spRecalcPlayerAverages" );
trans.Commit();
}
catch( Exception e )
{
result = "Failed to update scores and averages: " + e.Message;
trans.Rollback();
}
conn.Close();
return result;
}示例2: SavePerformances
public ArrayList SavePerformances( SqlDatabase db, ArrayList perfs, DateTime when )
{
ArrayList problems = new ArrayList();
DbConnection conn = db.CreateConnection();
conn.Open();
DbTransaction trans = conn.BeginTransaction();
try
{
foreach( PlayerPerformance p in perfs )
{
DbCommand cmd = db.GetStoredProcCommand( "spAddPlayerPerformance",
when, p.FirstName, p.LastName, p.TeamName, p.Minutes, p.Assists, p.Blocks,
p.DefensiveRebounds, p.Fouls, p.FTAttempts, p.FTsMade, p.OffensiveRebounds,
p.PlusMinus, p.ShotAttempts, p.ShotsMade, p.Steals, p.ThreeAttempts,
p.ThreesMade, p.Turnovers, p.NBAId );
int x = (int)db.ExecuteScalar( cmd, trans );
if( x != 0 )
{
problems.Add( p );
}
}
trans.Commit();
}
catch( Exception e )
{
trans.Rollback();
PlayerPerformance p = new PlayerPerformance();
p.FirstName = "Exception thrown while saving results to db: " + e.Message;
problems.Add( p );
}
conn.Close();
return problems;
}