public static void AddComments(IDbUtils db, string filePath)
{
var tableName = Path.GetFileNameWithoutExtension(filePath);
var cols = db.GetColumns(tableName).ToArray();
AddComments(filePath, cols);
}
internal TransactionDbManager(IDbUtils dbUtils, IDbTransaction transaction)
: base(dbUtils, string.Empty)
{
DbTransaction = transaction ?? throw new ArgumentNullException(nameof(transaction));
DbConnection = transaction.Connection;
IsMyTransaction = false;
}
public void Init()
{
_dbUtilsStub = Substitute.For <IDbUtils>();
_connectionStub = Substitute.For <IDbConnection>();
_transactionStub = Substitute.For <IDbTransaction>();
_dbUtilsStub.CreateConnection(_connectionString).Returns(_connectionStub);
_connectionStub.BeginTransaction().Returns(_transactionStub);
}
// depenedency-injected
protected BaseDatabaseAccess(IDbUtils dbUtils)
{
if (dbUtils == null)
{
_dbUtils = new DbUtils();
}
else
{
_dbUtils = dbUtils;
}
}
protected BaseDatabaseAccessGeneric(string tableName,
IEnumerable <string> updateFieldExclusions = null,
IDbUtils dbUtils = null) : base(dbUtils)
{
_tableName = tableName;
_updateFieldExclusions = new List <string>();
_updateFieldExclusions.Add("PKey");
_updateFieldExclusions.Add("CreationDate");
if (updateFieldExclusions != null)
{
_updateFieldExclusions.AddRange(updateFieldExclusions);
}
_insertFieldExclusions = new List <string>();
_insertFieldExclusions.Add("PKey");
if (updateFieldExclusions != null)
{
_insertFieldExclusions.AddRange(updateFieldExclusions);
}
}
public TransactionDbManager(IDbUtils dbUtils, string connectionString, IsolationLevel isolationLevel)
: base(dbUtils, connectionString)
{
IsolationLevel = isolationLevel;
}
public TransactionDbManager(IDbUtils dbUtils, string connectionString)
: this(dbUtils, connectionString, IsolationLevel.ReadCommitted)
{
}
public NoTransactionDbManager(IDbUtils dbUtils, string connectionString) : base(dbUtils, connectionString)
{
}
// for compatibility with old code
protected BaseDatabaseAccess()
{
_dbUtils = new DbUtils();
}
public void Init()
{
_dbUtilsStub = Substitute.For <IDbUtils>();
_connectionStub = Substitute.For <IDbConnection>();
_transactionStub = Substitute.For <IDbTransaction>();
}
protected DbManager(IDbUtils dbUtils, string connectionString)
{
DbUtils = dbUtils ?? throw new ArgumentNullException(nameof(dbUtils));
ConnectionString = connectionString ?? throw new ArgumentNullException(nameof(connectionString));
}
public TestDbServiceManager(IDbUtils dbUtils, string connectionString)
: base(dbUtils, connectionString)
{
}
private TestDbServiceManager CreateTestDbServiceManager(IDbUtils dbUtils, string connectionString) => new TestDbServiceManager(dbUtils, connectionString);
public void Init()
{
_dbUtilsStub = Substitute.For <IDbUtils>();
}
public DbManagerFactory(IDbUtils dbUtilsUtils, IDbConnectionStringProvider connectionStringProvider)
{
_connectionStringProvider = connectionStringProvider ?? throw new ArgumentNullException(nameof(connectionStringProvider));
_dbUtils = dbUtilsUtils ?? throw new ArgumentNullException(nameof(dbUtilsUtils));
}
