C#•3y ago

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

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

Angius•2/2/23, 6:15 PM

It'd be best to use something like Dapper to map the results of the query to objects

Accord•2/3/23, 6:34 PM

Was this issue resolved? If so, run

/close

/close

otherwise I will mark this as stale and this post will be archived until there is new activity.

❔ Best practice to retrieve MySQL columns

Similar Threads

Similar Threads

Similar Threads