public SQLiteTable(SQLiteCommand cmd, string name)
{
_name = name;
string sql = string.Format("SELECT sql FROM sqlite_master WHERE type='table' AND tbl_name='{0}';", name);
_createTableSql = QueryExpress.ExecuteScalarStr(cmd, sql, 0).Replace(Environment.NewLine, "^~~~~~~^").
Replace("\r", "^~~~~~~^").Replace("\n", "^~~~~~~^").Replace("^~~~~~~^", " ").
Replace("CREATE TABLE ", "CREATE TABLE IF NOT EXISTS ") + ";";
_lst = new SQLiteColumnList(cmd, name);
GetInsertStatementHeaders();
}
public void SetCols(SQLiteColumnList cols)
{
Columns = cols;
}
public void Dispose()
{
_lst.Dispose();
_lst = null;
}