public static void Attach(ManagedConnection 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();
}
}
private User GetUser(Guid guid, ManagedConnection connection)
{
using (var statement = connection.PrepareStatement("select id,guid,data from LocalUsersv2 where guid=@guid"))
{
statement.TryBind("@guid", guid);
foreach (var row in statement.ExecuteQuery())
{
return(GetUser(row));
}
}
return(null);
}
public IStatement PrepareStatementSafe(ManagedConnection connection, string sql)
{
return(connection.PrepareStatement(sql));
}
public IStatement PrepareStatement(ManagedConnection connection, string sql) => connection.PrepareStatement(sql);
