public void TestInsert() { Category category = new Category(); category.Name = "toto"; category.Guid = Guid.Empty; int key = (int)sqlMap.Insert("InsertCategoryGenerate", category); Assert.AreEqual(1, key); }
public void TestInsertSelectKey() { Category category = new Category(); category.Name = "toto"; category.Guid = Guid.NewGuid(); int key = (int)sqlMap.Insert("Category.InsertCategoryViaInsertStatement", category); Assert.AreEqual(1, key); }
public void TestInsertCategoryViaParameterMap() { Category category = new Category(); category.Name = "Cat"; category.Guid = Guid.NewGuid(); int key = (int)sqlMap.Insert("InsertCategoryViaParameterMap", category); Assert.AreEqual(1, key); }
public void TestInsertAutonumberViaInsertQuery() { Category category = new Category(); category.Name = "toto"; category.Guid = Guid.NewGuid(); int key = (int)sqlMap.Insert("InsertCategory", category); Assert.AreEqual(1, key); }
public void TestMultipleResultClass() { Category category = new Category(); category.Name = "toto"; category.Guid = Guid.NewGuid(); int key = (int)sqlMap.Insert("InsertCategory", category); IList list = sqlMap.QueryForList("GetMultipleResultClass", null); Assert.AreEqual(2, list.Count); }
public void GenericTestGuidColumn() { Category category = new Category(); category.Name = "toto"; category.Guid = Guid.NewGuid(); int key = (int)sqlMap.Insert("InsertCategory", category); Category categoryTest = sqlMap.QueryForObject<Category>("GetCategory", key); Assert.AreEqual(key, categoryTest.Id); Assert.AreEqual(category.Name, categoryTest.Name); Assert.AreEqual(category.Guid, categoryTest.Guid); }
public void InsertTestSequenceViaProcedure() { Category category = new Category(); category.Name = "Mapping object relational"; sqlMap.Insert("InsertCategoryViaStoreProcedure", category); Assert.AreEqual(1, category.Id ); category = new Category(); category.Name = "Nausicaa"; sqlMap.Insert("InsertCategoryViaStoreProcedure", category); Assert.AreEqual(2, category.Id ); }
public void TestDelete() { Category category = new Category(); category.Name = "toto"; category.Guid = Guid.NewGuid(); int key = (int)sqlMap.Insert("InsertCategoryGenerate", category); category.Id = key; Assert.AreEqual(1, category.Id); sqlMap.Delete("DeleteCategoryGenerate", category); Category categoryRead = null; categoryRead = sqlMap.QueryForObject("GetCategory", key) as Category; Assert.IsNull(categoryRead); }
public void TestSelectAll() { Category category = new Category(); category.Name = "toto"; category.Guid = Guid.NewGuid(); int key = (int)sqlMap.Insert("InsertCategoryGenerate", category); Assert.AreEqual(1, key); category.Name = "toto"; category.Guid = Guid.NewGuid(); key = (int)sqlMap.Insert("InsertCategoryGenerate", category); Assert.AreEqual(2, key); IList categorieList = sqlMap.QueryForList("SelectAllCategoryGenerate",null) as IList; Assert.AreEqual(2, categorieList.Count); }
public void TestUpdate() { Category category = new Category(); category.Name = "Cat"; category.Guid = Guid.NewGuid(); int key = (int)sqlMap.Insert("InsertCategoryGenerate", category); category.Id = key; category.Name = "Dog"; category.Guid = Guid.NewGuid(); sqlMap.Update("UpdateCategoryGenerate", category); Category categoryRead = null; categoryRead = (Category) sqlMap.QueryForObject("GetCategory", key); Assert.AreEqual(category.Id, categoryRead.Id); Assert.AreEqual(category.Name, categoryRead.Name); Assert.AreEqual(category.Guid.ToString(), categoryRead.Guid.ToString()); }
public void TestSelectByPK() { Category category = new Category(); category.Name = "toto"; category.Guid = Guid.NewGuid(); category.Id = (int)sqlMap.Insert("InsertCategoryGenerate", category); Assert.AreEqual(1, category.Id); // Workaround! // Null out unneeded properties, otherwise those property values will be added // as command parameters for the auto-generated SELECT query even if // only 1 parameter for Id is needed. category.Name = null; category.Guid = Guid.Empty; Category categoryRead = null; categoryRead = (Category) sqlMap.QueryForObject("SelectByPKCategoryGenerate", category); Assert.AreEqual(category.Id, categoryRead.Id); Assert.AreEqual(category.Name, categoryRead.Name); Assert.AreEqual(category.Guid.ToString(), categoryRead.Guid.ToString()); }
public void TestJIRA176() { Category category = new Category(); category.Name = "toto"; category.Guid = Guid.Empty; int key = (int)sqlMap.Insert("InsertCategory", category); ImmutableCategoryPropertyContainer categoryContainerFromDB = (ImmutableCategoryPropertyContainer)sqlMap.QueryForObject("GetImmutableCategoryInContainer", key); Assert.IsNotNull(categoryContainerFromDB); Assert.IsNotNull(categoryContainerFromDB.ImmutableCategory); Assert.AreEqual(category.Name, categoryContainerFromDB.ImmutableCategory.Name); Assert.AreEqual(key, categoryContainerFromDB.ImmutableCategory.Id); Assert.AreEqual(category.Guid, categoryContainerFromDB.ImmutableCategory.Guid); }
public void TestDynamicWithGUID() { Category category = new Category(); category.Name = "toto"; category.Guid = Guid.Empty; int key = (int)sqlMap.Insert("InsertCategory", category); category = new Category(); category.Name = "titi"; category.Guid = Guid.NewGuid(); Category categoryTest = (Category)sqlMap.QueryForObject("DynamicGuid", category); Assert.IsNull(categoryTest); category = new Category(); category.Name = "titi"; category.Guid = Guid.Empty; categoryTest = (Category)sqlMap.QueryForObject("DynamicGuid", category); Assert.IsNotNull(categoryTest); }
public void GenericTestUpdateCategoryWithExtendParameterMap() { Category category = new Category(); category.Name = "Cat"; category.Guid = Guid.NewGuid(); int key = (int)sqlMap.Insert("InsertCategoryViaParameterMap", category); category.Id = key; category.Name = "Dog"; category.Guid = Guid.NewGuid(); sqlMap.Update("UpdateCategoryViaParameterMap", category); Category categoryRead = null; categoryRead = sqlMap.QueryForObject<Category>("GetCategory", key); Assert.AreEqual(category.Id, categoryRead.Id); Assert.AreEqual(category.Name, categoryRead.Name); Assert.AreEqual(category.Guid.ToString(), categoryRead.Guid.ToString()); }
public void InsertTestIdentityViaProcedureWithReturn( ) { Category category = new Category ( ); category.Name = "Mapping object relational"; int categoryID = ( int ) sqlMap.Insert ( "InsertCategoryViaStoreProcedureWithReturn", category ); Assert.That(categoryID, Is.EqualTo(1)); Assert.That(category.Id, Is.EqualTo(1)); Category category2 = new Category ( ); category2.Name = "Nausicaa"; int categoryID2 = ( int ) sqlMap.Insert ( "InsertCategoryViaStoreProcedureWithReturn", category2 ); Assert.That(categoryID2, Is.EqualTo(2)); Assert.That(category2.Id, Is.EqualTo(2)); Category category3 = sqlMap.QueryForObject<Category> ( "GetCategory", categoryID2 ) ; Category category4 = sqlMap.QueryForObject<Category> ( "GetCategory", categoryID ); Assert.AreEqual ( categoryID2, category3.Id ); Assert.AreEqual ( category2.Name, category3.Name ); Assert.AreEqual ( categoryID, category4.Id ); Assert.AreEqual ( category.Name, category4.Name ); }
public void TestNullValueReplacementForGuidValue() { Category category = new Category(); category.Name = "Toto"; category.Guid = Guid.Empty; int key = (int)sqlMap.Insert("InsertCategoryNull", category); Category categoryRead = null; categoryRead = (Category)sqlMap.QueryForObject("GetCategoryWithNullValueReplacementGuid", key); Assert.AreEqual(category.Name, categoryRead.Name); Assert.AreEqual(category.Guid.ToString(), categoryRead.Guid.ToString()); }
public void TestSelectByPK() { Category category = new Category(); category.Name = "toto"; category.Guid = Guid.NewGuid(); category.Id = (int)sqlMap.Insert("InsertCategoryGenerate", category); Assert.AreEqual(1, category.Id); Category categoryRead = null; categoryRead = (Category) sqlMap.QueryForObject("SelectByPKCategoryGenerate", category); Assert.AreEqual(category.Id, categoryRead.Id); Assert.AreEqual(category.Name, categoryRead.Name); Assert.AreEqual(category.Guid.ToString(), categoryRead.Guid.ToString()); }
public void TestTimeSpan() { Guid newGuid = Guid.NewGuid();; Category category = new Category(); category.Name = "toto"; category.Guid = newGuid; int key = (int)sqlMap.Insert("InsertCategory", category); Guid guid = (Guid)sqlMap.QueryForObject("GetGuid", key); Assert.AreEqual(newGuid, guid); }
public void TestMultipleResultMap() { Category category = new Category(); category.Name = "toto"; category.Guid = Guid.NewGuid(); int key = (int)sqlMap.Insert("InsertCategory", category); IList list = sqlMap.QueryForList("GetMultipleResultMap", null); Assert.AreEqual(2, list.Count); Account account = list[0] as Account; Category saveCategory = list[01] as Category; AssertAccount1(account); Assert.AreEqual(key, saveCategory.Id); Assert.AreEqual(category.Name, saveCategory.Name); Assert.AreEqual(category.Guid, saveCategory.Guid); }
public void GenericTestInsertCategoryWithProperties() { Category category = new Category(); category.Guid = Guid.NewGuid(); int key = (int)sqlMap.Insert("InsertCategoryWithProperties", category); Category categoryTest = sqlMap.QueryForObject<Category>("GetCategory", key); Assert.AreEqual(key, categoryTest.Id); Assert.AreEqual("Film", categoryTest.Name); Assert.AreEqual(category.Guid, categoryTest.Guid); }
public void TestInsertCategoryScope() { Category category = new Category(); category.Name = "toto"; category.Guid = Guid.NewGuid(); sqlMap.QueryForObject("InsertCategoryScope", category, category); Assert.That(category.Id, Is.EqualTo(1)); }