public void SetIsolationLevel(IsolationLevel isolationLevel)
{
ZDBMS dbms = AdoNetHelper.GetDBMS(Session.Connection.ConnectionString);
string sql = AdoNetHelper.SqlIsolationLevel(dbms, isolationLevel);
if (!String.IsNullOrEmpty(sql))
{
SQLCommand(sql);
}
}
/// <summary>
/// Execute Reader.
/// </summary>
/// <param name="dbCommand">Command</param>
/// <param name="isolationLevel">Isolation level</param>
/// <returns>Data Reader</returns>
public static DbDataReader ExecuteReader(this DbCommand dbCommand,
IsolationLevel isolationLevel)
{
if (ConfigurationHelper.AppSettings <bool>("EasyLOB.AdoNet.IsolationLevel"))
{
ZDBMS dbms = AdoNetHelper.GetDBMS(dbCommand.Connection);
string sql = AdoNetHelper.SqlIsolationLevel(dbms, isolationLevel);
dbCommand.CommandText = (String.IsNullOrEmpty(sql) ? "" : sql + Environment.NewLine)
+ dbCommand.CommandText;
}
return(dbCommand.ExecuteReader());
}