public DataTable ExecuteQuery(string query) { SqlConnection connection = new SqlConnection(DataAccessInfo.GetInstance().ConnectionString); try { connection.Open(); Console.WriteLine("Подключение открыто"); SqlCommand command = new SqlCommand(query, connection); var reader = command.ExecuteReader(); var resultTable = new DataTable(); resultTable.Load(reader); return(resultTable); } catch (SqlException ex) { throw new Exception("Connection to database failed."); } finally { connection.Close(); Console.WriteLine("Подключение закрыто..."); } }
public override IConnectionAccessClass GetConnectionAccessInstance() { DataAccessInfo.SetConnectionString(this.connectionString); var connectionAccess = DataAccessInfo.GetInstance(); return(new SqlServerConnectionAccessClass(connectionAccess.ConnectionString)); }
public static void SetConnectionString(string connectionString) { if (instance == null) { instance = new DataAccessInfo(); } instance.ConnectionString = connectionString; }
public static DataAccessInfo GetInstance() { if (instance == null) { instance = new DataAccessInfo(); } return(instance); }