public void CountByShouldSelectOne()
{
TraceHelper.TraceTestName();
var db = OpenDatabase();
Assert.AreEqual(1, db.Customers.GetCountByFName("Kim"));
}
public void ExistsWithInvalidCriteriaShouldReturnFalse()
{
TraceHelper.TraceTestName();
var db = OpenDatabase();
Assert.AreEqual(false, db.Customers.Exists(db.Customers.FName == "Bogus"));
}
public void TestMultiInsertWithDynamicTypeObjects()
{
TraceHelper.TraceTestName();
var db = OpenDatabase();
dynamic customer1 = new ExpandoObject();
customer1.FName = "Maurice";
customer1.LName = "Ravel";
customer1.Company = "Concerto (Left Hand)";
dynamic customer2 = new ExpandoObject();
customer2.FName = "Ludwig";
customer2.LName = "van Beethoven";
customer2.Company = "Symphony No 9";
var customers = new[] { customer1, customer2 };
IList <dynamic> actuals = db.Customers.Insert(customers).ToList();
Assert.AreEqual(2, actuals.Count);
Assert.AreNotEqual(0, actuals[0].CustomerNum);
Assert.AreEqual("Maurice", actuals[0].FName.Trim());
Assert.AreEqual("Ravel", actuals[0].LName.Trim());
Assert.AreEqual("Concerto (Left Hand)", actuals[0].Company.Trim());
Assert.AreNotEqual(0, actuals[1].CustomerNum);
Assert.AreEqual("Ludwig", actuals[1].FName.Trim());
Assert.AreEqual("van Beethoven", actuals[1].LName.Trim());
Assert.AreEqual("Symphony No 9", actuals[1].Company.Trim());
}
public void CountWithNoCriteriaShouldSelectTwentyEight()
{
TraceHelper.TraceTestName();
var db = OpenDatabase();
Assert.AreEqual(28, db.Customers.GetCount());
}
public void ExistsByInvalidValueShouldReturnFalse()
{
TraceHelper.TraceTestName();
var db = OpenDatabase();
Assert.AreEqual(false, db.Customers.ExistsByFName("Dracula"));
}
public void TestMultiInsertWithStaticTypeObjects()
{
TraceHelper.TraceTestName();
var db = OpenDatabase();
var customers = new[]
{
new Customer {
FName = "Bill", LName = "Gates", Company = "Microsoft"
},
new Customer {
FName = "Donald", LName = "Trump", Company = "Windy Property Inc"
}
};
IList <Customer> actuals = db.Customers.Insert(customers).ToList <Customer>();
Assert.AreEqual(2, actuals.Count);
Assert.AreNotEqual(0, actuals[0].CustomerNum);
Assert.AreEqual("Bill", actuals[0].FName.Trim());
Assert.AreEqual("Gates", actuals[0].LName.Trim());
Assert.AreEqual("Microsoft", actuals[0].Company.Trim());
Assert.AreNotEqual(0, actuals[1].CustomerNum);
Assert.AreEqual("Donald", actuals[1].FName.Trim());
Assert.AreEqual("Trump", actuals[1].LName.Trim());
Assert.AreEqual("Windy Property Inc", actuals[1].Company.Trim());
}
public void ExistsWithValidCriteriaShouldReturnTrue()
{
TraceHelper.TraceTestName();
var db = OpenDatabase();
Assert.AreEqual(true, db.Customers.Exists(db.Customers.FName == "Frank"));
}
public void TestProviderIsInformixConnectionProvider()
{
TraceHelper.TraceTestName();
var provider = new ProviderHelper().GetProviderByConnectionString(_connectionString);
Assert.IsInstanceOf(typeof(InformixConnectionProvider), provider);
}
public void UpdateByManuCode()
{
TraceHelper.TraceTestName();
var db = DatabaseHelper.Open();
db.ManuFacts.UpdateByManuCode(ManuCode: "HSK", LeadTime: "12");
}
public void InsertManuFact()
{
TraceHelper.TraceTestName();
var db = DatabaseHelper.Open();
db.ManuFacts.Insert(ManuCode: "J19", ManuName: "Jon 19", LeadTime: "19");
}
public void CountWithCriteriaShouldSelectTwo()
{
TraceHelper.TraceTestName();
var db = OpenDatabase();
Assert.AreEqual(2, db.Customers.GetCount(db.Customers.FName == "Frank"));
}
public void ExistsByValidValueShouldReturnTrue()
{
TraceHelper.TraceTestName();
var db = OpenDatabase();
Assert.AreEqual(true, db.Customers.ExistsByFName("Frank"));
}
public void TestDeleteAllOrders()
{
TraceHelper.TraceTestName();
var db = OpenDatabase();
db.Items.DeleteAll();
Assert.AreEqual(0, db.Items.GetCount());
}
public void ColumnAliasShouldChangeDynamicPropertyName()
{
TraceHelper.TraceTestName();
var db = OpenDatabase();
var actual = db.Customers.QueryByCustomerNum(101).Select(db.Customers.FName.As("MyFNameAlias")).First();
Assert.AreEqual("Ludwig", actual.MyFNameAlias.Trim());
}
public void TestAllCount()
{
TraceHelper.TraceTestName();
var db = OpenDatabase();
var count = db.Customers.All().ToList().Count;
Assert.AreEqual(28, count);
}
public void TestFindByCustomerNum()
{
TraceHelper.TraceTestName();
var db = OpenDatabase();
var customer = db.Customers.FindByCustomerNum(101);
Assert.AreEqual(101, customer.customer_num);
}
public void TestProviderIsInformixConnectionProviderFromOpen()
{
TraceHelper.TraceTestName();
Database db = OpenDatabase();
Assert.IsInstanceOf(typeof(AdoAdapter), db.GetAdapter());
Assert.IsInstanceOf(typeof(InformixConnectionProvider), ((AdoAdapter)db.GetAdapter()).ConnectionProvider);
}
public void TestFindByReturnsOne()
{
TraceHelper.TraceTestName();
var db = OpenDatabase();
var customer = (Customer)db.Customers.FindByFName("Bob");
Assert.AreEqual(119, customer.CustomerNum);
}
public void TestFindAllByPartialName()
{
TraceHelper.TraceTestName();
var db = OpenDatabase();
IEnumerable <Customer> customers = db.Customers.FindAll(db.Customers.FName.Like("Bob")).ToList <Customer>();
Assert.AreEqual(1, customers.Count());
}
public void TestFindAllByName()
{
TraceHelper.TraceTestName();
var db = OpenDatabase();
IEnumerable <Customer> customers = db.Customers.FindAllByFName("Bob").Cast <Customer>();
Assert.AreEqual(1, customers.Count());
}
public void ToScalarOrDefault()
{
TraceHelper.TraceTestName();
var db = OpenDatabase();
int max = db.Orders.FindAllByCustomerNum(99).Select(db.Orders.OrderNum.Max()).ToScalarOrDefault <int>();
Assert.AreEqual(0, max);
}
public void InsertManuFactWorkaround()
{
TraceHelper.TraceTestName();
var db = DatabaseHelper.Open();
db.ManuFacts.Insert(ManuCode: "J20", ManuName: "Jon 20");
db.ManuFacts.UpdateByManuCode(ManuCode: "J20", LeadTime: "20");
}
public void TestFindOnAView()
{
TraceHelper.TraceTestName();
var db = OpenDatabase();
var custView = db.CustView.FindByFirstName("Frank");
Assert.IsNotNull(custView);
Assert.AreEqual("Albertson", custView.LastName.Trim());
}
public void FindAllByIntervalDayColumn()
{
TraceHelper.TraceTestName();
var db = DatabaseHelper.Open();
var rows = db.ManuFacts.FindAllByLeadTime("21").ToList();
Assert.AreEqual(1, rows.Count);
Assert.AreEqual(typeof(TimeSpan), rows[0].LeadTime.GetType());
}
public void TestNaturalJoinIndexersForm()
{
TraceHelper.TraceTestName();
var db = OpenDatabase();
var row = db["Customers"].Find(db["Customers"]["Orders"]["OrderDate"] == new DateTime(1994, 6, 17));
Assert.IsNotNull(row);
Assert.AreEqual("Alfred", row.FName.Trim());
}
public void TestNaturalJoinDynamicForm()
{
TraceHelper.TraceTestName();
var db = OpenDatabase();
var row = db.Customers.Find(db.Customers.Orders.OrderDate == new DateTime(1994, 6, 17));
Assert.IsNotNull(row);
Assert.AreEqual("Alfred", row.FName.Trim());
}
public void ShouldDirectlyQueryDetailTable()
{
TraceHelper.TraceTestName();
var db = OpenDatabase();
var order = db.Customers.QueryByFNameAndCompany("Ludwig", "All Sports Supplies").Orders.FirstOrDefault();
Assert.IsNotNull(order);
Assert.AreEqual(1002, order.OrderNum);
}
public void WeirdTypeGetsConvertedToInt()
{
TraceHelper.TraceTestName();
var db = DatabaseHelper.Open();
var weirdValue = new WeirdType(101);
var customer = db.Customers.FindByCustomerNum(weirdValue);
Assert.AreEqual(101, customer.CustomerNum);
}
public void TestImplicitEnumerableCast()
{
TraceHelper.TraceTestName();
var db = OpenDatabase();
foreach (Customer customer in db.Customers.All())
{
Assert.IsNotNull(customer);
}
}
public void DeleteAllByIntervalDayColumn()
{
TraceHelper.TraceTestName();
var db = DatabaseHelper.Open();
db.ManuFacts.Insert(ManuCode: "J14", ManuName: "Jon 14");
db.ManuFacts.UpdateByManuCode(ManuCode: "J14", LeadTime: "14");
db.ManuFacts.DeleteByLeadTime("14");
}