- Source code on github
DbShell is free and opensource toolkit for automation of database operations. It is licensed under LGPL license. The list of supported contains MS SQL Server, SQLite, MySQL, PostgreSQL
DbShell can be used in two different ways:
This very simple example exports data of table Album into CSV file. This example uses DbShell Script notation.
SetConnection("sqlserver://Data Source=localhost\SQLEXPRESS;Integrated Security=SSPI;Initial Catalog=Chinook"); CopyTable( source = Table("album"), target = File("album.csv") )
DbShell is available as collection of NuGet packages (all functionality is contained in package DbShell.All ) . DbShell uses .NET Standard 2.0 - therefore is usable in .NET 4.6.1 and later or .NET Core 2.0 and later.
The same task implemented in C# will look like: