与MVC3的MySql数据库连接 [英] MySql Database Connection with MVC3

问题描述

你好...


我正在使用Visual Studio 2010 Express Edition.
我正在使用MVC3.net查找MySql数据库连接
实际上，这种方式我想使用数据库优先方法.
在哪里可以从MySQL获取数据库和表.

我试图制作一个DSN，但是当我在模型中添加ADO.NET实体框架时，它也没有出现在数据提供者列表中.因此，我无法从我的MVC3应用程序中的MYSQL获取数据库和表.


我一直在寻找这个.并阅读有关.net MVC的文章，但找不到正确的方法.


请指导我...


问候
Manish Kumnar Namdev

Hello...


I''m using Visual Studio 2010 express edition.
I am looking MySql Database Connection with MVC3.net
Actually this way I want to use database first approach.
Where I can get database and tables from MySQL.

I tried to make a DSN but when I add ADO.NET Entity Frame Work in Models it doesn''t appear in Data Provider list also. There fore I am not able to get the database and tables from MYSQL in my MVC3 application.


I''m looking for this so long. and read the articles for .net MVC but couldn''t get the right way..


Please guide me...


Regards
Manish Kumnar Namdev

推荐答案

using MySql.Data.MySqlClient;
using System.Data;
using System;
using System.Data.Common;
class DbHelper
{
    public MySqlConnection con = new MySqlConnection("server=localhost;userid=root;password=root;database=dothrmproxy");
// ConnectionString
    public MySqlCommand cmd;
    public MySqlDataAdapter Mdr;   

    public int Execute(string query)
    {
        int i = 0;
        try
        {
            con.Open();
            cmd = new MySqlCommand(query, con);
            i = cmd.ExecuteNonQuery();
        }
        catch
        {
            i = -1;
        }
        finally
        {
            con.Close();
        }
        return i;
    }
    public int Execute(string commandtext,object [,]parameter,CommandType ct)
    {
        int i = 0;
        try
        {
            con.Open();
            cmd = new MySqlCommand(commandtext, con);
            cmd.CommandType = ct;
            MySqlParameter oParameter;
            for (int j = 0; j < parameter.Length / 2; j++)
            {
                oParameter = cmd.CreateParameter();
                oParameter.ParameterName = parameter[j, 0].ToString();
                oParameter.Value = parameter[j, 1];
                cmd.Parameters.Add(oParameter);
            }
            i = cmd.ExecuteNonQuery();
        }
        catch
        {
            i = -1;
        }
        finally
        {
            con.Close();
        }
        return i;
    }
    public DataTable GetTable(string query)
    {
        DataTable result = new DataTable();
        try
        {
            Mdr = new MySqlDataAdapter(query, con);
            if (con.State == ConnectionState.Closed)
                con.Open();
            Mdr.Fill(result);
            return result;
        }
        catch (Exception err)
        { return result; }
        finally
        {
            con.Close();
        }
    }
    public DataSet GetSet(string query)
    {
        DataSet result = new DataSet();
        try
        {
            Mdr = new MySqlDataAdapter(query, con);
            if (con.State == ConnectionState.Closed)
                con.Open();
            Mdr.Fill(result);
            return result;
        }
        catch (Exception err)
        { return result; }
        finally
        {
            con.Close();
        }
    }

}

这篇关于与MVC3的MySql数据库连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！