public void DbProviderFactoryAdapterCreateConnection()
{
DbProviderFactory dbProviderFactory = A.Fake <DbProviderFactory>(c => c.Strict());
DbConnection iDbConnection = A.Fake <DbConnection>();
DbProviderFactoryAdapter dbProviderFactoryAdapter = new DbProviderFactoryAdapter(dbProviderFactory);
var fakeDbProviderFactoryAdapter = A.CallTo(() => dbProviderFactory.CreateConnection());
fakeDbProviderFactoryAdapter.Returns(iDbConnection);
dbProviderFactoryAdapter.CreateConnection();
fakeDbProviderFactoryAdapter.MustHaveHappened(Repeated.Exactly.Once);
}
public void VerifyCommandSyntex(DbProviderFactoryAdapter provider, string commandText)
{
var command = provider.CreateCommand();
_output.WriteLine("testing:\r\n" + commandText);
command.CommandText = "EXPLAIN " + commandText;
using (DbConnection conn = provider.CreateConnection())
{
conn.ConnectionString = "Data Source =:memory:; Version = 3; New = True;";
conn.Open();
command.Connection = conn;
try
{
command.ExecuteNonQuery();
}
catch (DbException ex)
{
Assert.DoesNotContain("syntax ", ex.Message, StringComparison.InvariantCultureIgnoreCase);
}
}
}
