/// <summary>
/// Constructor takes a database communicator object. If the file in question is already
/// being watched, this is ignored. Otherwise, the file is watched by a system file watcher
/// object.
/// </summary>
/// <param name="comms">Database Communicator Model</param>
public DatabaseHandler(DatabaseCommunicator comms)
{
Communicator = comms;
dcm = new DatabaseConnectionManager(comms.DbType, comms.ConnectionString, comms.Query, true);
StartWatchingDatabase();
}
public void ConnectToSQLServerDatabase()
{
var connextionString = Configuration.DefaultConnectionString;
var query = "SELECT TOP 5 * FROM [SCIPA].[dbo].[Values]";
var dcm = new DatabaseConnectionManager(DatabaseType.SQL, connextionString, query, true);
dcm.Execute();
}
public void ConnectToSQLServerDatabase()
{
var connextionString = @"provider=System.Data.SqlClient;provider connection string="data source=.;initial catalog=SCIPA;integrated security=True;MultipleActiveResultSets=True;App=EntityFramework";
var query = "SELECT TOP 5 * FROM [SCIPA].[dbo].[Values]";
var dcm = new DatabaseConnectionManager(DatabaseType.SQL, Configuration.DefaultConnectionString,query,true);
dcm.Execute();
}
