public void InsertAccountFromObject() { Guid g = StopWatch.Start(); Account acc = new Account() { AccountID = 88888888, Name = "Test Account", AccountTypeID = 1, DatasourceID = 1, StateID = 1, CreatedBy = 1, CreatedOn = DateTime.Now, ModifiedBy = 1, ModifiedOn = DateTime.Now, OwningUserID = 1, OwningBusinessUnitID = 1 }; SqlBuilder builder = TypeBuilder.Insert<Account>(acc); Console.WriteLine(builder.ToSql()); ResultTable result = builder.Execute(); Assert.IsTrue(result.Count == 1); decimal i = result.First().Column<decimal>("AccountID"); Console.WriteLine("Inserted Account {0}", i); SqlBuilder b1 = SqlBuilder.Delete() .From("account", null) .Where<decimal>("account", "AccountID", SqlOperators.Equal, i) .Builder; i = new SqlBuilder[] { b1 }.ExecuteNonQuery(); Console.WriteLine("{0} Accounts deleted", i); Assert.IsTrue(i == 1); }