Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- using MySql.Data.MySqlClient;
- using System.Data;
- public class MySqlContext : IDisposable
- {
- private MySqlConnection conn;
- private string serverAddress = "127.0.0.1";
- private string database = "dbtest";
- private string user = "root";
- private string password = "root";
- public MySqlContext()
- {
- string strConnection = String.Format("Data Source={0}; Initial Catalog={1}; User ID={2}; Password={3};", serverAddress, database, user, password);
- conn = new MySqlConnection(strConnection);
- }
- public MySqlDataReader GetReader(string sql, List<MySqlParameter> args)
- {
- if ((args == null) || (args.Count == 0))
- {
- return GetReader(sql);
- }
- else
- {
- return GetReader(sql, args.ToArray());
- }
- }
- public MySqlDataReader GetReader(string sql, MySqlParameter[] args = null)
- {
- MySqlCommand cmd = new MySqlCommand(sql, conn);
- cmd.CommandType = System.Data.CommandType.Text;
- if (conn.State == ConnectionState.Close)
- {
- conn.Open();
- }
- if (args != null)
- {
- cmd.Parameters.AddRange(args);
- }
- MySqlDataReader dr = cmd.ExecuteReader();
- return dr;
- }
- public void Dispose()
- {
- conn.Close();
- conn.Dispose();
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement