- Uncategorised posts -

emp = new EmployeeBLL
{
    ID = Convert.ToString(rdr["ID"]),
    Name = Convert.ToString(rdr["Name"]),
    Gender = Convert.ToString(rdr["Gender"]),
    Email = Convert.ToString(rdr["Email"]),
    Roles = Convert.ToString(rdr["Roles"]),
};

using (var connection = new SqlConnection("..."))
{
    List<EmployeeBLL> employees = connection.Query<EmployeeBLL>(
        "SELECT ID, Name, Gender, Email, Roles FROM YourTable WHERE SomeCondition = @SomeParameter", 
        new { SomeParameter = "some value" })
        .ToList();
    ...
}

using (var connection = new SqlConnection("..."))
using (var command = new SqlCommand("SELECT ID, Name, Gender, Email, Roles FROM YourTable WHERE SomeCondition = @SomeParameter", connection))
{
    command.Parameters.AddWithValue("@SomeParameter", "some value");
    
    connection.Open();
    using (var reader = command.ExecuteReader(CommandBehavior.CloseConnection))
    {
        if (reader.HasRows)
        {
            List<EmployeeBLL> employees = Mapper.DynamicMap<IDataReader, List<EmployeeBLL>>(reader);
            ...
        }
    }
}