LoginDAO

public class LoginDAO
{
    private Database myDatabase;
    private String myConnectionString;

    public LoginDAO()
    {
        myConnectionString = @"Data Source=(LocalDB)\v11.0;
        AttachDbFilename=|DataDirectory|\Database.mdf;
        Integrated Security=True;Connect Timeout=30";
        myDatabase = new Database();
    }

    public LoginRole GetLoginRole(string username, string password)
    {
        LoginRole loginRole = new LoginRole();
        IDataReader resultSet;

        try
        {

            myDatabase.Open(myConnectionString);

            String sqlText = String.Format(
               @"SELECT role
                   FROM rider
                   WHERE username = '{0}' AND password = '{1}'", username, password);

            resultSet = myDatabase.ExecuteQuery(sqlText);

            if(resultSet.Read() == true)
            {
                loginRole.Role = (String)resultSet["role"];
            }
            return loginRole;

        }
        catch (Exception)
        {
            return null;
        }
        finally
        {
            myDatabase.Close();
        }