public override void SelectByName(string name)
{
SQLConnectionExecutor.ExecuteSQLQuery(ConnectionString, "select * from SAMPLETABLE where NAME like '%" + name + "%'").ForEach(Console.WriteLine);
}
public override void ResetDB()
{
var resetStmt = EmbeddedResourceLoader.ReadFullContent("Scripts", "resetDB.sql");
SQLConnectionExecutor.ExecuteSQLNonQuery(ConnectionString, resetStmt);
}
public override void TestSQLQuery()
{
SQLConnectionExecutor.ExecuteSQLQuery(ConnectionString, "select * from SAMPLETABLE").ForEach(Console.WriteLine);
}
public override void TestConnect()
{
SQLConnectionExecutor.ExecuteSQLNonQuery(ConnectionString, ";");
}
