Database commands for netbash
Switch branches/tags
Nothing to show
Clone or download
Pull request Compare This branch is 3 commits ahead, 1 commit behind lukencode:master.
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Failed to load latest commit information.
Netbash.Database.Sample
Netbash.Database
packages
.gitignore
NetBash.Database.nupkg
NetBash.Database.nuspec
Netbash.Database.sln
README.md

README.md

Download from NuGet - PM> Install-Package NetBash.Database

Simple commands to query your database with NetBash. ConnectionString name can be set with --conn=[yourdb] if it isnt set it will default to the first one found.

Usage: sql [OPTIONS] [QUERY]
Execute sql on your database using NetBash

Options:
  -e, --execute              Executes an sql query
  -t, --tables               Lists tables and space used optional filter on  provided table name
  -s, --schema               Display table schema for the provided table name
      --clear                Removes all rows from database
  -cn --cn					 Returns the connectionstring that will be used
  -lcn --lcn				 List all connectionstrings found in the config file
  -c, --conn=VALUE           name of connection string to use (defaults to first found)
  -h, --help                 show this list of options

Basic usage:

sql -e "select * from products"

Show All Tables:

sql -t [optional-filter]

Show Schema:

sql -t [table-name]