What the best way working with MySQL in MVC 3?

Question

Now, for every model in my MVC 3 app I create data class (in separate directory) were store a code which working direct with MySQL:

public Models.Inflation Select(int id)
            {
                Models.Inflation inflation = new Models.Inflation();
                MySqlConnection connection = new MySqlConnection(ConnectionString.ConnectionStringMySQL);
                MySqlCommand command = new MySqlCommand("SELECT " +
                    "inflation.monthInf, " +
                     "inflation.indexInflation " +
                    "FROM " +
                    "inflation " +
                    "WHERE id=@id " +
                    "ORDER BY inflation.monthInf ASC",
                    connection);
                command.Parameters.AddWithValue("@id", id);
                MySqlDataReader reader = null;
                try
                {
                    connection.Open();
                    reader = command.ExecuteReader();
                    while (reader.Read())
                    {
                        inflation.ID = id;
                        inflation.Date = DateTime.Parse(reader["monthInf"].ToString());
                        inflation.IndexInflation = decimal.Parse(reader["indexInflation"].ToString());
                    }
                }
                catch (Exception ex)
                {

                }
                finally
                {
                    if (reader != null)
                        reader.Close();
                    connection.Close();
                }
                return inflation;
            }

But this method very tedious (for every Model class I must create Select, Insert, Delete, Edit...). How to improve the development and not using Entity Framework (ORM difficult to connect in my hosting).?

Harvinder · Accepted Answer · 2011-12-27 16:18:41Z

1

You can use Microsoft Enterprise libraries. And in later stage if would like to migrate from MySql to SqlServer datebase you can do this by just changing your connection string.

answered Dec 27, 2011 at 16:18

Harvinder

892 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

What the best way working with MySQL in MVC 3?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related