123456789101112131415161718192021 |
- using MySql.Data.MySqlClient;
- using System.Configuration;
- using System.Data;
- namespace GCAS.Code
- {
- public class DataBaseConfig
- {
- private static readonly string DefaultSqlConnectionString = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None).ConnectionStrings.ConnectionStrings["myconn"].ToString();
- public static IDbConnection GetSqlConnection(string sqlConnectionString = null)
- {
- if (string.IsNullOrEmpty(sqlConnectionString))
- {
- sqlConnectionString = DefaultSqlConnectionString;
- }
- IDbConnection conn = new MySqlConnection(sqlConnectionString);
- conn.Open();
- return conn;
- }
- }
- }
|