public void Delete() { using( ISession session = SessionFactory.CreateDefaultSession() ) { Person person = new Person(); person.Id = 2; int i = session.Delete( person ); Assert.AreEqual<int>( 1, i ); } }
public void Find() { using( ISession session = SessionFactory.CreateDefaultSession() ) { var person = new Person() { Name = "test", Age = 20, Money = 100, CreateTime = DateTime.Now, IsActive = true }; session.Insert( person ); int id = session.GetIndentifer<int>(); var queryable = session.Find<Person>().Where( s => s.Id == id ); // 测试 Single 函数 person = queryable.Single(); Assert.AreEqual( "test", person.Name ); Assert.AreEqual( 20, person.Age.Value ); Assert.AreEqual( 100, person.Money.Value ); Assert.AreEqual( true, person.IsActive ); // 测试 SingleOrDefault 函数 person = queryable.SingleOrDefault(); Assert.AreEqual( "test", person.Name ); Assert.AreEqual( 20, person.Age.Value ); Assert.AreEqual( 100, person.Money.Value ); Assert.AreEqual( true, person.IsActive ); // 测试 First 函数 person = queryable.First(); Assert.AreEqual( "test", person.Name ); Assert.AreEqual( 20, person.Age.Value ); Assert.AreEqual( 100, person.Money.Value ); Assert.AreEqual( true, person.IsActive ); // 测试 FirstOrDefault 函数 person = queryable.FirstOrDefault(); Assert.AreEqual( "test", person.Name ); Assert.AreEqual( 20, person.Age.Value ); Assert.AreEqual( 100, person.Money.Value ); Assert.AreEqual( true, person.IsActive ); // 测试 Count 函数 Assert.AreEqual( 1, queryable.Count() ); // 测试 ToList 函数 var list = queryable.ToList(); Assert.AreEqual( 1, list.Count() ); // 测试包含多个 Where 条件 queryable = session.Find<Person>() .Where( s => s.Id == id ) .Where( s => s.Name == "test" ) .Where( s => s.Age == 20 && s.IsActive == true ); Assert.AreEqual( 1, queryable.Count() ); Console.WriteLine( SqlCmd.Current.Sql ); } }
public void Update() { using( ISession session = SessionFactory.CreateDefaultSession() ) { Person person = new Person(); person.Id = 2; person.Age = 32; person.Money = 132.23m; person.CreateTime = DateTime.Now; int i = session.Update( person ); Assert.AreEqual<int>( 1, i ); } }
public void UpdateT() { using( ISession session = SessionFactory.CreateDefaultSession() ) { Person person = new Person(); person.Age = 23; person.CreateTime = DateTime.Now; int i = session.Update<Person>() .Set( person ) .Where( s => s.Id == 3 ) .Execute(); Assert.AreNotEqual<int>( 0, i ); } }
public void Insert() { using( ISession session = SessionFactory.CreateDefaultSession() ) { Person person = new Person(); person.Name = "testuser01"; person.Age = 30; person.Money = 1999.23m; person.CreateTime = DateTime.Now; person.IsActive = true; session.Insert( person ); SqlCmd command = SqlCmd.Current; } }