Write-CRUD
Writes PowerShell commands to create a CRUD system around a table and partition in Azure

CRUD stands for Create, Read, Update, and Delete

Write-Crud creates the following commands.
  • Add-$Noun (aliased to New-$Noun and Create-$Noun)
  • Get-$Noun (aliased to Search-$Noun and Read-$Noun)
  • Update-$noun (aliased to Set-$Noun)
  • Remove-$Noun (aliased to Remove-$Noun)


Write-Crud can create tables with an arbitrary schema.

It can also use a well-known schemas, found at either http://schema.org or http://shouldbeonschema.org


The name of the table

The name of the partition

The Schema.org schema used for the table

The typename of the data in the field

The type of key used by the crud system

If set, the Read command in the CRUD system will automatically sort results as a type

The partition to look in for user names and ids

The noun to use for the generated command. If this is not set, the commands will have a noun named $Table$Partition

The verbs that will be generated. By default, Add, Get, Remove, and Update

If set, the CRUD system will be designed to work with users, and be able to query for my items or items of a user ID

If set, will not connect to storage

If set, will force uniquely named items

If set, will not convert markdown found in the table

The order of the fields

A description to use for the commands

If set, will only include a few fields from the schema

Any arbitrary fields to put into a custom CRUD system.

If set, will require certain fields

The SQL Connection String Setting

The storage account setting

The storage key setting

If set, will make these fields request multiple lines for input

If set, will make these fields editable HTML

The field on the object that references the read code object

The parition where read codes would be found

If set, the Read command in the CRUD system will automatically sort results