Class IL2SQL

Namespace

NominalSystems.Core

Assembly

NominalSystems.Core.dll

[NominalSystems] A SQL encoder/decoder for C# objects

public static class IL2SQL

Inheritance

object

IL2SQL

Methods

AddColumn(SqliteConnection, string, string)

TODO: Harrison - THIS NEEDS A DESCRIPTION

public static bool AddColumn(SqliteConnection db, string table, string column)

Parameters

db SqliteConnection

table string

column string

Returns

bool

Close(SqliteConnection)

public static void Close(SqliteConnection db)

Parameters

db SqliteConnection

ColumnNames(SqliteConnection, string)

TODO: THIS NEEDS A DESCRIPTION

public static string[] ColumnNames(SqliteConnection db, string table)

Parameters

db SqliteConnection

table string

Returns

string[]

ColumnTypes(SqliteConnection, string)

TODO: THIS NEEDS A DESCRIPTION

public static string[] ColumnTypes(SqliteConnection db, string table)

Parameters

db SqliteConnection

table string

Returns

string[]

CreateTable(SqliteConnection, string, params string[])

TODO: THIS NEEDS A DESCRIPTION

public static bool CreateTable(SqliteConnection db, string table, params string[] columns)

Parameters

db SqliteConnection

table string

columns string[]

Returns

bool

DeleteColumn(SqliteConnection, string, string)

TODO: THIS NEEDS A DESCRIPTION

public static bool DeleteColumn(SqliteConnection db, string table, string column)

Parameters

db SqliteConnection

table string

column string

Returns

bool

DeleteRecord(SqliteConnection, string, string)

TODO: THIS NEEDS A DESCRIPTION

public static bool DeleteRecord(SqliteConnection db, string table, string condition)

Parameters

db SqliteConnection

table string

condition string

Returns

bool

DeleteTable(SqliteConnection, string)

TODO: THIS NEEDS A DESCRIPTION

public static bool DeleteTable(SqliteConnection db, string table)

Parameters

db SqliteConnection

table string

Returns

bool

GetColumnIntegers(SqliteConnection, string, string, string)

TODO: THIS NEEDS A DESCRIPTION

public static long[] GetColumnIntegers(SqliteConnection db, string table, string condition, string column)

Parameters

db SqliteConnection

table string

condition string

column string

Returns

long[]

InsertRecord(SqliteConnection, string, params string[])

TODO: THIS NEEDS A DESCRIPTION

public static bool InsertRecord(SqliteConnection db, string table, params string[] values)

Parameters

db SqliteConnection

table string

values string[]

Returns

bool

Open(string)

public static SqliteConnection Open(string path)

Parameters

path string

path to database

Returns

SqliteConnection

Query(SqliteConnection, string)

TODO: THIS NEEDS A DESCRIPTION

public static string[] Query(SqliteConnection db, string query)

Parameters

db SqliteConnection

query string

Returns

string[]

RowCount(SqliteConnection, string)

TODO: THIS NEEDS A DESCRIPTION

public static int RowCount(SqliteConnection db, string table)

Parameters

db SqliteConnection

table string

Returns

int

SelectColumn(SqliteConnection, string, string, string)

TODO: THIS NEEDS A DESCRIPTION

public static string SelectColumn(SqliteConnection db, string table, string condition, string column)

Parameters

db SqliteConnection

table string

condition string

column string

Returns

string

SelectRecord(SqliteConnection, string, string, params string[])

TODO: THIS NEEDS A DESCRIPTION

public static string[] SelectRecord(SqliteConnection db, string table, string condition, params string[] columns)

Parameters

db SqliteConnection

table string

condition string

columns string[]

Returns

string[]