DataBaseConfig.cs 732 B

123456789101112131415161718192021
  1. using MySql.Data.MySqlClient;
  2. using System.Configuration;
  3. using System.Data;
  4. namespace GCAS.Code
  5. {
  6. public class DataBaseConfig
  7. {
  8. private static readonly string DefaultSqlConnectionString = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None).ConnectionStrings.ConnectionStrings["myconn"].ToString();
  9. public static IDbConnection GetSqlConnection(string sqlConnectionString = null)
  10. {
  11. if (string.IsNullOrEmpty(sqlConnectionString))
  12. {
  13. sqlConnectionString = DefaultSqlConnectionString;
  14. }
  15. IDbConnection conn = new MySqlConnection(sqlConnectionString);
  16. conn.Open();
  17. return conn;
  18. }
  19. }
  20. }