public static User GetUser(string username)
{
string query = "SELECT id, password " +
"FROM users " +
"WHERE username = @username";
DbManager.PrepareQuery(query);
DbManager.BindValue("@username", username.ToLower());
var reader = DbManager.ExecutePreparedSelect();
reader.Read();
if (!reader.HasRows)
{
reader.Close();
return(null);
}
var id = reader.GetInt32(0);
var passwordHash = reader.GetString(1);
reader.Close();
return(new User(id, username, passwordHash));
}
public static void SelectWithPrepare()
{
var filter = "test";
const string query = "SELECT * FROM users WHERE username LIKE @filter";
_dbManagerAuth.PrepareQuery(query);
_dbManagerAuth.BindValue("@filter", $"%{filter}%");
var reader = _dbManagerAuth.ExecutePreparedSelect();
var foundUsers = new List <User>();
while (reader.Read())
{
var id = reader.GetInt32(0);
var username = reader.GetString(1);
foundUsers.Add(new User(id, username));
}
}
