public virtual IDbCommand GetCommand()
{
var conn = new ConnectionFactory().Get(GetConnectionString());
var cmd = conn.CreateCommand();
cmd.CommandText = GetQuery();
return cmd;
}
public void Get_ConnectionStringSqlClientNativeProvider_OleDbConnection()
{
//Call the method to test
var connStr = "Provider=SQLNCLI10.1;Data Source=ds;Initial Catalog=ic;Integrated Security=SSPI;";
var actual = new ConnectionFactory().Get(connStr);
//Assertion
Assert.That(actual, Is.InstanceOf<OleDbConnection>());
Assert.That(actual.ConnectionString, Is.EqualTo(connStr));
}
public void Get_ConnectionStringMsOlapProvider_AdomdConnection()
{
//Call the method to test
var connStr = "Provider=MSOLAP;Data Source=ds;Initial Catalog=ic";
var actual = new ConnectionFactory().Get(connStr);
//Assertion
Assert.That(actual, Is.InstanceOf<AdomdConnection>());
Assert.That(actual.ConnectionString, Is.EqualTo(connStr));
}
public void Get_Odbc_OdbcConnection()
{
//Call the method to test
var connStr = "Driver={SQL Server Native Client 10.0};Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;";
var actual = new ConnectionFactory().Get(connStr);
//Assertion
Assert.That(actual, Is.InstanceOf<OdbcConnection>());
Assert.That(actual.ConnectionString, Is.EqualTo(connStr));
}
public void Get_OleDb_OledbConnection()
{
//Call the method to test
var connStr = "Provider=OledB;Data Source=ds;Initial Catalog=ic";
var actual = new ConnectionFactory().Get(connStr);
//Assertion
Assert.That(actual, Is.InstanceOf<OleDbConnection>());
Assert.That(actual.ConnectionString, Is.EqualTo(connStr));
}
public void Get_Adomd_SqlConnection()
{
var connStr = "Data Source=ds;Initial Catalog=ic";
//Call the method to test
var actual = new ConnectionFactory().Get("Adomd", connStr);
//Assertion
Assert.That(actual, Is.InstanceOf<AdomdConnection>());
Assert.That(actual.ConnectionString, Is.EqualTo(connStr));
}
public virtual IDbCommand GetCommand()
{
if (Query==null)
return null;
var conn = new ConnectionFactory().Get(Query.GetConnectionString());
var cmd = conn.CreateCommand();
cmd.CommandText = Query.GetQuery();
return cmd;
}
public void Get_OleDbExcel_OleDbConnection()
{
//Call the method to test
var connStr = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\\myFolder\\myExcel2007file.xlsx;Extended Properties=\"Excel 12.0 Xml;HDR=YES\";";
var providers = new Dictionary<string, string>();
providers.Add("Microsoft.ACE.OLEDB.12.0", "System.Data.OleDb");
var factory = new ConnectionFactory(providers);
var actual = factory.Get(connStr);
//Assertion
Assert.That(actual, Is.InstanceOf<OleDbConnection>());
Assert.That(actual.ConnectionString, Is.EqualTo(connStr));
}
public void Get_SqlNCli11Dot1_OleDbConnection()
{
//Call the method to test
var connStr = "Provider=SQLNCLI11.1;Data Source=.;Initial Catalog=AdventureWorks2014;Integrated Security=SSPI";
var actual = new ConnectionFactory().Get(connStr);
//Assertion
Assert.That(actual, Is.InstanceOf<OleDbConnection>());
Assert.That(actual.ConnectionString, Is.EqualTo(connStr));
}