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);
}
