public void ConnectionString3()
{
AccessPoker sql = new AccessPoker();
sql.DataFile = "hi there";
Assert.AreEqual("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=", sql.ConnectionString, "A1");
}
public void Defaults()
{
AccessPoker sql = new AccessPoker();
Assert.AreEqual("", sql.CacheKeyDependency, "A1");
Assert.IsTrue(sql.CancelSelectOnNullParameter, "A2");
Assert.AreEqual(ConflictOptions.OverwriteChanges, sql.ConflictDetection, "A3");
Assert.AreEqual(SqlDataSourceCommandType.Text, sql.DeleteCommandType, "A4");
Assert.AreEqual(SqlDataSourceCommandType.Text, sql.InsertCommandType, "A5");
Assert.AreEqual(SqlDataSourceCommandType.Text, sql.SelectCommandType, "A6");
Assert.AreEqual(SqlDataSourceCommandType.Text, sql.UpdateCommandType, "A7");
Assert.AreEqual("{0}", sql.OldValuesParameterFormatString, "A8");
// SqlCacheDependency access should raise an exception
// Assert.AreEqual ("", sql.SqlCacheDependency, "A9");
Assert.AreEqual("", sql.SortParameterName, "A10");
Assert.AreEqual(0, sql.CacheDuration, "A11");
Assert.AreEqual(DataSourceCacheExpiry.Absolute, sql.CacheExpirationPolicy, "A12");
Assert.IsFalse(sql.EnableCaching, "A13");
Assert.AreEqual("System.Data.OleDb", sql.ProviderName, "A14");
Assert.AreEqual("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=", sql.ConnectionString, "A15");
Assert.AreEqual(SqlDataSourceMode.DataSet, sql.DataSourceMode, "A16");
Assert.AreEqual("", sql.DeleteCommand, "A17");
Assert.IsNotNull(sql.DeleteParameters, "A18");
Assert.AreEqual(0, sql.DeleteParameters.Count, "A18.1");
Assert.IsNotNull(sql.FilterParameters, "A19");
Assert.AreEqual(0, sql.FilterParameters.Count, "A19.1");
Assert.AreEqual("", sql.InsertCommand, "A20");
Assert.IsNotNull(sql.InsertParameters, "A21");
Assert.AreEqual(0, sql.InsertParameters.Count, "A21.1");
Assert.AreEqual("", sql.SelectCommand, "A22");
Assert.IsNotNull(sql.SelectParameters, "A23");
Assert.AreEqual(0, sql.SelectParameters.Count, "A23.1");
Assert.AreEqual("", sql.UpdateCommand, "A24");
Assert.IsNotNull(sql.UpdateParameters, "A25");
Assert.AreEqual(0, sql.UpdateParameters.Count, "A25.1");
Assert.AreEqual("", sql.FilterExpression, "A26");
Assert.AreEqual("", sql.DataFile, "A27");
}
public void ConnectionString1 ()
{
AccessPoker sql = new AccessPoker ();
sql.ConnectionString = "hi";
}
public void SqlCacheDependency2 ()
{
AccessPoker sql = new AccessPoker ();
sql.SqlCacheDependency = "hi";
}
public void SqlCacheDependency1 ()
{
AccessPoker sql = new AccessPoker ();
Assert.AreEqual ("", sql.SqlCacheDependency, "A1");
}
public void ProviderName ()
{
AccessPoker sql = new AccessPoker ();
sql.ProviderName = "foo";
}
public void Defaults ()
{
AccessPoker sql = new AccessPoker ();
Assert.AreEqual ("", sql.CacheKeyDependency, "A1");
Assert.IsTrue (sql.CancelSelectOnNullParameter, "A2");
Assert.AreEqual (ConflictOptions.OverwriteChanges, sql.ConflictDetection, "A3");
Assert.AreEqual(SqlDataSourceCommandType.Text, sql.DeleteCommandType, "A4");
Assert.AreEqual(SqlDataSourceCommandType.Text, sql.InsertCommandType, "A5");
Assert.AreEqual(SqlDataSourceCommandType.Text, sql.SelectCommandType, "A6");
Assert.AreEqual(SqlDataSourceCommandType.Text, sql.UpdateCommandType, "A7");
Assert.AreEqual ("{0}", sql.OldValuesParameterFormatString, "A8");
// SqlCacheDependency access should raise an exception
// Assert.AreEqual ("", sql.SqlCacheDependency, "A9");
Assert.AreEqual ("", sql.SortParameterName, "A10");
Assert.AreEqual (0, sql.CacheDuration, "A11");
Assert.AreEqual (DataSourceCacheExpiry.Absolute, sql.CacheExpirationPolicy, "A12");
Assert.IsFalse (sql.EnableCaching, "A13");
Assert.AreEqual ("System.Data.OleDb", sql.ProviderName, "A14");
Assert.AreEqual ("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=", sql.ConnectionString, "A15");
Assert.AreEqual (SqlDataSourceMode.DataSet, sql.DataSourceMode, "A16");
Assert.AreEqual ("", sql.DeleteCommand, "A17");
Assert.IsNotNull (sql.DeleteParameters, "A18");
Assert.AreEqual (0, sql.DeleteParameters.Count, "A18.1");
Assert.IsNotNull (sql.FilterParameters, "A19");
Assert.AreEqual (0, sql.FilterParameters.Count, "A19.1");
Assert.AreEqual ("", sql.InsertCommand, "A20");
Assert.IsNotNull (sql.InsertParameters, "A21");
Assert.AreEqual (0, sql.InsertParameters.Count, "A21.1");
Assert.AreEqual ("", sql.SelectCommand, "A22");
Assert.IsNotNull (sql.SelectParameters, "A23");
Assert.AreEqual (0, sql.SelectParameters.Count, "A23.1");
Assert.AreEqual ("", sql.UpdateCommand, "A24");
Assert.IsNotNull (sql.UpdateParameters, "A25");
Assert.AreEqual (0, sql.UpdateParameters.Count, "A25.1");
Assert.AreEqual ("", sql.FilterExpression, "A26");
Assert.AreEqual ("", sql.DataFile, "A27");
}
public void ProviderFactory ()
{
AccessPoker sql = new AccessPoker ();
Assert.AreEqual (typeof (OleDbFactory), sql.GetFactory ().GetType());
}
public void ConnectionString3 ()
{
AccessPoker sql = new AccessPoker ();
sql.DataFile = "hi there";
Assert.AreEqual ("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=", sql.ConnectionString, "A1");
}
public void SqlCacheDependency2()
{
AccessPoker sql = new AccessPoker();
sql.SqlCacheDependency = "hi";
}
public void SqlCacheDependency1()
{
AccessPoker sql = new AccessPoker();
Assert.AreEqual("", sql.SqlCacheDependency, "A1");
}
public void ProviderName()
{
AccessPoker sql = new AccessPoker();
sql.ProviderName = "foo";
}
public void ProviderFactory()
{
AccessPoker sql = new AccessPoker();
Assert.AreEqual(typeof(OleDbFactory), sql.GetFactory().GetType());
}
public void ConnectionString1()
{
AccessPoker sql = new AccessPoker();
sql.ConnectionString = "hi";
}