public static void InsertThenDelete_TypedRow(ICRUDDataStore store)
{
for (var i = 0; i < 10; i++)
{
store.Insert(new Patient
{
SSN = i.ToString(),
First_Name = "Jack",
Last_Name = "Kozloff_" + i,
DOB = new DateTime(1980, 1, 12)
});
}
var result = store.Load(new Query("CRUD.Patient.List", typeof(Patient))
{
new Query.Param("LN", "%loff_5")
})[0];
Assert.AreEqual(1, result.Count);
var row = result[0] as Patient;
Assert.AreEqual("5", row.SSN);
store.Delete(row);
result = store.Load(new Query("CRUD.Patient.List", typeof(Patient))
{
new Query.Param("LN", "%loff_5")
})[0];
Assert.AreEqual(0, result.Count);
result = store.Load(new Query("CRUD.Patient.List", typeof(Patient))
{
new Query.Param("LN", "%loff_%")
})[0];
Assert.AreEqual(9, result.Count);
}
public static void InsertThenDelete_TypedRow(ICRUDDataStore store)
{
for(var i=0; i<10; i++)
{
store.Insert( new Patient
{
SSN = i.ToString(),
First_Name = "Jack",
Last_Name = "Kozloff_"+i,
DOB = new DateTime(1980, 1, 12)
});
}
var result = store.Load( new Query("CRUD.Patient.List", typeof(Patient) ) { new Query.Param("LN", "%loff_5") } )[0];
Assert.AreEqual(1, result.Count);
var row = result[0] as Patient;
Assert.AreEqual("5", row.SSN);
store.Delete( row );
result = store.Load( new Query("CRUD.Patient.List", typeof(Patient) ) { new Query.Param("LN", "%loff_5") } )[0];
Assert.AreEqual(0, result.Count);
result = store.Load( new Query("CRUD.Patient.List", typeof(Patient) ) { new Query.Param("LN", "%loff_%") } )[0];
Assert.AreEqual(9, result.Count);
}