public static void Attach(SQLiteDatabaseConnection db, string path, string alias)
{
var commandText = string.Format("attach @path as {0};", alias);
using (var statement = db.PrepareStatement(commandText))
{
statement.TryBind("@path", path);
statement.MoveNext();
}
}
public string Query(string querytype, string datatype, string cmd)
{
var sql = (querytype == "GET") ? String.Format(GetValSql, cmd) : String.Format(SelectSql, cmd, datatype);
var stmt = db.PrepareStatement(sql);
stmt.MoveNext();
var result = stmt.Current[0].ToString();
//var val = stmt.Current[1].ToString();
return(result);
}
public IStatement PrepareStatement(string sql)
{
return(db.PrepareStatement(sql));
}
