public static void QueryInsertQuery_TypedRow(ICRUDDataStore store) { var query = new Query("CRUD.Patient.List", typeof(Patient)) { new Query.Param("LN", "%loff") }; var result = store.Load(query); Assert.AreEqual(1, result.Count); var rowset = result[0]; Assert.AreEqual(0, rowset.Count); var row = new Patient(); row.SSN = "999-88-9012"; row.First_Name = "Jack"; row.Last_Name = "Kozloff"; row.DOB = new DateTime(1980, 1, 12); Assert.IsNull(row.Validate()); store.Insert(row); result = store.Load(query); Assert.AreEqual(1, result.Count); rowset = result[0]; Assert.AreEqual(1, rowset.Count); Assert.IsInstanceOf <Patient>(rowset[0]); Assert.AreEqual("Jack", rowset[0]["First_Name"]); }
public static void QueryInsertQuery_DynamicRow(ICRUDDataStore store) { var query = new Query <DynamicRow>("CRUD.Patient.List") { new Query.Param("LN", "%ruman") }; var result = store.Load(query); Assert.AreEqual(1, result.Count); var rowset = result[0]; Assert.AreEqual(0, rowset.Count); var row = new Patient(); row.SSN = "999-88-9012"; row.First_Name = "Mans"; row.Last_Name = "Skolopendruman"; row.DOB = new DateTime(1970, 1, 12); Assert.IsNull(row.Validate()); store.Insert(row); var row2 = store.LoadRow(query); Assert.IsNotNull(row2); Assert.IsInstanceOf <DynamicRow>(row2); Assert.AreEqual("Mans", row2["First_Name"]); }
public static void QueryInsertQuery_TypedRow(ICRUDDataStore store) { var query = new Query("CRUD.Patient.List", typeof(Patient) ) { new Query.Param("LN", "%loff") }; var result = store.Load( query ); Assert.AreEqual(1, result.Count); var rowset = result[0]; Assert.AreEqual(0, rowset.Count); var row = new Patient(); row.SSN = "999-88-9012"; row.First_Name = "Jack"; row.Last_Name = "Kozloff"; row.DOB = new DateTime(1980, 1, 12); Assert.IsNull( row.Validate()); store.Insert(row); result = store.Load( query ); Assert.AreEqual(1, result.Count); rowset = result[0]; Assert.AreEqual(1, rowset.Count); Assert.IsInstanceOf<Patient>( rowset[0] ); Assert.AreEqual("Jack", rowset[0]["First_Name"]); }
public static void QueryInsertQuery_DynamicRow(ICRUDDataStore store) { var query = new Query<DynamicRow>("CRUD.Patient.List") { new Query.Param("LN", "%ruman") }; var result = store.Load( query ); Assert.AreEqual(1, result.Count); var rowset = result[0]; Assert.AreEqual(0, rowset.Count); var row = new Patient(); row.SSN = "999-88-9012"; row.First_Name = "Mans"; row.Last_Name = "Skolopendruman"; row.DOB = new DateTime(1970, 1, 12); Assert.IsNull( row.Validate()); store.Insert(row); var row2 = store.LoadRow( query ); Assert.IsNotNull(row2); Assert.IsInstanceOf<DynamicRow>( row2 ); Assert.AreEqual("Mans", row2["First_Name"]); }