Exemplo n.º 1
0
        public void Test()
        {
            using (DbManager db = new DbManager())
            {
                PersonAccessor pa = /*[a]*/ DataAccessor.CreateInstance <PersonAccessor>(db) /*[/a]*/;

                pa.BeginTransaction();

                // Insert and get id.
                //
                Person person = new Person();

                person.FirstName = "Crazy";
                person.LastName  = "Frog";
                person.Gender    = Gender.Unknown;

                int id = pa./*[a]*/ Insert(person) /*[/a]*/;

                // SelectByName.
                //
                person = pa./*[a]*/ SelectByName("Crazy", "Frog") /*[/a]*/;

                Assert.IsNotNull(person);

                // Select top.
                //
                Dictionary <int, Person> dic = pa./*[a]*/ SelectTop(10) /*[/a]*/;

                Assert.IsTrue(dic.Count <= 10);

                // Delete.
                //
                pa.Query.Delete(person);

                pa.CommitTransaction();
            }
        }