CustomerQueries.cs

public class Customer
{
   public string FirstName { get; set; }
   public string LastName { get; set; }
   public string ZipCode { get; set; }
}

public List<Customer> GetCustomersByState(string state)
{
   var dbConnection = new SqlConnection("SomeConnectionString");
   
   string sql = @"SELECT FirstName, 
                         LastName,
                         ZipCode
                  FROM Customers
                  WHERE State = @State";
   
   var parameters = new DynamicParameters();
   parameters.Add("State", state);
   
   return dbConnection.Query<Customer>(sql, parameters).ToList();
}