Examples

CreateTable("User")
     .Long("Id").PrimaryKeyWithIdentity()
     .String("Name", 70).NotNull().Unique().Indexed()
     .Boolean("IsRegistered", false)
     .DateTime("Birthday").NotNull()
     .Text("Description").Null()
     .Decimal("Salary", 10, 2)
     .Execute();

DropTable("Role");

Table("User").RenameTo("Users");

Table("User").AddColumn().Int("RoleId", 2).NotNull().Execute();

Table("User").DropColumn("RoleId");

Table("User").RenameColumn("Description", "PersonalInformation");

Table("User").AlterColumn().String("PersonalInformation", 1000).Execute();

Table("User").AddForeignKey("RoleId", "Role", "Id", OnDelete.SetDefault);

Table("Role").Insert(new { Name = "Administrator" });

Table("Role").Delete().Where(new { Name = "Administrator" });

Table("User").Insert(new
{
     RoleId = Table("Role").SelectScalar<int>("Id", new { Name = "Manager" }),
     FirstName = "Robert",
     LastName = "Tompson",
     IsRegistered = true,
     Birthday = new DateTime(1982, 4, 20)
});

IDataReader reader = ExecuteQuery("select Id, Name from User where IsRegistered = 0 or Description is null");

int value = (int)ExecuteScalar("select Id from User where IsRegistered = 1 or Description is null");

ExecuteNonQuery("delete from User where IsRegistered = 0 or Description is null");