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