Ejemplo n.º 1
0
        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 );
            }
        }
Ejemplo n.º 2
0
        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 );
            }
        }
Ejemplo n.º 3
0
        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 );
            }
        }
Ejemplo n.º 4
0
        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 );
            }
        }
Ejemplo n.º 5
0
        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;
            }
        }