public Database(string ConnString)
{
// split the param into ProviderName and actual ConnString
int PipeIndex = ConnString.IndexOf("|");
if (PipeIndex == -1)
{
// default to MsSql client
ProviderName = "System.Data.SqlClient";
this.ConnString = ConnString;
}
else
{
ProviderName = ConnString.Substring(0, PipeIndex);
this.ConnString = ConnString.Substring(PipeIndex + 1);
}
SqlClientFactory = GetFactory(ProviderName);
this.conn = SqlClientFactory.CreateConnection(this.ConnString);
this.conn.Open();
}
public ExecuteSqlQuery(ISqlClientFactory sqlClientFactory)
{
_sqlClientFactory = sqlClientFactory;
}
public CitiesRepository(ISqlClientFactory sqlClientFactory)
{
SqlClientFactory = sqlClientFactory ?? throw new ArgumentNullException(nameof(sqlClientFactory));
}
public ExecuteSqlCommand(ISqlClientFactory sqlClientFactory)
{
_sqlClientFactory = sqlClientFactory;
}