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)); }