❔ Best practice to retrieve MySQL columns

Hello wonderful people!

Can you please help me understanding what would be the best practice to retrieve values of specific columns when I use MySQL query?

Currently, I just hardcode names but this doesn't seem to be the ideal situation.

I see that I can create an enum for the names and use Enum.Login.ToString()

Or

I can index it (like reader[0])

But both options has its flows as I can change the column name / change the order.

What is the best practice to get specific columns? Or what method you personally use for a smaller scale application?

while (reader.Read())
{
    User user = new User
    {
        Login = (string)reader["login"],
        TeacherFlag = Convert.ToBoolean(reader["teacher_flag"]),
        AdminFlag = Convert.ToBoolean(reader["admin_flag"])

    };
    Login.SetCurrentUser(user);
}

while (reader.Read())
{
    User user = new User
    {
        Login = (string)reader["login"],
        TeacherFlag = Convert.ToBoolean(reader["teacher_flag"]),
        AdminFlag = Convert.ToBoolean(reader["admin_flag"])

    };
    Login.SetCurrentUser(user);
}

C#•4y ago•

2 replies

captainbulba

❔ Best practice to retrieve MySQL columns

while (reader.Read())
{
    User user = new User
    {
        Login = (string)reader["login"],
        TeacherFlag = Convert.ToBoolean(reader["teacher_flag"]),
        AdminFlag = Convert.ToBoolean(reader["admin_flag"])

    };
    Login.SetCurrentUser(user);
}

while (reader.Read())
{
    User user = new User
    {
        Login = (string)reader["login"],
        TeacherFlag = Convert.ToBoolean(reader["teacher_flag"]),
        AdminFlag = Convert.ToBoolean(reader["admin_flag"])

    };
    Login.SetCurrentUser(user);
}

❔ Best practice to retrieve MySQL columns

Similar Threads

❔ Best practice to retrieve MySQL columns

Similar Threads

Similar Threads

Similar Threads